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?
create a string with the ids as a parameter to the CustomFill method to be used in an IN clause?
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
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?
VB.NET:
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?
VB.NET:
me.TransactionsTableAdpater.CustomFill(strIDList)
SELECT ..... WHERE ID IN @IDList
Create a temporary dataset/tableadapter and work with this?
Thanks