Tablename.Fieldname in DataSet



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

SELECT Customers.CompanyName, Customers.ContactName ,
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
it to Fieldnames and ignores the "Tablename." in front and
if there is a dupicate field (like Customers.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
Db (Tablename.Fieldname), can that be done from the datset
in which this resultset is fetched.

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
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question