Tablename.Fieldname in DataSet

  • Thread starter Thread starter AJ
  • Start date Start date
A

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.
 
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.
__________________________________
 
Back
Top