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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vish - 09 Feb 2007 15:31 GMT

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

Reply to this Message

RobinS - 10 Feb 2007 00:15 GMT

If you have a dataset with two different tables in it, it doesn't matter if
they have the same column names. Access the column name through the table.

dsData.Tables("Customer").Item("CustomerID")
dsData.tables("Orders").Item("CustomerID")

pull the data out of the specified table.

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
-----------------------------------------------

> Hi all,
>
[quoted text clipped - 10 lines]
> Thanks in advance,
> Vish

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...