1 using System.Data;
2 using System.Data.SqlClient;
3
4 namespace SQLServer
5 {
6 public class SQLServerDataBase
7 {
8 string _connString = "server=127.0.0.1;database=User;uid=sa;pwd=123";
9
10 public SQLServerDataBase(string connStr)
11 {
12 _connString = connStr;
13 }
14
15 public bool OpenDataBase()
16 {
17 try
18 {
19 //创建数据库连接对象
20 using (SqlConnection sqlConn = new SqlConnection(_connString))
21 {
22 //打开连接
23 sqlConn.Open();
24 sqlConn.Close();
25 return true;
26 }
27 }
28 catch
29 {
30 return false;
31 }
32 }
33
34 ///<summary>
35 ///定义函数根据传入的参数，执行SQL语句获取影响的行数
36 ///</summary>
37 public bool ExecuteNonQuery(string sql, out int iResult)
38 {
39 iResult = 0;
40 //创建连接数据库对象
41 using (SqlConnection sqlConn = new SqlConnection(_connString))
42 {
43 //打开连接
44 sqlConn.Open();
45 //创建执行SQL语句对象
46 using (SqlCommand sqlCmd = new SqlCommand(sql, sqlConn))
47 {
48 iResult = sqlCmd.ExecuteNonQuery();
49 sqlConn.Close();
50 sqlCmd.Dispose();
51 return true;
52 }
53 }
54 }
55
56 ///<summary>
57 ///定义函数根据传入的参数，执行SQL语句获取数据集DataSet对象
58 ///</summary>
59 public bool ExecuteNonDataSet(string sql, out DataSet dataSet)
60 {
61 dataSet = null;
62 //创建连接数据库对象
63 using (SqlConnection sqlConn = new SqlConnection(_connString))
64 {
65 //创建执行SQL语句对象
66 using (SqlDataAdapter sqlData = new SqlDataAdapter(sql, sqlConn))
67 {
68 //打开连接
69 sqlConn.Open();
70 dataSet = new DataSet();
71 sqlData.Fill(dataSet, "ds");
72 sqlConn.Close();
73 sqlData.Dispose();
74 return true;
75 }
76 }
77
78 }
79
80 }
81 }
