Carrotware.CMS.DBUpdater.DatabaseUpdate.ExecuteDataTableCommands C# (CSharp) Method

ExecuteDataTableCommands() private static method

private static ExecuteDataTableCommands ( string sConnectionString, string sSQLQuery, List SqlParms ) : DataTable
sConnectionString string
sSQLQuery string
SqlParms List
return System.Data.DataTable
        private static DataTable ExecuteDataTableCommands(string sConnectionString, string sSQLQuery, List<SqlParameter> SqlParms)
        {
            DataTable dt = new DataTable();

            using (SqlConnection cn = new SqlConnection(sConnectionString)) {
                using (SqlCommand cmd = new SqlCommand(sSQLQuery, cn)) {
                    cn.Open();
                    cmd.CommandType = CommandType.Text;

                    if (SqlParms != null) {
                        foreach (var p in SqlParms) {
                            cmd.Parameters.Add(p);
                        }
                    }

                    using (SqlDataAdapter da = new SqlDataAdapter(cmd)) {
                        da.Fill(dt);
                    }
                }
                cn.Close();
            }

            return dt;
        }