DataReader.GetSchemaTable Method

JC Voon

Guest

Posts: n/a

14th Jan 2005

Hi:

The following query

SELECT Inv.*, Cust.CompanyName AS Cust_Name FROM Inv JOIN
Customers ON Customers.CustomerID=Inv.Cust_No

When execute the DataReader.GetSchemaTable method,
it will return all fields i specified in the query (inv.*, Cust_Name)
plus the field in the JOIN criteria, "CustomerID".

Is it normal ?

Thanks
JCVoon

« Enumerating All Printers, Including Network Printers | MemoryStream.GetBuffer returns 1024 bytes »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Static Method returns DataReader	Varangian	Microsoft ASP .NET	4	8th Jan 2007 03:19 PM
DataReader's GetSchemaTable Method not fully working	=?Utf-8?B?SmFmZmE=?=	Microsoft Dot NET Framework	2	17th Apr 2006 03:33 PM
Encoding about GetString method of DataReader	Zhou Peng	Microsoft ADO .NET	1	2nd Apr 2006 10:55 AM
Is there a .Net CF equivalent of the DataReader.HasRows method?	=?Utf-8?B?Y2hhcmxpZXdlc3Q=?=	Microsoft C# .NET	1	31st May 2005 11:41 AM
Return DataReader From Method; Good or Bad Practice?	Jeff S	Microsoft ASP .NET	7	23rd Mar 2004 09:38 AM