How to get full column name (table name and column name) from query results?

[Bob Dankert]

Using the MySqlDataReader to get the results from a query, is it
possible to get the full columns names from the DataReader (table name
and column name)?  I have many queries that join tables with the same
column names, and to distinguish which column is which I would like to
know the table name as well as column name.  Currently, I get the column
name from MySqlDataReader.GetName(index), and the query is rather
general:  select * from table1 join table2 using (index);

 

Thanks,

 

Bob

 

Envision Information Technologies

Associate

bob@stripped

v. 608.256.5680

f. 608.256.3780