How to access columns having same name in a datarow More options

9 Feb 2007 2:57 PM

vish

Hi all,

I know this might look strange at first look, but i am looping thru a
dataset created using two 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

10 Feb 2007 8:43 AM

MrSmersh

TableName.ColumnName?
Or when specify the query to fill up the dataset to specify aliases for the
columns?

Show quote

"vish" wrote:

> Hi all,
>
> I know this might look strange at first look, but i am looping thru a
> dataset created using two 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
>
>

11 Feb 2007 4:19 PM

Garik

How your datarow contains two duplicate columns?

--
Regards,
Garik Melkonyan
MCP, MCAD, MCSD .NET

Show quote

"MrSmersh" wrote:

> TableName.ColumnName?
> Or when specify the query to fill up the dataset to specify aliases for the
> columns?
>
>
> "vish" wrote:
>
> > Hi all,
> >
> > I know this might look strange at first look, but i am looping thru a
> > dataset created using two 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
> >
> >

11 Feb 2007 7:37 PM

RobinS

Several people have responded to this posting, and I posted a comprehensive
reply to this in microsoft.public.dotnet.languages.vb.

The OP has multi-posted it in multiple groups, but it has definitely been
answered.

Just FYI.
Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
---------------------------------------------------------
Show quote

"Garik" <garik_ma@do not spam.yahoo.com> wrote in message
news:153967AA-11E3-457D-A517-FD5E1CA7679B@microsoft.com...
> How your datarow contains two duplicate columns?
>
> --
> Regards,
> Garik Melkonyan
> MCP, MCAD, MCSD .NET
>
>
> "MrSmersh" wrote:
>
>> TableName.ColumnName?
>> Or when specify the query to fill up the dataset to specify aliases for
>> the
>> columns?
>>
>>
>> "vish" wrote:
>>
>> > Hi all,
>> >
>> > I know this might look strange at first look, but i am looping thru a
>> > dataset created using two 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
>> >
>> >