[RESOLVED] Populating datagrid with columns with multiple tables.

[lleemon]

Using ASP.NET (vb), I have two tables and joining on ID. I am having some issues populating my datagrid with a dataset.

Here is what I have so far:

Dim conPubs as SqlConnection
Dim dsSearch1 as DataSet
Dim dsSearch2 as DataSet
Dim adSearch1 as SqlDataAdapter
Dim adSearch2 as SqlDataAdapter
Dim iRecordsFound as Integer
Dim sSearch as String
 
conPubs = New SqlConnection(...)
 
sSearch = txtSearch.Text("'", "''")
If sSearch.Length > 0 Then
 sSQL1 = "SELECT PRD_ID, BRAND, MODEL FROM t_products "
 sSQL1 &= "WHERE BRAND like '%" & sSearch & "' "
 sSQL1 &= "ORDER BY BRAND"
 
 sSQL2 = "SELECT RATING, RECOMMEND FROM t_details"
Else
 sSQL1 = "SELECT PRD_ID, BRAND, MODEL FROM t_products "
 sSQL1 &= "ORDER BY BRAND"
 
 sSQL2 = "SELECT RATING, RECOMMEND FROM t_details"
End If
 
adSearch1 = New SqlDataAdapter(sSQL1, conPubs)
adSearch2 = New SqlDataAdapter(sSQL2, conPubs)
 
dsSearch1 = New DataSet()
dsSearch2 = New DataSet()
 
adSearch1.Fill(dsSearch1, "t_products")
adSearch2.Fill(dsSearch2, "t_products")
 
Dim pk1(0) as DataColumn
Dim pk2(0) as DataColumn
 
pk1(0) = dsSearch1.Tables(0).Columns("PRD_ID")
dsSearch1.Tables(0).PrimaryKey = pk1
 
pk2(0) = dsSearch2.Tables(0).Columns("PRD_ID")
dsSearch2.Tables(0).PrimaryKey = pk2
 
dsSearch1.Merge(dsSearch2, false, MissingSchemaAction.Add)
 
conPubs.Open()
iRecordsFound = dsSearch1.Tables("t_products").Rows.Count.ToString()
lblRowCount.Text = iRecordsFound
 
datagridOutput.DataSource = dsSearch1
datagridOutput.DataBind()
conPubs.Close()

The error I get now is:
System.ArgumentNullException: 'column' argument cannot be null. Parameter name: column

Any help would be great or better way of doing this is welcome as well.
Thanks.