Ay: Aralık 2020

SqlClass.dsGenel = SqlClass.GetDataset(“SELECT ID,ADI FROM [dbo].[CARI_GRUBU]”, “CARI_GRUBU”, “local”);for (int i = 0; i < SqlClass.dsGenel.Tables[“CARI_GRUBU”].Rows.Count; i++){this.chcgrubu.Items.Add(SqlClass.dsGenel.Tables[“CARI_GRUBU”].Rows[i][“ADI”].ToString());} string sqlCumle = “SELECT [CARIID] ,[CARITUR] FROM [CRM].[dbo].[CARI_KATEGORI] where TRCODE=1 AND CARIID=” + id + “”;DataTable dt = SqlClass.GetDataTable(sqlCumle, “local”);foreach (DataRow dr in dt.Rows){string gelen = dr[1].ToString();for (int i = 0; i < chcgrubu.Items.Count; i++){if (chcgrubu.Items[i].ToString() == gelen.ToString()){chcgrubu.SetItemChecked(i, true);}}}