usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Configuration;usingSystem.Data;usingSystem.Data.SqlClient;namespace数据绑定{classSqlHelper{privatestaticstringstrconn=ConfigurationManager.ConnectionStrings["dbstrConn"].ConnectionString;publicstaticintExecuteNonQuery(stringsql){using(SqlConnectionconn=newSqlConnection(strconn)){conn.Open();using(SqlCommandcmd=conn.CreateCommand()){cmd.CommandText=sql;returncmd.ExecuteNonQuery();}}}publicstaticobjectExecuteScalar(stringsql){using(SqlConnectionconn=newSqlConnection(strconn)){conn.Open();using(SqlCommandcmd=conn.CreateCommand()){cmd.CommandText=sql;returncmd.ExecuteScalar();}}}//查询少量数据publicstaticDataTableExecuteTable(stringsql){using(SqlConnectionconn=newSqlConnection(strconn)){conn.Open();using(SqlCommandcmd=conn.CreateCommand()){cmd.CommandText=sql;SqlDataAdapteradapter=newSqlDataAdapter(cmd);DataSetdataset=newDataSet();adapter.Fill(dataset);returndataset.Tables[0];}}}}}