Enumaration yielded no results

hi sir,

 

i will worked out your codes changed but the datareader values in not coming  Enumaration yielded no results it showing ..

 

 

code: this is entire code i am using to get values for checkeditems to be showed in checkedlistboxitems.

 

private void GvCategory_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
indexRow = e.RowIndex;
DataGridViewRow row = GvCategory.Rows[indexRow];
txtcategory.Text = row.Cells[1].Value.ToString();

//txtcategory.ReadOnly = true;
btncategory.Text = "Update";
rbyes.Checked = true;



if (txtcategory.Text != String.Empty)
{
try
{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RetailTestConnection"].ConnectionString);
con.Open();
string query = String.Format("Select B.BrandId from Brand_Mst B JOIN Category_brand_Tbl cb on B.BrandId = cb.BrandId JOIN Category_Mst c on c.CategoryId = cb.CategoryId Where c.categoryname = @Name");
//string query = String.Format("Select B.BrandId from Brand_Mst B JOIN Category_brand_Tbl cb on B.BrandId = cb.BrandId JOIN Category_Mst c on c.CategoryId = cb.CategoryId Where c.categoryname = ' " + txtcategory.Text + " ' ");
SqlCommand cmd = new SqlCommand(query,con);
cmd.Parameters.Add(new SqlParameter("Name", txtcategory.Text));
SqlDataReader dr = cmd.ExecuteReader();
string[] s = new string[] { };


while (dr.Read())
{
s = dr.ToString().Split(',');

}
int Length = s.Length;
for (int i = 0; i < Length; i++)
// for (int i = 0; i <= 1; i++)
{
string fetr = s[i];
for (int j = 0; j <= clbbrand.Items.Count - 1; j++)
{
if (clbbrand.Items[j].ToString() == s[i])
{
clbbrand.SetItemChecked(j, true);
break;
}
}
}

}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}

}

 

screen short: i will atached

 

sir help how to checkedlistitems how showed with checked mark,

 

this checkedlistbox with automatic inserting Items..

You need little changes:

 Note: See yellow color as changes and red color you need to change.