ASP.NET--DBHelper

//连接字段
private static string strConn =

ConfigurationManager.ConnectionStrings

[""]. ConnectionString:

//查询
public static DataTable Query(string sql)
{
SqlDataAdapter adt=new Sq1DataAdapter(sql, strConn) ;
DataTable dt = new DataTable() ;
adapter. Fill(dt) ;
return dt;
}
//非查询
public static int NonQuery(string sq1)
{
int num = 0;
using (Sq1Connection sq1Connection = new Sq1Connect ion (strConn))
{
using (Sq1Command sq1Command = new Sq1Command (sq1,sqlConnection))
{
sqlConnection. Open() ;
num = sq1Command. ExecuteNonQuery() ;
     }
   }
return num;
 }