Selecting multiple items from a checkbox and adding to an existing SQL Server query into an if statement in ASP.NET

Question

I wanted to know if I can add to the existing SQL Server query in ASP.NET code. I have multiple drop-down menus, check boxes and buttons in the designer. I have a checkbox where if one or more items are selected, it adds to the query.

For example: I have a checkbox called PositionList with multiple positions: Sales, Marketing, Tech Support, HR, and Finance and I wish to create a table where I can select one or more item and get a result of people from those positions.

public partial class _Default : Page
{
    string connection1 = "Server = myserver" 
    string querystring1 = "select name, age, gender, race, city,convert(varchar, datehired, 100) as 'Date Hired', position from NewEmployeesList"
}
...

protected void btnnormal_Click(object sender, EventArgs e)
{
    SqlConnection conn1= new SqlConnection(connection1)
    SqlCommand command1 = new SqlCommand(queryString1, conn1);

    DataTable table1 = new DataTable();

    conn1.Open();
    command1.CommandTimeout = 300; 

    Data1.Fill(table1)

    string DoH = query
    GridView1.DataSource = table1;
    GridView1.DataBind();

    // the table works fine up until this point
    foreach (ListItem li in PositionList.Items)
    {
        if (li.Selected == true)
        { 
            queryString1 + " and position = " + PositionList.SelectedItem;
        }
    }

    // this is the part where I am a stuck, not sure how to add to the 
    // SQL Query properly and how I can check multiple checkboxes so it 
    // returns the table with those positions

TAHA SULTAN TEMURI · Accepted Answer · 2020-02-07 18:08:45Z

1

You can use in query

queryString1 = " and position IN( ";
List<string> selected = new List<string>();
  foreach (ListItem li in PositionList.Items)
{
    if (li.Selected == true)
    { 
     selected.Add( PositionList.SelectedItem);
    }
}
 // values in comma
 queryString1+=string.Join(",", selected.Select(x => $"'{x}'"))

  queryString1+=")";

answered Feb 7, 2020 at 18:08

TAHA SULTAN TEMURI

5,5593 gold badges46 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

Selecting multiple items from a checkbox and adding to an existing SQL Server query into an if statement in ASP.NET

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related