掌握TreeView用法(8)

28         public static int ExecuteNonQuery(string sql, params SqlParameter[] Paramers)
29         {
30             using (SqlConnection con = new SqlConnection(conStr))//创建一个连接
31             {
32                 con.Open();//打开连接通道
33                 using (SqlCommand cmd = con.CreateCommand())//创建一个命令对象
34                 {
35                     cmd.CommandText = sql;
36                     cmd.Parameters.AddRange(Paramers);
37                     return cmd.ExecuteNonQuery();
38                 }
39             }
40         }
41     }
42 }

 

作者  谢舸哥