第一:首先在DAL层创建个类,类名为:SQLHelper
第二:再引用一下空间名
using System.Data;using ;
System.Data.SqlClient;
using Model;
using System.Configuration;
public class SQLHelper
{
//创建连接字段
private static string conStr = ConfigurationManager.ConnectionStrings["DigitalProductShopConnectionString"].ConnectionString;
/// <summary>
/// 查询数据库
/// </summary>
/// <param name="sql">查询语句</param>
/// <returns>返回查询到的表</returns>
public static DataTable Query(string sql)
{
//创建空表接收查询到的数据
using (DataTable dt = new DataTable())
{
//创建查询数据库对象
using (SqlDataAdapter sda = new SqlDataAdapter(sql, conStr))
{
//将查询到的数据填充给空表
sda.Fill(dt);
}
return dt;
}
}
/// <summary>
/// 增删改数据库
/// </summary>
/// <param name="sql">增删改语句</param>
/// <returns>返回受影响的行数</returns>
public static int NonQuery(string sql)
{
int num = 0;
//创建数据库连接对象
using (SqlConnection conn = new SqlConnection(conStr))
{
try
{
conn.Open();
//创建数据库执行语句对象
using (SqlCommand comm = new SqlCommand(sql, conn))
{
//执行数据库语句,存储受影响行数
num = comm.ExecuteNonQuery();
}
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
return num;
}
}