Search selected checkbox values

I have a dropdown with checkbox list. When I select items and try to display in the grid by clicking the search button, I'm not able to do that.

protected void btnSearchEmpCode_Click(object sender, EventArgs e)

{

string selectedValues = string.Empty;

foreach (ListItem item in cblEmpCode.Items)

{

if (item.Selected)

selectedValues += "'" + item.Value + "',";

}

if (selectedValues != string.Empty)

selectedValues = selectedValues.Remove(selectedValues.Length - 1);

SqlConnection con = new SqlConnection(strcon);

SqlCommand cmd = new SqlCommand("SELECT *FROM Details WHERE Emp_Code IN (" + selectedValues + ")", con);

SqlDataAdapter Adpt = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

Adpt.Fill(dt);

AIGrids.DataSource = dt;

AIGrids.DataBind();

}

Can anyone correct me if I have went wrong somewhere.

Updated on 10-Dec-2013

protected void btnSearchEmpCode_Click(object sender, EventArgs e)
{
    string selectedValues = string.Empty;
    foreach (ListItem item in cblEmpCode.Items)
    {
        if (item.Selected)
            selectedValues += item.Value + ",";
    }

    if (selectedValues != string.Empty)
        selectedValues = selectedValues.Remove(selectedValues.Length - 1);
    SqlConnection con = new SqlConnection(strcon);
    SqlCommand cmd = new SqlCommand("SELECT * FROM Details WHERE Emp_Code IN (" + selectedValues + ")", con);
    SqlDataAdapter Adpt = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    Adpt.Fill(dt);
    AIGrids.DataSource = dt;
    AIGrids.DataBind();
}

forum

Search selected checkbox values

Anonymous User

1 Answers

Liked By