hello
You'll have to run all your SQL statements either way, but then once you
have all the tables in a dataset you can create the relationship(s). Here's
a snippet of code that shows how to create a relationship.
' Create and fill the DataSet.
m_DataSet = New DataSet
m_da_Addresses.Fill(m_DataSet, "Addresses")
m_da_TestScores.Fill(m_DataSet, "TestScores")
' Define the relationship between the tables.
Dim data_relation As New _
DataRelation("Addresses_TestScores", _
m_DataSet.Tables("Addresses").Columns("ContactID") , _
_
m_DataSet.Tables("TestScores").Columns("ContactID" ))
m_DataSet.Relations.Add(data_relation)
Once your relationships are created you can do some pretty neat things with
DataViews I think you should be able to query your tables and look for like
names but with different numbers.
Latest Technology Trainer
And Part time software consultant
Bhanubysani, if this helps please login to Mark As Answer. | Alert Moderator