Asp.Net repeater

[=?Utf-8?B?QklKVQ==?=]

In repeater control, the databinding expression like <td><%#
DataBinder.Eval(Container.DataItem, "au_id") %></tdcan I can use any
variable name instead of "au_id". I need it becose i am taking this value
from several tables and there is slight difference in the name of filed
between tables. Kindly provide solution and thanks in advance
BIJU

[Aidy]

In the SQL that you are getting your data from;

SELECT
A.au_id as 'a_au_id',
B.au_id as 'b_au_id'
FROM
A
JOIN B on A .....

That way your results will rename the fields "a_au_id" and "b_au_id" rather
than having two "au_id" fields.

"BIJU" <BI**@discussions.microsoft.comwrote in message
news:C8**********************************@microsof t.com...

In repeater control, the databinding expression like <td><%#
DataBinder.Eval(Container.DataItem, "au_id") %></tdcan I can use any
variable name instead of "au_id". I need it becose i am taking this value
from several tables and there is slight difference in the name of filed
between tables. Kindly provide solution and thanks in advance
BIJU

[=?Utf-8?B?QklKVQ==?=]

Hai Aidy,
Actually the problem with me is that I have 7 tables in my database and
depends upon the users selection different table will be processed. In each
table, there are some differece in the name of the fields. But in the data
binding in the repeater control, in the HTML part I have to mention the field
name. As it is taken from diff. tables, I cant specify the field name. Kindly
provide solution

"Aidy" wrote:

In the SQL that you are getting your data from;

SELECT
A.au_id as 'a_au_id',
B.au_id as 'b_au_id'
FROM
A
JOIN B on A .....

That way your results will rename the fields "a_au_id" and "b_au_id" rather
than having two "au_id" fields.

"BIJU" <BI**@discussions.microsoft.comwrote in message
news:C8**********************************@microsof t.com...

In repeater control, the databinding expression like <td><%#
DataBinder.Eval(Container.DataItem, "au_id") %></tdcan I can use any
variable name instead of "au_id". I need it becose i am taking this value
from several tables and there is slight difference in the name of filed
between tables. Kindly provide solution and thanks in advance
BIJU

[Aidy]

You're probably better off using code-behind and dynamically decided on what
your columns will bind to depending on your dataset. The way you are
binding now is fine for more static implementations, but not for what you
want to do.

"BIJU" <BI**@discussions.microsoft.comwrote in message
news:D6**********************************@microsof t.com...

Hai Aidy,
Actually the problem with me is that I have 7 tables in my database and
depends upon the users selection different table will be processed. In
each
table, there are some differece in the name of the fields. But in the data
binding in the repeater control, in the HTML part I have to mention the
field
name. As it is taken from diff. tables, I cant specify the field name.
Kindly
provide solution

"Aidy" wrote:

>In the SQL that you are getting your data from;

SELECT
A.au_id as 'a_au_id',
B.au_id as 'b_au_id'
FROM
A
JOIN B on A .....

That way your results will rename the fields "a_au_id" and "b_au_id"
rather
than having two "au_id" fields.

"BIJU" <BI**@discussions.microsoft.comwrote in message
news:C8**********************************@microso ft.com...

In repeater control, the databinding expression like <td><%#
DataBinder.Eval(Container.DataItem, "au_id") %></tdcan I can use any
variable name instead of "au_id". I need it becose i am taking this
value
from several tables and there is slight difference in the name of filed
between tables. Kindly provide solution and thanks in advance
BIJU

[George Ter-Saakov]

Use aliases..

so it will be
SELECT field1 as a, field 2 as b FROM Table1
SELECT anotherfield1 as a, anotherfield 2 as b FROM Table1

and in your Repeater you would bind to aliases
DataBinder.Eval(Container.DataItem, "a")
DataBinder.Eval(Container.DataItem, "b")

George.
"BIJU" <BI**@discussions.microsoft.comwrote in message
news:D6**********************************@microsof t.com...

Hai Aidy,
Actually the problem with me is that I have 7 tables in my database and
depends upon the users selection different table will be processed. In
each
table, there are some differece in the name of the fields. But in the data
binding in the repeater control, in the HTML part I have to mention the
field
name. As it is taken from diff. tables, I cant specify the field name.
Kindly
provide solution

"Aidy" wrote:

>In the SQL that you are getting your data from;

SELECT
A.au_id as 'a_au_id',
B.au_id as 'b_au_id'
FROM
A
JOIN B on A .....

That way your results will rename the fields "a_au_id" and "b_au_id"
rather
than having two "au_id" fields.

"BIJU" <BI**@discussions.microsoft.comwrote in message
news:C8**********************************@microso ft.com...

In repeater control, the databinding expression like <td><%#
DataBinder.Eval(Container.DataItem, "au_id") %></tdcan I can use any
variable name instead of "au_id". I need it becose i am taking this
value
from several tables and there is slight difference in the name of filed
between tables. Kindly provide solution and thanks in advance
BIJU