Search DataTable when checkedListbox items are checked

Ajeet Singh

I want to search the DataTable where column paymentMode == checkedListBox.checked item text.

DataTable table = dataTableRegister.Clone();

DataRow row;

foreach (string s in checkedListBox.CheckedItems)

{

foreach (DataRow dr in datatableRegister.Select("PayMode = s"))

{

table.Rows.Add(dr);

}

DataGridView1.DataSource = table;

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ronika Jency7y ago
Accepted answer
Hello,

Check below link,

https://social.msdn.microsoft.com/Forums/vstudio/en-US/fd0df740-f1a3-4261-870f-3690b0989fa7/compare-items-in-checkedlistbox-to-datatable?forum=csharpgeneral
Ronika Jency7y ago
Thanks Ajeet for accepting my answer and for mark too.
Ajeet Singh7y ago
@Ronika Jency
Thank you so much. it was so easy and i was messing with LINQ instead use to simple if conditions.
Jignesh Kumar7y ago
Hi Ajeet,

Please find below link which will help you to resolve your issue

https://forums.asp.net/t/1648387.aspx?Checkboxlist+as+a+filter+for+DataView
DataView DataView1 = new DataView(datatableRegister);

string[] checkedValues = checkedListBox.Items.Cast()
                                        .Where(a => a.Selected)
                                        .Select(a => a.Value).ToArray();

DataTable dt = DataView1.Table.AsEnumerable()
                        .Where(a => checkedValues.Contains(a["PayMode "].ToString()))
                        .CopyToDataTable();