MY TEST

CheckedListbox databinding Data retrieval

//Bind CheckedListbox using SqlDataAdaprtor
query=”select id,name from details”;
SqlDataAdaptor adap=new SqlDataAdaptor(query,cnn);
DataTable tb=new DataTable();
adap.fill(tb);
checkedListbox1.DataSource=tb;
checkedListbox1.DisplayMember=”name”;
checkedListbox1.ValueMember=”id”;
//Retirve Data from checkedListbox
foreach (object chk_shop in checkedListBox1.CheckedItems)
{
Messagebox.show( ((DataRowView)chk_shop).Row.ItemArray[0].ToString() );//get the value member
Messagebox.show( ((DataRowView)chk_shop).Row.ItemArray[1].ToString() );//get the display member
}