写一点东西和大家交流
class SQLHelper
{
static string connstr = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
public static SqlDataReader ExecuteReader(string cmdText,params SqlParameter [] ps )
{
SqlConnection mycon = new SqlConnection(connstr);
try
{
using (SqlCommand mycom = new SqlCommand(cmdText, mycon))
{
mycom.Parameters.AddRange(ps);
mycon.Open();
return mycom.ExecuteReader(System.Data.CommandBehavior.CloseConnection);//这句就是关闭数据库
}
}
catch(Exception ex)
{
mycon.Dispose();
throw ex;
}
}
public static int ExecuteNonQuery(string cmdText,params SqlParameter [] ps)
{
using (SqlConnection mycon = new SqlConnection(connstr))
{
using (SqlCommand mycom = new SqlCommand(cmdText, mycon))
{
mycom.Parameters.AddRange(ps);
mycon.Open();
return mycom.ExecuteNonQuery();//返回受影响的行
}
}
}
public static object ExecuteScalar(string cmdText, params SqlParameter[] ps)
{
using (SqlConnection mycon = new SqlConnection(connstr))
{
using (SqlCommand mycom = new SqlCommand(cmdText, mycon))
{
mycom.Parameters.AddRange(ps);
mycon.Open();
return mycom.ExecuteScalar();//返回受影响的行
}
}
}
public static DataSet SqlDataAdapter(string cmdText)
{
DataSet ds = new DataSet();
using (SqlDataAdapter sda = new SqlDataAdapter(cmdText, connstr))
{
sda.Fill(ds);
return ds;
}
}
}