im creating wfp application i want to retrieve table to datagridview
with multi value selected in listbox, getting all data that selected from listbox, so the main idea
is apply this query from sql to application 

```
select * from Vwtb where firstname='' or firstaname='' or ..

```

i have tried with while loop and searched a lot but not worked this is my code please if its something strange for you im not professional :)

```
string[] orand = { "or"+listBox1.Text };
        foreach (string sm in orand)
        {

            cn.Open();
            string select = "select * from productvw where firstname='" + sm + "'";

            SqlDataAdapter dataAdapter = new SqlDataAdapter(select, cn);

            SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
            DataTable ds = new DataTable();
            dataAdapter.Fill(ds);
            dataGridView1.ReadOnly = true;
            dataGridView1.DataSource = ds;
            cn.Close();
        }

```

any type of help will be so appreciated ....