SQL Server Query to select items which not in a listbox

Mohammed Ashraf

ID	Name
1	Jose
2	Jayan
3	Jinas
4	Jasmin

I have a table in sql server. And I made a ListBox in windows Form application.

I want to select names of which ID not shown in the ListBox by using 'not in' statment.

Please help

7 Replies

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

Amit Gupta9y ago
@Mohammad

You can either use linq query or use for loop for this
var result = string.Join(", ", listbox1.Items.Select(i => i.Value));

Then pass result in your query
Select * from tableName where Id not in (result);
Ramesh Palanivel9y ago
Hi Mohammed,

Try this code
string value = "";
            foreach (var item in listBox1.Items)
            {
                value += item.ToString() + ",";
            }
            value = value.Substring(0, (value.Length - 1));

string query="select name from student where id not in ("+value+")"
Ramesh Palanivel9y ago
HI Mohammed,

Get the selected item from list box
strin value="";
foreach (ListItem li in ListBoxStep1.Items)
{
    if (li.Selected)
    {
       value=value+li.Selectedvalue+",";
    }
}
value=value.SubString(value,value.length-1);
Pass this "Value" into sql query
string query="select Name from Student where Id not in ("+value+")";
Mohammed Ashraf9y ago
Sir my code is as follows,

select name from tblstudent where ID not in ' " + listBox1.items+" ';

But this is not working. Can you suggest another one please...???
My proble is about ListBox not about sql query
Amit Gupta9y ago
Use NOT IN clause
Select * from tableName where Id not in (1,2,4);
Where 1,2 and 4 is the listbox items
Mohammed Ashraf9y ago
I am familiar with this query statement. I want to deal with windows Form listbox controle
Ramesh Palanivel9y ago
HI mohammed,

Try this code
SELECT Name FROM student WHERE NOT EXISTS
( SELECT ID FROM student
WHERE in (1,2,4) )