In repeater control, the databinding expression like <td><%#
DataBinder.Eval(Container.DataItem, "au_id") %></td> can 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

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" <(E-Mail Removed)> wrote in message
news:C8C6A573-666D-456C-A976-(E-Mail Removed)...
> In repeater control, the databinding expression like <td><%#
> DataBinder.Eval(Container.DataItem, "au_id") %></td> can 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
>
>

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" <(E-Mail Removed)> wrote in message
> news:C8C6A573-666D-456C-A976-(E-Mail Removed)...
> > In repeater control, the databinding expression like <td><%#
> > DataBinder.Eval(Container.DataItem, "au_id") %></td> can 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
> >
> >
>
>
>

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" <(E-Mail Removed)> wrote in message
news6AADFB8-99C9-4BFA-8112-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:C8C6A573-666D-456C-A976-(E-Mail Removed)...
>> > In repeater control, the databinding expression like <td><%#
>> > DataBinder.Eval(Container.DataItem, "au_id") %></td> can 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
>> >
>> >
>>
>>
>>
>

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" <(E-Mail Removed)> wrote in message
news6AADFB8-99C9-4BFA-8112-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:C8C6A573-666D-456C-A976-(E-Mail Removed)...
>> > In repeater control, the databinding expression like <td><%#
>> > DataBinder.Eval(Container.DataItem, "au_id") %></td> can 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
>> >
>> >
>>
>>
>>