如何DBHelper数据库帮助类为？
摘要：12数据库帮助类 3vito 45 public class DBHelper 6 { 7 8 910数据库连接字符串 1112 private...
1 /// <summary>
2 /// 数据库帮助类
3 /// <author>vito</author>
4 /// </summary>
5 public class DBHelper
6 {
7
8
9 /// <summary>
10 /// 数据库连接字符串
11 /// </summary>
12 private string connStr = System.Configuration.ConfigurationManager.AppSettings["connStr"].ToString();
13
14
15 /// <summary>
16 /// 一个有效的数据库连接对象
17 /// </summary>
18 private SqlConnection _MyConnection;
19 public SqlConnection MyConnection
20 {
21 get
22 {
23 if(_MyConnection == null)
24 {
25 _MyConnection = new SqlConnection(connStr);
26 }
27 return _MyConnection;
28 }
29 }
30
31
32 /// <summary>
33 /// 返回受影响行数
34 /// </summary>
35 /// <param name="cmdText">SQL语句</param>
36 /// <param name="commandParameters">参数集</param>
37 /// <returns></returns>
38 public int MyExecuteNonQuery(string cmdText, params SqlParameter[] commandParameters)
39 {
40 int result = 0;
41 SqlCommand cmd = new SqlCommand();
42 SqlConnection conn = MyConnection;
43 try
44 {
45 PrepareCommand(cmd, conn, null, cmdText, commandParameters);
46 result = cmd.ExecuteNonQuery();
47 }
48 catch(SqlException ex)
49 {
50 throw new Exception(ex.Message);
51 }
52 finally
53 {
54 cmd.Parameters.Clear();
55 }
56 return result;
57 }
58
59
60
61 /// <summary>
62 /// 返回DataSet
63 /// </summary>
64 /// <param name="