Finding Source Server Table of a DataTable Column

Hi,

Is it possible to find out the name of the source table in a DataTable column which was filled by a DbDataAdapter

For example, suppose we have:

DbDataAdapter da = new SqlDataAdapter("SELECT [User].UserId, [User].Username, [Profile].ProfileName", con);

DataTable dt = new DataTable();

da.Fill(dt);

For each of the columns in the DataTable, is it possible to know that they came from table User or from table Profile, without using, for example, aliases

Thanks in advance!

rjperes



Answer this question

Finding Source Server Table of a DataTable Column

  • Finding Source Server Table of a DataTable Column