locked
Can Dataset support where IN (@id) clause ? RRS feed

  • Question

  • User-313791273 posted

    In sql,  we can run "select * from TableA where id in (1,3,5)" to retrieve records where id is 1 or 3 or 5

    I want to build a dataset that select data depends on the id.

    In dataset, my TableAdapter is "select * from TableA where id IN (@id)"

    but it had display an error that cannot convert string to int32.

     

    Can dataset support where IN (@id) condition ?  If not, How can i pass this parameter for the where clause ?

    Thanks

     

    Joe

     

    Wednesday, March 16, 2011 2:55 AM

Answers