private static DataTable GetDataTable(string sConnectionString, string sSQLQuery) { DataTable dt = new DataTable(); using (SqlConnection cn = new SqlConnection(sConnectionString)) { using (SqlCommand cmd = new SqlCommand(sSQLQuery, cn)) { cn.Open(); cmd.CommandType = CommandType.Text; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } cn.Close(); } } return dt; }