Using Drop-down with Check-boxes in Asp.net

Question

I have 2 drop-down boxes and i want the first drop-down to filter the 2nd one like cascading so the first one has check-boxes and i want to pass the selected items from the first one to the 2nd but getting a "syntax error". I run it into debug mode and the output result looks like this

CommandText "select  id, name FROM myTable where id in (''CKU019','CW5036'') "

and it seems there is extra apostrophe near CKU019. Here is my code

protected void bindDDL()
    {
      string selectedValues = string.Empty;
      foreach (ListItem item in ddchkCountry.Items)
      {
        if (item.Selected)
          selectedValues += "'" + item.Value + "',";
      }
      if (selectedValues != string.Empty)
        selectedValues = selectedValues.Remove(selectedValues.Length - 1);
      SqlConnection con = new SqlConnection(strConnString);
      con.Open();
      SqlCommand cmd = new SqlCommand("select  id, name FROM myTable where id in ('" + selectedValues + "')", con);
      SqlDataAdapter da = new SqlDataAdapter(cmd);
      DataSet ds = new DataSet();
      da.Fill(ds);
      con.Close();
      facDDL.DataSource = ds;
      facDDL.DataTextField = "name";
      facDDL.DataValueField = "id";
      facDDL.DataBind();
    }

Shane Ray · Accepted Answer · 2017-03-18 20:01:06Z

1

Remove the extra ' wrapping your selected values...

SqlCommand cmd = new SqlCommand("select id, name FROM myTable where id in (" + selectedValues + ")", con);

answered Mar 18, 2017 at 20:01

Shane Ray

1,4691 gold badge13 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shane Ray Over a year ago

No problem, please remember to mark this as the answer if it helped you.

Collectives™ on Stack Overflow

Using Drop-down with Check-boxes in Asp.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related