repeater show the field data of 2 same table

[Budd]

i find some problem on repeater when i want to join 2 same table to 1 table
e.g.
company(id, customerid1, customerid2)
customer(id, name)
and join company to 2 customer table(customerid1=>customer.id and
customerid2=>customer.id)

when i use the code <%# DataBinder.Eval(Container.DataItem,
"customertable1.name") %>

it error and show
'System.Data.Common.DbDataRecord' does not contain a property with the name
customertable

customertable1 is the other name of customer table

and i find that it don't support table with field format for get the data

So how to show the "customer.name"?

any solution??

thx a lot

[Eliyahu Goldin]

I assume you made a query in such a way that the resulting record set is a
single table.

Try giving alias name to the columns, like

select ... customertable1.name as Customer1Name..

Eliyahu

"Bu**@ASP.net" <fng¢Ihk.com> wrote in message
news:ei*************@TK2MSFTNGP10.phx.gbl...

i find some problem on repeater when i want to join 2 same table to 1 table
e.g.
company(id, customerid1, customerid2)
customer(id, name)
and join company to 2 customer table(customerid1=>customer.id and
customerid2=>customer.id)

when i use the code <%# DataBinder.Eval(Container.DataItem,
"customertable1.name") %>

it error and show
'System.Data.Common.DbDataRecord' does not contain a property with the
name customertable

customertable1 is the other name of customer table

and i find that it don't support table with field format for get the data

So how to show the "customer.name"?

any solution??

thx a lot

[Budd]

it work
thx a lot
"Eliyahu Goldin" <re*************@monarchmed.com> ¼¶¼g©ó¶l¥ó·s»D:eS**************@tk2msftngp13.phx.g bl...

I assume you made a query in such a way that the resulting record set is a
single table.

Try giving alias name to the columns, like

select ... customertable1.name as Customer1Name..

Eliyahu

"Bu**@ASP.net" <fng¢Ihk.com> wrote in message
news:ei*************@TK2MSFTNGP10.phx.gbl...

i find some problem on repeater when i want to join 2 same table to 1
table
e.g.
company(id, customerid1, customerid2)
customer(id, name)
and join company to 2 customer table(customerid1=>customer.id and
customerid2=>customer.id)

when i use the code <%# DataBinder.Eval(Container.DataItem,
"customertable1.name") %>

it error and show
'System.Data.Common.DbDataRecord' does not contain a property with the
name customertable

customertable1 is the other name of customer table

and i find that it don't support table with field format for get the data

So how to show the "customer.name"?

any solution??

thx a lot