how retrieve data from checkedlistbox selected and show data in datagr

I use these code to retrieve data from checkedlistbox selected and show data in datagrideview

problem query retrieve data one checkedlistbox selected not multi checkedlistbox selected I want to retrieve data in datagrideview with multi checkedlistbox selected

string s = "";
int x;
for (x = 0; x <= checkedListBox1.CheckedItems.Count - 1; x++)
{
s = "'" + checkedListBox1.CheckedItems[x].ToString() + "',";
}
s = s.Substring(0, s.Length - 1);
con = new SqlConnection(cs.DBConn);
con.Open();
cmd = new SqlCommand("select id,'',raqam,name_sender,country1,country2,tel1,tel2,title,detalis,n_number,price,ship,total,name from pos where country2 IN("+s+") order by id asc ", con);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
bunifuCustomDataGrid1.Rows.Clear();
while (rdr.Read() == true)
{
bunifuCustomDataGrid1.Rows.Add(rdr[0], rdr[1], rdr[2], rdr[3], rdr[4], rdr[5], rdr[6], rdr[7], rdr[8], rdr[9], rdr[10], rdr[11], rdr[12], rdr[13], rdr[14]);
bunifuCustomDataGrid1.Rows.OfType().Last().Selected = true;
bunifuCustomDataGrid1.CurrentCell = bunifuCustomDataGrid1.Rows[bunifuCustomDataGrid1.Rows.Count - 1].Cells[1];
}
con.Close();

In your ASPX page you've got the list like this:

"YrChkBox" runat="server" onselectedindexchanged="YrChkBox_SelectedIndexChanged"> "button" runat="server" Text="Submit" />

In your code behind aspx.cs page, you have this:

protected void YrChkBox_SelectedIndexChanged(object sender, EventArgs e)
{
// Create the list to store.
List YrStrList = new List<string>();
// Loop through each item.
foreach (ListItem item in YrChkBox.Items)
{
if (item.Selected)
{
// If the item is selected, add the value to the list.
YrStrList.Add(item.Value);
}
else
{
// Item is not selected, do something else.
}
}
// Join the string together using the ; delimiter.
String YrStr = String.Join(";", YrStrList.ToArray());
// Write to the page the value.
Response.Write(String.Concat("Selected Items: ", YrStr));
}

Ensure you use the if (!IsPostBack) { } condition because if you load it every page refresh, it's actually destroying the data.

1 Reply

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

Aman Gupta6y ago
In your ASPX page you've got the list like this:
"YrChkBox" runat="server" onselectedindexchanged="YrChkBox_SelectedIndexChanged"> "button" runat="server" Text="Submit" />
In your code behind aspx.cs page, you have this:
protected void YrChkBox_SelectedIndexChanged(object sender, EventArgs e)
{
    // Create the list to store.
    List YrStrList = new List<string>();
    // Loop through each item.
    foreach (ListItem item in YrChkBox.Items)
    {
        if (item.Selected)
        {
            // If the item is selected, add the value to the list.
            YrStrList.Add(item.Value);
        }
        else
        {
            // Item is not selected, do something else.
        }
    }
    // Join the string together using the ; delimiter.
    String YrStr = String.Join(";", YrStrList.ToArray());

    // Write to the page the value.
    Response.Write(String.Concat("Selected Items: ", YrStr));
}
Ensure you use the if (!IsPostBack) { } condition because if you load it every page refresh, it's actually destroying the data.