V2003: Multi-Table Dataset in DataGrid

[bh]

Using the pubs database, for testing, and example, I'm trying to bind a
datagrid that draws data from multiple tables to use for updating multiple
rows at once. For my example, I want to display Titles, Authors & Prices,
and update the prices. The code I'm using is below, but I get an exception,
on binding the grid stating "A field or property with the name 'Pub_name'
was not found on the selected datasource". In the command window, in Debug
mode, I've verified that the data is in the dataset for both tables.
Pub_name is on the parent table, so how would I reference that on the
datagrid? Thanks in advance.

BH

conn.Open()
Dim daPub As SqlDataAdapter = New SqlDataAdapter( "SELECT * FROM
Publishers", conn)
Dim daTitles As SqlDataAdapter = New SqlDataAdapter( "SELECT * FROM
Titles", conn)

Dim ds As New DataSet
daPub.Fill(ds, "Publishers ")
daTitles.Fill(d s, "Titles")

Dim data_relation As New _
DataRelation("T itlePublishers" , _
ds.Tables("Publ ishers").Column s("Pub_Id"), _
ds.Tables("Titl es").Columns("P ub_Id"))
ds.Relations.Ad d(data_relation )

DataGrid1.DataS ource = ds
DataGrid1.DataK eyField = "Title_id"
DataGrid1.DataM ember = "Titles"
DataGrid1.DataB ind()

conn.Close()

The DataGrid's columns are as follows:
<asp:BoundColum n DataField="Titl e_ID" />
<asp:BoundColum n DataField="Titl e" HeaderText="Tit le" />
<asp:BoundColum n DataField="Pub_ id" />
<asp:BoundColum n DataField="Pub_ name" HeaderText="Pub lisher" />
<asp:TemplateCo lumn HeaderText="Pri ce">
<ItemTemplate >
<asp:TextBox id="txtPrice" runat="server" MaxLength="6"
Columns="6" Text='<%# DataBinder.Eval (Container, "DataItem.Price ") %>' />
</ItemTemplate>
</asp:TemplateCol umn>