private DataTable getDT(String qry, String connectionString) { DataSet dataSet = new DataSet(); SqlConnection conn = new SqlConnection(connectionString); SqlDataAdapter dataAdapter = new SqlDataAdapter(qry, conn); DataSet ds= new DataSet(); dataAdapter.Fill(ds, "dt"); return ds.Tables ["dt"]; }