c#SQLHelper(forwinForm)实现代码数据连接池c#SQLHelper实现代码SQLHelper.cs复制代码代码如下:usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Collections;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Configuration;namespaceHelloWinForm.DBUtility{classSQLHelper{#region通用方法数据连接池privateSqlConnectioncon;///
返回数据库连接字符串//////
publicstaticStringGetSqlConnection(){Stringconn=ConfigurationManager.AppSettings["connectionString"].ToString();returnconn;}#endregion#region执行sql字符串///
执行不带参数的SQL语句//////
///publicstaticintExecuteSql(StringSqlstr){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText=Sqlstr;conn.Open();cmd.ExecuteNonQuery();conn.Close();return1;}}///执行带参数的SQL语句//////SQL语句///参数对象数组///publicstaticintExecuteSql(StringSqlstr,SqlParameter[]param){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText=Sqlstr;cmd.Parameters.AddRange(param);conn.Open();cmd.ExecuteNonQuery();conn.Close();return1;}}///返回DataReader/////////publicstaticSqlDataReaderExecuteReader(StringSqlstr){StringConnStr=GetSqlConnection();SqlConnectionconn=newSqlConnection(ConnStr);//返回DataReader时,是不可以用using()的try{SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText=Sqlstr;conn.Open();returncmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);//关闭关联的Connection}catch//(Exceptionex){returnnull;}}///执行SQL语句并返回数据
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
//////SQL语句///publicstaticDataTableExecuteDt(StringSqlstr){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlDataAdapterda=newSqlDataAdapter(Sqlstr,conn);DataTabledt=newDataTable();conn.Open();da.Fill(dt);conn.Close();returndt;}}///执行SQL语句并返回DataSet//////SQL语句///publicstaticDataSetExecuteDs(StringSqlstr){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlDataAdapterda=newSqlDataAdapter(Sqlstr,conn);DataSetds=newDataSet();conn.Open();da.Fill(ds);conn.Close();returnds;}}#endregion#region操作存储过程///运行存储过程(已重载)//////存储过程的名字///存储过程的返回值publicintRunProc(stringprocName){SqlCommandcmd=CreateCommand(procName,null);cmd.ExecuteNonQuery();this.Close();return(int)cmd.Parameters["ReturnValue"].Value;}///运行存储过程(已重载)//////存储过程的名字///存储过程的输入参数列表///存储过程的返回值publicintRunProc(stringprocName,SqlParameter[]prams){SqlCommandcmd=CreateCommand(procName,prams);cmd.ExecuteNonQuery();this.Close();return(int)cmd.Parameters[0].Value;}///运行存储过程(已重载)//////存储过程的名字///结果集publicvoidRunProc(stringprocName,outSqlDataReaderdataReader){SqlCommandcmd=CreateCommand(procName,null);dataReader=www.visa158.comcmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);}///运行存储过程(已重载)//////存储过程的名字///存储过程的输入参数列表///结果集publicvoidRunProc(stringprocName,SqlParameter[]prams,outSqlDataReaderdataReader){SqlCommandcmd=CreateCommand(procName,prams);dataReader=cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);}///创建Command对象用于访问存储过程//////存储过程的名字///存储过程的输入参数列表///Command对象privateSqlCommandCreateCommand(stringprocName,SqlParameter[]prams){确定连接是打开的Open();//command=newSqlCommand(sprocName,newSqlConnection(ConfigManager.DALConnectionString));SqlCommandcmd=newSqlCommand(procName,con);cmd.CommandType=CommandType.StoredProcedure;添加存储过程的输入参数列表if(prams!=null){foreach(SqlParameterparameterinprams)cmd.Parameters.Add(parameter);}//返回Command对象returncmd;www.hunanwang.net}///创建输入参数//////参数名///参数类型///参数大小///参数值///新参数对象publicSqlParameterMakeInParam(stringParamName,SqlDbTypeDbType,intSize,objectValue){returnMakeParam(ParamName,DbType,Size,ParameterDirection.Input,Value);}///创建输出参数//////参数名///参数类型///参数大小///新参数对象publicSqlParameterMakeOutParam(stringParamName,SqlDbTypeDbType,intSize){returnMakeParam(ParamName,DbType,Size,ParameterDirection.Output,null);}///创建存储过程参数//////参数名///参数类型///参数大小///参数的方向(输入/输出)///参数值///新参数对象publicSqlParameterMakeParam(stringParamName,SqlDbTypeDbType,Int32Size,ParameterDirectionDirection,objectValue){SqlParameterparam;if(Size>0){param=newSqlParameter(ParamName,DbType,Size);}else{param=newSqlParameter(ParamName,DbType);}param.Direction=Direction;if(!(Direction==ParameterDirection.Output&&Value==null)){param.Value=Value;}returnparam;}#endregion#region数据库连接和关闭///打开连接池///privatevoidOpen(){打开连接池if(con==null){//这里不仅需要usingSystem.Configuration;还要在引用目录里添加con=newSqlConnection(GetSqlConnection());con.Open();}}///关闭连接池///publicvoidClose(){if(con!=null)con.Close();}///释放连接池///publicvoidDispose(){确定连接已关闭if(con!=null){con.Dispose();con=null;}}#endregion}}简单用一下:复制代码代码如下:usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Collections;usingHelloWinForm.DBUtility;namespaceHelloWinForm.DAL{classStudent{publicstringtest(){stringstr="";SqlDataReaderdr=SQLHelper.ExecuteReader("select*fromStudent");while(dr.Read()){str+=dr["StudentNO"].ToString();}dr.Close();returnstr;}}}
浙公网安备 33021202002483