Tablename.Fieldname in DataSet

23 Jan 2006 5:01 AM

AJ

I have a sql query with a join, for example something like this

SELECT Customers.CompanyName, Customers.ContactName ,
Orders.OrderDate,
Customers.CustomerID, Orders.CustomerID
FROM Customers INNER JOIN Orders ON
Customers.CustomerID = Orders.CustomerID

when i fetch the resultset of this query in a dataset, the dataset
resolves
it to Fieldnames and ignores the "Tablename." in front and
if there is a dupicate field (like Customers.CustomerID,
Orders.CustomerID)
it just puts a suffix of 1.

Now if i wanted to get the actual name of the field as i brought it out
from
Db (Tablename.Fieldname), can that be done from the datset
in which this resultset is fetched.

23 Jan 2006 7:01 AM

William (Bill) Vaughn

Add an "AS" operator to the column selector clause.

SELECT Customers.CompanyName AS CompanyName, ...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote

"AJ" <aps_b***@hotmail.com> wrote in message
news:1137989396.114927.152400@o13g2000cwo.googlegroups.com...
>I have a sql query with a join, for example something like this
>
> SELECT Customers.CompanyName, Customers.ContactName ,
> Orders.OrderDate,
> Customers.CustomerID, Orders.CustomerID
> FROM Customers INNER JOIN Orders ON
> Customers.CustomerID = Orders.CustomerID
>
> when i fetch the resultset of this query in a dataset, the dataset
> resolves
> it to Fieldnames and ignores the "Tablename." in front and
> if there is a dupicate field (like Customers.CustomerID,
> Orders.CustomerID)
> it just puts a suffix of 1.
>
> Now if i wanted to get the actual name of the field as i brought it out
> from
> Db (Tablename.Fieldname), can that be done from the datset
> in which this resultset is fetched.
>