private static void ExecuteNonQueryCommands(string sConnectionString, string sSQLQuery, List<SqlParameter> SqlParms)
{
DataTable dt = new DataTable();
using (SqlConnection cn = new SqlConnection(sConnectionString)) {
cn.Open();
using (SqlCommand cmd = new SqlCommand(sSQLQuery, cn)) {
cmd.CommandType = CommandType.Text;
foreach (var p in SqlParms) {
cmd.Parameters.Add(p);
}
int ret = cmd.ExecuteNonQuery();
}
cn.Close();
}
}