先引用
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public class SqlHelper
{
/// <summary>
/// 创建连接字符串
/// </summary>
private static string strConn = ConfigurationManager.ConnectionStrings["DigitalProductShopConnectionString"]
.ConnectionString;
/// <summary>
/// 查询语句
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable Query(string sql)
{
//创建一张新表
using (DataTable table = new DataTable())
{
//创建数据适配器
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, strConn))
{
adapter.Fill(table);
}
return table;
}
}
public static int NonQuery(string sql)
{
//创建一个数字
int num = 0;
using (SqlConnection sqlConn = new SqlConnection(strConn))
{
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlConn))
{
try
{
sqlConn.Open();
num = sqlCmd.ExecuteNonQuery();
}
finally
{
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
}
}
return num;
}
}