Hi All,
Till recently we were using the following code to retreive schema information of columns of tables
Dim schemaTable = connection.GetOleDbSchemaTable( _ System.Data.OleDb.OleDbSchemaGuid.Columns, _ New Object() {Nothing, Nothing, tableName, Nothing})
Now instead of getting the name of table (which i was using as param for filtering) i'm going to receive a sql-query.
Now my question is if I were to get a query like the following :
SELECT [EmployeeID], [Title] + ' ' + [LastName] + ' ' + [FirstName] AS FullName, [BirthDate], [Address], [City] + ', ' + [Region] + ', ' + [Country] + ' - ' + [PostalCode] AS FullAddress FROM [dbo].[Employees]
then how can I retrieve the schema information of only the columns present in the query.
(PS.. Its possible that i might get a query with multiple tables with joints)