Last post Mar 16, 2011 03:53 AM by Mikesdotnetting
Mar 16, 2011 02:55 AM|joeyan|LINK
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 ?
Mar 16, 2011 03:53 AM|Mikesdotnetting|LINK
This should help: