hi,

I am using datarelation to join two datatables.
Here is my code,
Code:
 Dim dt1 As New DataTable
            dt1.Load(dr1)
            Dim dt2 As New DataTable
            dt2.Load(dr2)

            Dim datarelation As DataRelation
            Dim dc1 As DataColumn
            Dim dc2 As DataColumn
            Dim ds As New DataSet

            ds.Tables.Add(dt1)
...