DBHelper类
public class DBHelper
{
public static string connstr = ConfigurationManager.ConnectionStrings["Test"].ConnectionString;
public static DataTable ExcuteTable(string sql)
{
SqlDataAdapter sda = new SqlDataAdapter(sql, connstr);
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
public static int ExcuteNonQuery(string sql)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
return comm.ExecuteNonQuery();
};
}
}