封装SQLHelper

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77

// //  author: agile //  datetime:5/29/2011 8:59:13 AM //  class:  SQLHelper // using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Configuration; using System.Data;    namespace SqlHelper {     class SQLHelper     {         public static int ExecuteNonQuery(string sql,params SqlParameter[] parameters)         {             string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;             using (SqlConnection strconn = new SqlConnection(conn))             {                 strconn.Open();                 using (SqlCommand cmd = strconn.CreateCommand())                 {                     cmd.CommandText = sql;                     foreach (SqlParameter parameter in parameters)                     {                         cmd.Parameters.Add(parameter);                     }                     return cmd.ExecuteNonQuery();                 }             }            }         public static object ExecuteScalar(string sql, params SqlParameter[] parameters)         {             string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;             using (SqlConnection strconn = new SqlConnection(conn))             {                 strconn.Open();                 using (SqlCommand cmd = strconn.CreateCommand())                 {                     cmd.CommandText = sql;                     foreach (SqlParameter parameter in parameters)                     {                         cmd.Parameters.Add(parameter);                     }                     return cmd.ExecuteScalar();                 }             }            }         public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)         {             string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;             using (SqlConnection strconn = new SqlConnection(conn))             {                 strconn.Open();                 using (SqlCommand cmd = strconn.CreateCommand())                 {                     cmd.CommandText = sql;                      foreach (SqlParameter parameter in parameters)                     {                         cmd.Parameters.Add(parameter);                     }                     DataSet dataset = new DataSet();                     SqlDataAdapter adapter = new SqlDataAdapter(cmd);                     adapter.Fill(dataset);                     return dataset.Tables[0];                     }                         }                       }     } }