public SqlDataAdapter getData1(string query) { SqlCommand com = new SqlCommand(query, con); dt = new DataTable(); dt.Load(com.ExecuteReader()); da.Fill(dt); return da; }