SqlHelper 

 1     class SqlHelper
 2     {
 3         private static string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
 4         public static int ExecuteNonQuery(string sql, params SqlParameter[] parameters)
 5         {
 6             using (SqlConnection conn = new SqlConnection(connStr))
 7             {
 8                 conn.Open();
 9                 using (SqlCommand cmd = conn.CreateCommand())
10                 {
11                     cmd.CommandText = sql;
12                     cmd.Parameters.AddRange(parameters);
13                     return cmd.ExecuteNonQuery();
14                 }
15             }
16  
17         }
18         public static object ExecuteScalar(string sql, params SqlParameter[] parameters)
19         {
20             using (SqlConnection conn = new SqlConnection(connStr))
21             {
22                 conn.Open();
23                 using (SqlCommand cmd = conn.CreateCommand())
24                 {
25                     cmd.CommandText = sql;
26                     cmd.Parameters.AddRange(parameters);
27                     return cmd.ExecuteScalar();
28                 }
29             }
30         }
31         //只用来执行查询结果比较少的Sql
32         public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
33         {
34             using (SqlConnection conn = new SqlConnection(connStr))
35             {
36                 conn.Open();
37                 using (SqlCommand cmd = conn.CreateCommand())
38                 {
39                     cmd.CommandText = sql;
40                     cmd.Parameters.AddRange(parameters);
41                     SqlDataAdapter adapter = new SqlDataAdapter(cmd);
42                     DataSet dataset = new DataSet();
43                     adapter.Fill(dataset);
44                     return dataset.Tables[0];
45                 }
46             }
47         }
48     }

 

posted @ 2017-11-16 20:51  pop1234ggg  阅读(170)  评论(0)    收藏  举报