C# CheckedListBox İşlemleri

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