C操作sql server数据库分析和总结.docxVIP

说明:以下是我近两年来开发中最常用的C#操作sqlserve数r据库访问类,对初学者非常有用,多研究研究,有什么问题联系我QQ:115216552,在web.config中配置一下连接字符串就可用了.

说明:以下是我近两年来开发中最常用的C#操作sqlserve数r据库访问类,对初学者非常有用,

多研究研究,有什么问题联系我QQ:115216552,在web.config中配置一下连接字符串就可用了.

usingSystem;

usingSystem.Collections.Generic;usingSystem.Text;

usingSystem.Data;

usingSystem.Data.SqlClient;

publicclassSqlClass

{

protectedSqlConnectionConnection;protectedstringconnectionstring;

publicSqlClass()

{

connectionstring =

System.Configuration.ConfigurationSettings.AppSettings[connString];Connection=newSqlConnection(connectionstring);

}

publicSqlClass(stringconnstring)

{

connectionstring=connstring;

Connection=newSqlConnection(connectionstring);

}

/*执行返回结果和不返回结果的存储过程方法*/

///summary

///根据存储过程名称和参数生成对应的SQL命令对象

////summary

///paramname=storedProcName存储过程名/param

///paramname=parameter存s储

///returns/returns

过程参数/param

privateSqlCommand BuilderQueryCommand(stringstoredProcName,parameters)

{

SqlParameter[]

SqlCommandcommand=newSqlCommand();

command.Connection=Connection;command.CommandText=storedProcName.Trim();command.CommandType=CommandType.StoredProcedure;if(parameters!=null)

{

foreach(SqlParameterpinparameters)

{

command.Parameters.Add(p);

}

}

returncommand;

}

///summary

///返回结果的存储过程

////summary

///paramname=storedProcName存储过程名/param

///paramname=parameter参s数

///returns/returns

值/param

publicSqlDataReaderGetDataReader(stringstoredProcName,SqlParameter[]parameters)

{

SqlDataReaderreader;

SqlCommandcmd=BuilderQueryCommand(storedProcName,parameters);if(Connection.State==ConnectionState.Closed)

{

Connection.Open();

}

reader=cmd.ExecuteReader(CommandBehavior.CloseConnection);returnreader;

}

///summary

///不返回结果的存储过程

////summary

///paramname=storedProcName存储过程名/param

///paramname=parameter参s数

///returns/returns

值/param

publicintGetEffect(stringstoredProcName,SqlParameter[]parameters)

{

intresult=0;try

{

if(Connection.State==ConnectionState.Closed)