DataReader Table and Column names RRS feed

  • Question

  • Hi all,

    I have a little problem when I use a DataReader.

    Here is a simple SQL Query :"select t1.c1 as Column1, t2.c1 as Column2 from t1, t2"

    I want to iterate on each column and get :

    - The table name (t1, t2)
    - The column name (c1, c1)
    - The alias (Column1, Column2)

    I get only the alias for the moment...
    ==> dataColumn.ColumnName;

    dataColumn.DataTable return null...
    And I don't know how to have access to the reel column name...

    Thank you...

    Wednesday, June 7, 2006 8:08 PM

All replies