Check the items in checkedlistbox while updating using database in C#

See more:

C#

Visual-Studio

DataGridView

, +

I need to fetch data from datagridview to checkedlistbox while updating in windows form in C#.

Data will be already stored in database (like:- A, B, C, D, )during insert operation, while updating i need to fetch the data from database to checkedlistbox, and the data should be checked.

Data from database will be split and should compare with data in checkedlistbox, if both database item and checklistbox items equal then the item in checkedlistbox should be checked.

What I have tried:

string category = dgEntry.CurrentRow.Cells[8].Value.ToString();
string[] strCat = category.Split(',');
int length = strCat.Length;
for (int i = 0; i < length ; i++)
{
    string fetch = strCat[i];
    foreach (object item in clbEntry_IndividualItems.Items)
    {
        DataRowView row = item as DataRowView;
        if (row[0].ToString() == strCat[i].ToString())
        {
            clbEntry_IndividualItems.SetItemChecked(i, true);
        }
    }
}

I a beginner in c#, Please help to solve this problem