I am creating an VB.Net program that is using a MS Access database on the backend. I need to create a relationship between two tables but I am not familar with how to do this with ADO.Net.
Right now I have the following data adapters and datasets:
Dim da1 As New OleDb.OleDbDataAdapter("SELECT * FROM table1", Conn)
Dim da2 As New OleDb.OleDbDataAdapter("Select * From table2", Conn)
How do I make a relationship between two tables (and two datasets) using ADO.Net in code (I do not want to use any of the wizards for this, I would like to code it all myself) ?