三层架构DAL层中的sqlHelper页面代码:
首先要创建一个连接字符串
如下:
public class sqlHelper
{
private static string sqlCon = ConfigurationManager.ConnectionStrings["填写你要连接的名称"].ConnectionString;
public static DataTable Que(string sql) {
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sql,sqlCon);
da.Fill(dt);
return dt;
}
public static int NonQue(string sql) {
int numm = 0;
SqlConnection con = new SqlConnection(sqlCon);
SqlCommand comm = new SqlCommand(sql,con);
try
{
con.Open();
numm = comm.ExecuteNonQuery();
}
finally
{
if (con.State==ConnectionState.Open)
{
con.Close();
}
}
return numm;
}
}
开始收尾时候别忘了在.ENT中引用Configuration