public SqlDataReader getData(string query) { SqlCommand com = new SqlCommand(query, con); dr = com.ExecuteReader(); return dr; }
public void kullaniciGetir() { db.dbConnect(); SqlDataReader reader = db.getData("select adi,soyadi,seviye,p.id from kullanicilar as k inner join profil as p on k.profilID=p.id and p.kategoriID=2"); while (reader.Read()) { comboBox2.Items.Add(reader["adi"].ToString()); id = (Convert.ToInt32(reader["id"])); } db.dbClose(); }