数据库连接类:
private static string connstr = ConfigurationManager.ConnectionStrings["DB"].ConnectionString;
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable select(string sql)
{
SqlDataAdapter sda= new SqlDataAdapter(sql, connstr);
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
public static int zsg(string sql)
{
using(SqlConnection conn=