数据库连接字符串
- 格式:docx
- 大小:12.99 KB
- 文档页数:5
/数据库连接字符串(web.config来配置),可以动态更改connectionString支持多数据库.
public static string connectionString = System.Configuration.ConfigurationManager.C onnectionStrings["ConnectionString"].ConnectionString;
///
///执行存储过程,返回SqlDataReader ( 注意:调用该方法后,一定要对SqlDataReader进行Close )
///
///存储过程名
///存储过程参数
///
public static SqlDataReader RunProcedure(string storedProcName, IDataParamet er[] parameters)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlDataReader returnReader;
connection.Open();
SqlCommand command = BuildQueryCommand(connection, storedProcName, parameters);
mandType = CommandType.StoredProcedure;
returnReader = command.ExecuteReader(CommandBehavior.CloseConnection );
return returnReader;
}
///
///执行存储过程
///
///存储过程名
///存储过程参数
///DataSet结果中的表名
///
public static DataSet RunProcedure(string storedProcName, IDataParameter[] pa rameters, string tableName)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcNam e, parameters);
sqlDA.Fill(dataSet, tableName);
connection.Close();
return dataSet;
}
}
public static DataSet RunProcedure(string storedProcName, IDataParameter[] pa rameters, string tableName, int Times)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcNam e, parameters);
mandTimeout = Times;
sqlDA.Fill(dataSet, tableName);
connection.Close();
return dataSet;
}
}
///
///构建 SqlCommand 对象(用来返回一个结果集,而不是一个整数值)
///
///数据库连接
///存储过程名
///存储过程参数
///
private static SqlCommand BuildQueryCommand(SqlConnection connection, stri