class SqlHelper
{
/// <summary>
/// 插入数据
/// </summary>
/// <param name="sql"></param>
/// <param name="paramaters"></param>
/// <returns></returns>
public static int ExecuteNonQuery(string sql,params SqlParameter[] paramaters)
{
using (SqlConnection conn=new SqlConnection())
{
conn.ConnectionString = "server=.;database=T_Test;Trusted_Connection=SSPI";
conn.Open();
using (SqlCommand cmd=conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramaters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// 查询数据,并返回结果的第一行第一列
/// </summary>
/// <param name="sql"></param>
/// <param name="paramaters"></param>
/// <returns></returns>
public static object ExecuteScalar(string sql, params SqlParameter[] paramaters)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server=.;database=T_Test;Trusted_Connection=SSPI";
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramaters)
{
cmd.Parameters.Add(parameter);
}
//返回查询结果的第一行第一列。
return cmd.ExecuteScalar();
}
}
}
/// <summary>
/// 查询数据,返回查询结果的一个数据集
/// </summary>
/// <param name="sql"></param>
/// <param name="paramaters"></param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string sql, params SqlParameter[] paramaters)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server=.;database=T_Test;Trusted_Connection=SSPI";
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramaters)
{
cmd.Parameters.Add(parameter);
}
//新建一个DataSet类对象
DataSet dataset = new DataSet();
//新建一个SqlDataAdapter类对象,创建数据适配器对象
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//将得到的结果填充到dataset中。具体是如何操作的由SqlDataAdapter类完成,无需多关心.
adapter.Fill(dataset);
//dataset可以有多个表,这里我们只用到了一个表,所以返回一个表。
return dataset.Tables[0];
}
}
}
}
{
/// <summary>
/// 插入数据
/// </summary>
/// <param name="sql"></param>
/// <param name="paramaters"></param>
/// <returns></returns>
public static int ExecuteNonQuery(string sql,params SqlParameter[] paramaters)
{
using (SqlConnection conn=new SqlConnection())
{
conn.ConnectionString = "server=.;database=T_Test;Trusted_Connection=SSPI";
conn.Open();
using (SqlCommand cmd=conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramaters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// 查询数据,并返回结果的第一行第一列
/// </summary>
/// <param name="sql"></param>
/// <param name="paramaters"></param>
/// <returns></returns>
public static object ExecuteScalar(string sql, params SqlParameter[] paramaters)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server=.;database=T_Test;Trusted_Connection=SSPI";
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramaters)
{
cmd.Parameters.Add(parameter);
}
//返回查询结果的第一行第一列。
return cmd.ExecuteScalar();
}
}
}
/// <summary>
/// 查询数据,返回查询结果的一个数据集
/// </summary>
/// <param name="sql"></param>
/// <param name="paramaters"></param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string sql, params SqlParameter[] paramaters)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server=.;database=T_Test;Trusted_Connection=SSPI";
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in paramaters)
{
cmd.Parameters.Add(parameter);
}
//新建一个DataSet类对象
DataSet dataset = new DataSet();
//新建一个SqlDataAdapter类对象,创建数据适配器对象
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//将得到的结果填充到dataset中。具体是如何操作的由SqlDataAdapter类完成,无需多关心.
adapter.Fill(dataset);
//dataset可以有多个表,这里我们只用到了一个表,所以返回一个表。
return dataset.Tables[0];
}
}
}
}