private void comboboxDoldur() { cmbKomite.Items.Clear(); cmbGorev.Items.Clear(); Veritabani vt = new Veritabani(); DataTable dt = vt.DtVeriCek("SELECT DISTINCT komite from uye"); foreach (DataRow satir in dt.Rows) { cmbKomite.Items.Add(satir[0].ToString()); } dt = vt.DtVeriCek("SELECT DISTINCT gorevler from uye"); List <string> gorevler = new List <string>(); foreach (DataRow satir in dt.Rows) { foreach (string eleman in satir[0].ToString().Split(',')) { if (gorevler.IndexOf(eleman) == -1) { gorevler.Add(eleman); } } } cmbGorev.Items.AddRange(gorevler.ToArray()); }
private void Doldur() { Veritabani vt = new Veritabani(); DataTable dt = vt.DtVeriCek("SELECT * from uye where id=" + uyeId); if (dt.Rows.Count == 0) { return; } var satir = dt.Rows[0]; txtAd.Text = satir["ad"].ToString(); txtSoyad.Text = satir["soyad"].ToString(); txtTelefon.Text = satir["telefon"].ToString(); txtMail.Text = satir["mail"].ToString(); rchAdres.Text = satir["adres"].ToString(); txtFakulte.Text = satir["fakulte"].ToString(); txtBolum.Text = satir["bolum"].ToString(); txtSinif.Text = satir["sinif"].ToString(); cmbKomite.Text = satir["komite"].ToString(); lstGorevler.Items.AddRange(satir["gorevler"].ToString().Split(',')); rchEkstra.Text = satir["ozelAlan"].ToString(); PuanDoldur(); }