如果您无法下载资料，请参考说明：
1、部分资料下载需要金币，请确保您的账户上有足够的金币
2、已购买过的文档，再次下载不重复扣费
3、资料包下载后请先用软件解压，在使用对应软件打开
usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Configuration;usingSystem.Data.SqlClient;usingSystem.Data;namespaceADO基础{classSqlHelper{privatestaticstringconnStr=ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;publicstaticintExecuteNonQuery(stringsql,paramsSqlParameter[]parameters){using(SqlConnectionconn=newSqlConnection(connStr)){using(SqlCommandcmd=conn.CreateCommand()){cmd.CommandText=sql;cmd.Parameters.AddRange(parameters);conn.Open();returncmd.ExecuteNonQuery();}}}publicstaticObjectExecuteScalar(stringsql){using(SqlConnectionconn=newSqlConnection(connStr)){using(SqlCommandcmd=conn.CreateCommand()){cmd.CommandText=sql;conn.Open();returncmd.ExecuteScalar();}}}publicstaticSqlDataReaderExecuteReader(stringsql){using(SqlConnectionconn=newSqlConnection(connStr)){using(SqlCommandcmd=conn.CreateCommand()){cmd.CommandText=sql;conn.Open();//只读向前，回不去的，无法外传，这是一个失败的函数returncmd.ExecuteReader();}}}publicstaticDataTableExecuteDataTable(stringsql){using(SqlConnectionconn=newSqlConnection(connStr)){using(SqlCommandcmd=conn.CreateCommand()){cmd.CommandText=sql;//出了这个函数就不管事了SqlDataAdapteradapter=newSqlDataAdapter(cmd);DataSetdataSet=newDataSet();adapter.Fill(dataSet);returndataSet.Tables[0];}}}}}
立即下载
