Code
1using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Data;
5using System.Data.SqlClient;
6
7namespace SMS.BaseClass
8{
9 class DataCon
10 {
11 建立数据库连接#region 建立数据库连接
12 /**//// <summary>
13 /// 建立数据库连接.
14 /// </summary>
15 /// <returns>返回SqlConnection对象</returns>
16 public SqlConnection getcon()
17 {
18 string M_str_sqlcon = "Data Source=(local);Database=db_SMS;User id=sa;PWD='sa'";
19 SqlConnection myCon = new SqlConnection(M_str_sqlcon);
20 return myCon;
21 }
22 #endregion
23
24 执行SqlCommand命令#region 执行SqlCommand命令
25 /**//// <summary>
26 /// 执行SqlCommand
27 /// </summary>
28 /// <param name="M_str_sqlstr">SQL语句</param>
29 public void getcom(string M_str_sqlstr)
30 {
31 SqlConnection sqlcon = this.getcon();
32 sqlcon.Open();
33 SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
34 sqlcom.ExecuteNonQuery();
35 sqlcom.Dispose();
36 sqlcon.Close();
37 sqlcon.Dispose();
38 }
39 #endregion
40
41 创建DataSet对象#region 创建DataSet对象
42 /**//// <summary>
43 /// 创建一个DataSet对象
44 /// </summary>
45 /// <param name="M_str_sqlstr">SQL语句</param>
46 /// <param name="M_str_table">表名</param>
47 /// <returns>返回DataSet对象</returns>
48 public DataSet getds(string M_str_sqlstr, string M_str_table)
49 {
50 SqlConnection sqlcon = this.getcon();
51 SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
52 DataSet myds = new DataSet();
53 sqlda.Fill(myds, M_str_table);
54 return myds;
55 }
56 #endregion
57
58 创建SqlDataReader对象#region 创建SqlDataReader对象
59 /**//// <summary>
60 /// 创建一个SqlDataReader对象
61 /// </summary>
62 /// <param name="M_str_sqlstr">SQL语句</param>
63 /// <returns>返回SqlDataReader对象</returns>
64 public SqlDataReader getread(string M_str_sqlstr)
65 {
66 SqlConnection sqlcon = this.getcon();
67 SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
68 sqlcon.Open();
69 SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
70 return sqlread;
71 }
72 #endregion
73 }
74}
75
1using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Data;
5using System.Data.SqlClient;
6
7namespace SMS.BaseClass
8{
9 class DataCon
10 {
11 建立数据库连接#region 建立数据库连接
12 /**//// <summary>
13 /// 建立数据库连接.
14 /// </summary>
15 /// <returns>返回SqlConnection对象</returns>
16 public SqlConnection getcon()
17 {
18 string M_str_sqlcon = "Data Source=(local);Database=db_SMS;User id=sa;PWD='sa'";
19 SqlConnection myCon = new SqlConnection(M_str_sqlcon);
20 return myCon;
21 }
22 #endregion
23
24 执行SqlCommand命令#region 执行SqlCommand命令
25 /**//// <summary>
26 /// 执行SqlCommand
27 /// </summary>
28 /// <param name="M_str_sqlstr">SQL语句</param>
29 public void getcom(string M_str_sqlstr)
30 {
31 SqlConnection sqlcon = this.getcon();
32 sqlcon.Open();
33 SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
34 sqlcom.ExecuteNonQuery();
35 sqlcom.Dispose();
36 sqlcon.Close();
37 sqlcon.Dispose();
38 }
39 #endregion
40
41 创建DataSet对象#region 创建DataSet对象
42 /**//// <summary>
43 /// 创建一个DataSet对象
44 /// </summary>
45 /// <param name="M_str_sqlstr">SQL语句</param>
46 /// <param name="M_str_table">表名</param>
47 /// <returns>返回DataSet对象</returns>
48 public DataSet getds(string M_str_sqlstr, string M_str_table)
49 {
50 SqlConnection sqlcon = this.getcon();
51 SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
52 DataSet myds = new DataSet();
53 sqlda.Fill(myds, M_str_table);
54 return myds;
55 }
56 #endregion
57
58 创建SqlDataReader对象#region 创建SqlDataReader对象
59 /**//// <summary>
60 /// 创建一个SqlDataReader对象
61 /// </summary>
62 /// <param name="M_str_sqlstr">SQL语句</param>
63 /// <returns>返回SqlDataReader对象</returns>
64 public SqlDataReader getread(string M_str_sqlstr)
65 {
66 SqlConnection sqlcon = this.getcon();
67 SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
68 sqlcon.Open();
69 SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
70 return sqlread;
71 }
72 #endregion
73 }
74}
75