>>>>>
>>>>>I think Sergey nailed it, but now it's not clear how to set multiple parameters?
>>>>
>>>>Set them in the order they will be used
>>> Parameters(1) ?
>>>Parameters(2) ?
>>The SQL statement should be something like 'Select from x where y=? and z=?' . The question marks will be replaced by the parameters in the order in which they were added in .NET
>
>I still don't understand exactly, can you post a quick sample?
http://www.west-wind.com/WebLog/posts/660586.aspx