Hi all,

I know this might look strange at first look, but i am looping thru a
dataset created using to different tables
from database.These two tables have some fields with the same names.

Now i want to use those columns from datarow. How can i get exactly
the same column i want not the othere duplicate one residing in the
datarow?

If you understand it pls reply me.

Thanks in advance,
Vish

Vish,

Why not use an alias in the Select statement that retrieves the data from
the database?

Kerry Moorman


"vish" wrote:

> Hi all,
>
> I know this might look strange at first look, but i am looping thru a
> dataset created using to different tables
> from database.These two tables have some fields with the same names.
>
> Now i want to use those columns from datarow. How can i get exactly
> the same column i want not the othere duplicate one residing in the
> datarow?
>
> If you understand it pls reply me.
>
> Thanks in advance,
> Vish
>
>

Thanks Kerry,

But actually the requirement is such that i can not use the alias in
the select statement. As i want to use both columns ( that are with
same name ) for different purpose in a code block.

Is it still possible in the programmers world?

Thanks very much for your reply.

Vish

Yes, I posted the answer to this in the other newsgroup where you posted
this question.

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-----------------------------------------------
"vish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks Kerry,
>
> But actually the requirement is such that i can not use the alias in
> the select statement. As i want to use both columns ( that are with
> same name ) for different purpose in a code block.
>
> Is it still possible in the programmers world?
>
> Thanks very much for your reply.
>
> Vish
>

i wouldn't listen to this dyke she doesn't know what she is talking
about

And folks should listen to you because..... your a low-life malcontent whose
only goal in life is to rant about how YOU were taken advantage of because
you couldn't follow company policy and keep yer code tight and fast? Give it
up Aaron, you stuck your own foot in your mouth when you signed your name to
your first punjab_tom post. Can't you just keep ONE of your personalities
in control of your miserable life?

"punjab_tom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>i wouldn't listen to this dyke she doesn't know what she is talking
> about
>

LOL. You're still trying to figure out if I'm female or male! What a
goober! You just absolutely crack me up.

Robin S.
King of Russia
------------------------------------------------
"punjab_tom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>i wouldn't listen to this dyke she doesn't know what she is talking
> about
>

Punjab,

>i wouldn't listen to this dyke she doesn't know what she is talking
> about
>

I don't know it, but what if RobinS is a dyke.

Maybe in your country it is normal to judge people about their sexual
interest, in my country it is the same as doing that because sombodies
politic, religion or race and is seen as a crime. Therefore please we are a
international newsgroup where there was alomost never any discussion about
religion or politic, we are just busy with our job.

And whatever the sexual interest of RobinS is, he/she does a good job here
to help everybody.

Cor

....

Here, here, Cor. Could not have said it better myself. Robin has helped a
lot of folks here and I do appreciate that, cause I'm one of them. And not
just because he's appreciated my posts to pujab_aaron. You yourself have
been extremely active in helping folks here and I'm learning a lot about the
language from articles on your website.

Thanks,
Bruce

"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Punjab,
>
>>i wouldn't listen to this dyke she doesn't know what she is talking
>> about
>>
>
> I don't know it, but what if RobinS is a dyke.
>
> Maybe in your country it is normal to judge people about their sexual
> interest, in my country it is the same as doing that because sombodies
> politic, religion or race and is seen as a crime. Therefore please we are
> a international newsgroup where there was alomost never any discussion
> about religion or politic, we are just busy with our job.
>
> And whatever the sexual interest of RobinS is, he/she does a good job here
> to help everybody.
>
> Cor
>
> ...
>

I am still looking for an answer to this question, as I do not know what
other newsgroup the question was asked & answered in. Can someone just
answer the question, please?

"vish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all,
>
> I know this might look strange at first look, but i am looping thru a
> dataset created using to different tables
> from database.These two tables have some fields with the same names.
>
> Now i want to use those columns from datarow. How can i get exactly
> the same column i want not the othere duplicate one residing in the
> datarow?
>
> If you understand it pls reply me.
>
> Thanks in advance,
> Vish
>