Hi have 2 listboxs with selectmode set to 'multiple', the options in the listboxs are:
The comma separated list I'm creating to pass to my sql looks like this:
String strSegment = String.Empty;
foreach (ListItem li in lstNum.Items)
strSegment += "'" + liSegment.Value + "',";
strSegment = strSegment.Substring(0, strSegment.Length - 1);
My Stored Procedure looks like this:
select * from
Numbern in (@NumList)
Letters in (@LetterList)
I'm lost about what to do when a user select 'All' or 'All','1','2','3' or doesn't select anything.
I know these are a lot of questions, I'm hoping to get some guidance or an example of how to handle passing multi select values to sql to return a dataset. Thank you in advance for any assistance.