private void SirketListe() { ArsSQLQry qrySirketList = new ArsSQLQry(); qrySirketList.artezQry = true; qrySirketList.SQLText = "SELECT SIRKET_ADI, DBYIL FROM [TBLSIRKET] ORDER BY DBYIL DESC"; qrySirketList.Open(); if (qrySirketList.Found()) { SIRKET.ClearItems(); string selectedSirket = ArsLibrary.GetLineCFG(System.Environment.MachineName + " Şirket"); int selectedIndex = 0; for (int i = 0; i < qrySirketList.DataCount(); i++) { if (qrySirketList.GetString("SIRKET_ADI") == selectedSirket) { selectedIndex = i; } SIRKET.AddItem(qrySirketList.GetString("SIRKET_ADI"), qrySirketList.GetString("DBYIL")); qrySirketList.Next(); } SIRKET.SelectedIndex = selectedIndex; } }
private void SirketDegistir_Load(object sender, EventArgs e) { if (cariAktar) { btnKaydet.Text = "Aktar"; } ArsSQLQry qrySirketList = new ArsSQLQry(); qrySirketList.artezQry = true; qrySirketList.SQLText = "SELECT SIRKET_ADI, DBYIL FROM [TBLSIRKET] ORDER BY DBYIL DESC"; qrySirketList.Open(); if (qrySirketList.Found()) { SIRKET.ClearItems(); string selectedSirket = ArsLibrary.GetLineCFG(System.Environment.MachineName + " Şirket"); int selectedIndex = 0; for (int i = 0; i < qrySirketList.DataCount(); i++) { if (qrySirketList.GetString("SIRKET_ADI") == selectedSirket) { selectedIndex = i; } SIRKET.AddItem(qrySirketList.GetString("SIRKET_ADI"), qrySirketList.GetString("DBYIL")); qrySirketList.Next(); } SIRKET.SelectedIndex = selectedIndex; } SIRKET.SetString(ArsLibrary.dbName); }