The best approach to getting a data subset

[pachjo]

I have a listview that has a context menu that facilitates the selecting of multiple rows and stores the selected id in an array which is then passed to a function to work on.

No once in the function I want to access only the items in my table that has a matching id in the array but cannot figure out the best approach.

Are any or all or none of these the way to do it?

call with a sql statement?

me.MyFinanceDataSet1.Transactions.Select("an sql statement goes here")

create a string with the ids as a parameter to the CustomFill method to be used in an IN clause?

me.TransactionsTableAdpater.CustomFill(strIDList)

But I cannot see how to create the sql in the tableadapter that allows something like:
SELECT ..... WHERE ID IN @IDList

Create a temporary dataset/tableadapter and work with this?

Thanks

 

[cjard]

oh... maybe cause I'm a nerd, i remember things by name rather than grouping, so my props are A-Z