ADO.net SqlHelper类代码
亲！你能一次性通过Sqlhelper类吗
public static readonly string conStr=ConfigurationManager.ConnectionStrings["conStr"].tostring();
注意readonly不要掉了，加上更安全
ConfirurationManager.ConnectionStrings[]......是ConnectionStrings不是ConnectionString,我老在这犯错
ExecuteNonQuery:
注意conn.Open()放的最优的位置
public static int ExecuteNonQuery(string sql,CommandType type,params SqlParameter[] param)
{
using(SqlConnection conn = new SqlConnection(conStr))
{
using(SqlCommand cmd = new SqlCommand(sql,conn))
{
if(param!=null)
{
cmd.Parameters.AddRange(param);
}
cmd.CommandType = type;
conn.Open();
return cmd.ExecuteNonQuery();
}
}
}
ExecuteScalar:
public static object ExecuteScalar(string sql,CommandType type,params SqlParameter[] param)
{
using(SqlConnection conn = new SqlConnection(conStr))
{
using(SqlCommand cmd = new SqlCommand(sql,conn))
{
if(param!=null)
{
cmd.Parameters.AddRange(param);
}
cmd.CommandType = type;
conn.Open;
return cmd.ExecuteScalar();
}
}
}
ExecuteReader:
public static SqlDataReader ExecuteReader(string sql,CommandType type,params SqlParameter[] param)
{
SqlConnection conn = new SqlConnection(conStr);
using(SqlCommand cmd = new SqlCommand(sql,conn))
{
if(param!=null)
{
cmd.Parameters.AddRange(param);
}
cmd.CommandType = type;
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
ExecteAdapter:
public static DataTable ExecteAdapter(string sql,CommandType type,params SqlParameter[] param)
{
using(SqlDataAdapter adapter = new SqlDataAdapter(sql,conStr))
{
SqlCommand cmd = adapter.SelectCommand;
if(param!=null)
{
cmd.Parameters.AddRange(param);
}
cmd.CommandType = type;
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
}
优质内容筛选与推荐>>1、python可视化---title()函数
2、滞胀
3、oj1
4、轻量级通信引擎StriveEngine —— C/S通信demo(2) —— 使用二进制协议 （附源码）
5、java I/O系统 LineNumberReader类