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;
}