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();
}