Querying data in Datatables -> Help!

[johnnykenshien]

Hello guyz im only beginner in vb.net please be patient with my quetions, I want to query specific article# 234,123,432 inside datatable1 and put it in a new datatable. Thanks in advance.


example:
datatable1:
Article# Barcode# Description
234 0000123 item1
123 0000122 item2
345 0100123 item3
567 0000125 item5
432 2100123 item6
344 0020123 item7


Desired Output

Article# Barcode# Description
234 0000123 item1
123 0000122 item2
432 2100123 item6

 

[cjard]

we'd normally get the database to do this using a query like (Oracle syntax):

SELECT * FROM table WHERE articleNumber = :articleParameter


And then set ClearBeforeFill to FALSE on the tableadapter

And then call the FillByArticleNumber method 3 times:

myTableAdapter.FillByArticleNumber(myDataTable, 234)
myTableAdapter.FillByArticleNumber(myDataTable, 123)
myTableAdapter.FillByArticleNumber(myDataTable, 432)