带参数的SqlHelper
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
1 namespace WpfApplication3 2 { 3 class 简化SqlHelper 4 { 5 private static string ConnStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; 6 7 public static int ExecuteNonQuery(string sql, params SqlParameter[] parameter) 8 { 9 using(SqlConnection conn=new SqlConnection (ConnStr)) 10 { 11 conn.Open(); 12 using(SqlCommand cmd=conn.CreateCommand()) 13 { 14 cmd.CommandText = sql; 15 cmd.Parameters.AddRange(parameter); 16 return cmd.ExecuteNonQuery(); 17 } 18 } 19 } 20 public static object ExecuteScalar(string sql, params SqlParameter[] parameter) 21 { 22 using(SqlConnection conn=new SqlConnection (ConnStr)) 23 { 24 conn.Open(); 25 using(SqlCommand cmd=conn.CreateCommand()) 26 { 27 cmd.CommandText = sql; 28 cmd.Parameters.AddRange(parameter); 29 return cmd.ExecuteScalar(); 30 } 31 } 32 } 33 public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameter) 34 { 35 using(SqlConnection conn=new SqlConnection (ConnStr)) 36 { 37 conn.Open(); 38 using(SqlCommand cmd=conn.CreateCommand()) 39 { 40 cmd.CommandText = sql; 41 cmd.Parameters.AddRange(parameter); 42 SqlDataAdapter adapter = new SqlDataAdapter(cmd); 43 DataSet dataset = new DataSet(); 44 adapter.Fill(dataset); 45 return dataset.Tables[0]; 46 } 47 } 48 } 49 } 50 }
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
1 private void button1_Click(object sender, RoutedEventArgs e) 2 { 3 int a=(int) 简化SqlHelper.ExecuteScalar("select count(*) from Table_1 where othersnum=@num ",new SqlParameter("@num",5)); 4 MessageBox.Show(a.ToString()); 5 }