Select from two DataTables for each record
Posted on 2011-10-20
I am using Windows Forms.
I have a DataTable with the column where I have ID-s of my products. I need to create another column, where are displayed names of the products, which means: I have to traverse all ID-s and for each ID search on another table, which consists of ID-s and ID names and for each record find ID name. The only problem here is, that traversing through all records in the DataTable and write each particular record in new column is very, very slow.
How can I solve this faster?
My first tables column: ID
My seoond tables columns: ID, ID_Name
It is possible for me to query the database directly, but what is the query to find names for each particular ID in the first table?
My final result should like:
(names for each particular ID) - so only one column should be in return.