How to access a named table from a repeater control with the eval method

[Georg Mayer]

Hi,
In my DataSet, which is bound to a repeater, I have two tables: item
and child:
ds = new DataSet();
itemadapter.Fill(ds, "item");
childadapter.Fill(ds, "child");

How do I access e.g. the item table and the colums in it from my
itemtemplate of the repeater control?

I'v tried the following code which doesn't work:
<asp:Repeater ID="Repeater1" Runat="server" >
<ItemTemplate>
<td>
<asp:Label Runat="server" Text='<%#
DataBinder.Eval(Container.DataItem,
"Tables[item].DefaultView.[0].Price") %>' ></asp:Label>
</ItemTemplate>
</asp:Repeater>

I get an exception there: "DataBinding: 'System.Data.DataRowView' does
not contain a property with the name 'Tables'."

Can anyone tell how I could get the information from that "item"
table?

Thanx

Georg

 

[Scott Allen]

Hi Geog:

One way to do this would be to make the DataSet a protected field in
your code behind (the base class).

Then you will be able to do something like:

<%# DataBinder.Eval(myDataSet, "Tables[1].DefaultView[0][0]") %>

The trick will be in knowing what row you need to access, but perhaps
you already have that setup to work.

HTH,