Carrotware.CMS.DBUpdater.DatabaseUpdate.ExecuteNonQueryCommands C# (CSharp) Метод

ExecuteNonQueryCommands() приватный статический Метод

private static ExecuteNonQueryCommands ( string sConnectionString, string sSQLQuery, List SqlParms ) : void
sConnectionString string
sSQLQuery string
SqlParms List
Результат void
        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();
            }
        }