SQL Server Query to select items which not in a listbox

Question

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. 1 2 4 I want to select names of which ID not shown in the ListBox by using 'not in' statment. Please help

Amit Gupta · Answer

@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);

Amit Gupta · Answer

Use NOT IN clause Select * from tableName where Id not in (124); Where 12 and 4 is the listbox items

Ramesh Palanivel · Answer

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 Palanivel · Answer

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(valuevalue.length-1); Pass this Value into sql query string query= select Name from Student where Id not in ( +value+ ) ;

Mohammed Ashraf · Answer

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

Mohammed Ashraf · Answer

I am familiar with this query statement. I want to deal with windows Form listbox controle

Ramesh Palanivel · Answer

HI mohammed Try this code SELECT Name FROM student WHERE NOT EXISTS ( SELECT ID FROM student WHERE in (124) )