vs2010
这是什么意思?
代码如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;/// <summary>
///DBHelper 的摘要说明
/// </summary>
public class DBHelper
{
private SqlConnection con;
public DBHelper()
{
//
//TODO: 在此处添加构造函数逻辑
//
string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\bookshop.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection con = new SqlConnection(str);
}
public int ExecuteCommand(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, con);
con.Open();
int result = cmd.ExecuteNonQuery();
con.Close();
return result;
}
public int ExecuteCommand(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddRange(values);
con.Open();
int result = cmd.ExecuteNonQuery();
con.Close();
return result;
}
public int GetScalar(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, con);
con.Open();
int result = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return result;
}
public int GetScalar(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddRange(values);
con.Open();
int result = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return result;
}
public SqlDataReader GetReader(string safeSql)
{ SqlCommand cmd = new SqlCommand(safeSql, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return reader;
}
public SqlDataReader GetReader(string sql,params SqlParameter[] values)
{
SqlCommand cmd=new SqlCommand(sql,con);
cmd.Parameters.AddRange(values);
con.Open();
SqlDataReader reader=cmd.ExecuteReader(CommandBehavior.CloseConnection);
return reader;
}
public DataSet GetDataSet(string safeSql)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(safeSql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds; }
public DataSet GetDataSet(string safeSql ,params SqlParameter[] values)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(safeSql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds; }
// private void OpenConn()
// {
// if(con.State==ConnectionState.Closed)
// {
// con.Open();
// }
// }
// private void CloseConn()
// {
// if (con.State == ConnectionState.Open)
// {
// con.Close();
// }
//}
}
这是什么意思?
代码如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;/// <summary>
///DBHelper 的摘要说明
/// </summary>
public class DBHelper
{
private SqlConnection con;
public DBHelper()
{
//
//TODO: 在此处添加构造函数逻辑
//
string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\bookshop.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection con = new SqlConnection(str);
}
public int ExecuteCommand(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, con);
con.Open();
int result = cmd.ExecuteNonQuery();
con.Close();
return result;
}
public int ExecuteCommand(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddRange(values);
con.Open();
int result = cmd.ExecuteNonQuery();
con.Close();
return result;
}
public int GetScalar(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, con);
con.Open();
int result = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return result;
}
public int GetScalar(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddRange(values);
con.Open();
int result = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return result;
}
public SqlDataReader GetReader(string safeSql)
{ SqlCommand cmd = new SqlCommand(safeSql, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return reader;
}
public SqlDataReader GetReader(string sql,params SqlParameter[] values)
{
SqlCommand cmd=new SqlCommand(sql,con);
cmd.Parameters.AddRange(values);
con.Open();
SqlDataReader reader=cmd.ExecuteReader(CommandBehavior.CloseConnection);
return reader;
}
public DataSet GetDataSet(string safeSql)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(safeSql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds; }
public DataSet GetDataSet(string safeSql ,params SqlParameter[] values)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(safeSql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds; }
// private void OpenConn()
// {
// if(con.State==ConnectionState.Closed)
// {
// con.Open();
// }
// }
// private void CloseConn()
// {
// if (con.State == ConnectionState.Open)
// {
// con.Close();
// }
//}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货