Pull column names from a DataView or DataRowCollection?
Posted on 2005-03-14
If I create a DataView or DataRowCollection from a SQL Query, is there a way to determine the column names that are contained therein? Example:
DataSet ds = new DataSet();
OdbcDataAdapter da = new OdbcDataAdapter("SELECT * FROM myTable, conn);
DataRowCollection drc = ds.Tables.Rows;
Is there a way to determine what column names were returned from the SQL Select statement?