public class SqlTool ... { static string CONN_STR = "server=.;uid=sa;pwd=;database=northwind"; public static int ExeSqlRtInt(string sql, params SqlParameter[] parms) ...{ using (SqlConnection cn = new SqlConnection(CONN_STR)) ...{ cn.Open(); SqlCommand cmd = new SqlCommand(sql, cn); foreach (SqlParameter p in parms) cmd.Parameters.Add(p); return cmd.ExecuteNonQuery(); } } public static void ExeSqlFillTable(string sql, DataTable dt, params SqlParameter[] parms) ...{ using (SqlConnection cn = new SqlConnection(CONN_STR)) ...{ SqlDataAdapter ada = new SqlDataAdapter(sql, cn); foreach (SqlParameter p in parms) ada.SelectCommand.Parameters.Add(p); ada.Fill(dt); } } }