标准的SQL DataHelper类.doc

//一个个人写的DataHelper类 //支持断开连接和持续连接 的数据访问形式 //持续连接（DataReader）更加方便与将数据库中的数据存储到泛型集合中，但是并且非常适合小数据的访问 //断开连接（DataTable、DataAdapter、DataSet）要消耗更多的服务器性能，但是适合对大的数据访问 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Configuration; using System.Data; using System.Data.SqlClient; namespace DAL { public class SQLDataHelper { //连接字符串 private readonly static string connectionString = ConfigurationManager.ConnectionStrings[连接字符串名].ConnectionString; /// summary /// 执行命令之前胡准保 /// /summary /// param name=conn连接对虾/param /// param name=cmd命令对虾/param /// param name=parms参数集合/param /// param name=type命令对象类型/param /// param name=trans事务/param private void PreperaCommand(SqlConnection conn, SqlCommand cmd, SqlParameter[] parms, CommandType type, SqlTransaction trans) { cmd.Connection = conn; if (parms != null) cmd.Parameters.AddRange(parms); cmd.CommandType = type; if (trans != null) cmd.Transaction = trans; } /// summary /// 获取DataReader对象 /// /summary /// param name=cmdText命令语句/param /// returns/returns public SqlDataReader ExecReader(string cmdText) { return ExecReader(cmdText, null); } /// summary /// 获取DataReader对象 /// /summary /// param name=cmdText命令语句/param /// param name=parms参数集合/param /// returns/returns public SqlDataReader ExecReader(string cmdText, SqlParameter[] parms) { return ExecReader(cmdText, parms, CommandType.Text); } /// summary /// 获取DataReader对象 /// /summary /// param name=cmdText命令语句/param /// param name=parms参数集合/param /// param name=type命令类型/param /// returns/returns public SqlDataReader ExecReader(string