C# ADO SqlHelper
来源:互联网 发布:国家地理基础数据库 编辑:程序博客网 时间:2024/06/02 04:15
class SqlHelper
{
public static readonly string connstr =
ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
public static int ExecuteNonQuery(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteNonQuery();
}
}
}
public static object ExecuteScalar(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteScalar();
}
}
}
public static DataTable ExecuteDataTable(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
}
}
}
public static SqlDataReader ExecuteDataReader(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
}
{
public static readonly string connstr =
ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
public static int ExecuteNonQuery(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteNonQuery();
}
}
}
public static object ExecuteScalar(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteScalar();
}
}
}
public static DataTable ExecuteDataTable(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
}
}
}
public static SqlDataReader ExecuteDataReader(string cmdText,CommandType type,
params SqlParameter[] parameters)
{
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = type;
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
}
- C# ADO基础 SqlHelper
- C# ADO SqlHelper
- C#进阶ADO.NET基础二 DataSet、配置文件、SqlHelper
- sqlhelper,c#
- c# sqlhelper
- C#,ADO封装,SqlHelper.cs
- ADO.NET操作封装(SqlHelper)
- C# SQLHelper 源代码
- c# SqlHelper 封装SqlDataReader
- c#封装 SqlHelper
- C# 一个SqlHelper例子
- C# SQLHelper.cs
- c#封装 SqlHelper
- C# 中 SqlHelper
- C#编写SQLHelper
- C# SqlHelper (一)
- 微软C# SQLHelper类
- C# 数据库连接必备(SqlHelper)
- Spring漏洞案例-Petclinic
- TextView中多行字的行间距
- CSS 选择器
- SQL Server SQL高级查询语句小结
- html/css教程:背景图片的定位问题详解
- C# ADO SqlHelper
- java使用递归解决全排列问题
- Python学习之字典
- C++的函数重载
- C语言内存管理基础知识总结
- dp 专题
- coreseek拼音检索第三版性能测试
- linux下菜鸟学习mysql总结
- Android软件开发之ListView 详解