三层架构中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;
}
}
}