<div>
typo... please refer to the following for the select statement<br />

<pre><code id="code-310451">select * from table1 where 
exists(SELECT 1 FROM dbo.fnSplitCommaList(@selectedList,',') where strValue = table1.field1)
</code></pre>
</div>


typo... please refer to the following for the select statement


select * from table1 where 
exists(SELECT 1 FROM dbo.fnSplitCommaList(@selectedList,',') where strValue = table1.field1)


<div>
The easiest will be to loop the selecteditems and store it in a string to pass it as a parameter<br />
string selitems = &quot;&quot;;<br />
for(int cnt =0;cnt &lt;= listBox1.SelectedItems.Cou<wbr />nt -1;cnt++)<br />
&nbsp; &nbsp; {<br />
&nbsp; &nbsp; &nbsp; selitems &nbsp;= selitems &nbsp;+ &quot;,&quot; + listBox1.SelectedItems[cnt<wbr />]; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; }<br />

</div>


The easiest will be to loop the selecteditems and store it in a string to pass it as a parameter
string selitems = "";
for(int cnt =0;cnt <= listBox1.SelectedItems.Count -1;cnt++)
    {
      selitems  = selitems  + "," + listBox1.SelectedItems[cnt];                          
    }


<div>
<div class="content wysiwyg-content">
Has anybody ever created a Listbox with a multiselect. Then managed to pass the selected item values accross to a stored procedure as OR statements. <br />
<br />
For example the selection is 1,2,3 therefore the SQL statement will be 1 or 2 or 3
</div>
</div>


Has anybody ever created a Listbox with a multiselect. Then managed to pass the selected item values accross to a stored procedure as OR statements. 

For example the selection is 1,2,3 therefore the SQL statement will be 1 or 2 or 3

listbox mutliselect

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.