I have two DataTables, I need to populate the Data from both the Tables.but i don't have a foriegn key to establish relation.

how to get the Data from two Tables.

I have one column which is having keywords in first DataTable.The Second Table have the values of those keywords as columns

how do establish a relation between them

5 Years
Discussion Span
Last Post by IKhan123

Do you need the two dataTables? It sounds like you could alter what you extract from the database to include eveything you need. If that isn't possible you can use the Merge method to merge two dataTables with differing schemas. That should help. The MSDN articles are pretty useful for that.


Well, its a little confusing what you are trying to say, u either have a table in a sql server or your have your data stored in excel sheets as a file. OR do u have a datatable filled with values already and then merge them to one datatable?


Can you write is down the tables structure (table names)? So we can see what is the connection between those 2 tables.


forget abt the DataTables I have two sheets with data and i need to Validate the first sheet and get the relevant Data from second Sheet.

For stucture plz find the attachment

Edited by IKhan123

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.