第八天

三层架构中SQLHelper书写

下面展示一些 内联代码片。

需要加入三个命名空间： using System.Data; using System.Data.SqlClient; using System.Configuration;

namespace DAL { public class SQLHelper { private static string strconn = ConfigurationManager.ConnectionStrings["HotelDBConnectionString"].ConnectionString; public static DataTable ChaXun(string sql) { using (DataTable dt = new DataTable()) { using (SqlDataAdapter sda = new SqlDataAdapter(sql, strconn)) { sda.Fill(dt); } return dt; } } public static int FeiChaXun(string sql) { int i = 0; SqlConnection conn = new SqlConnection(strconn); SqlCommand comm = new SqlCommand(sql, conn); try { conn.Open(); i = comm.ExecuteNonQuery(); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return i; } } }