Same column names being renamed

[Marina]

Hi, let's say that the result of a query that has some joins, brings back
some columns that have the same name. .Net starts numbering them. So they
became "someCol", "someCol1", "someCol2", etc, even though in reality, they
were all called "someCol".

Is there any way to tell what the original column name was once the data is
in a DataTable?

Renaming all the columns in the query is NOT an option.

 

[Patrice Scribe]

I believe this could be done using the TableMappings property - never used
as I always use distinct names ;-)

Try
http://msdn.microsoft.com/library/d...cpconsettingupdatatabledatacolumnmappings.asp

Patrice

 

[Marina]

I've looked at that, it is empty after the Fill.

I believe this could be done using the TableMappings property - never used
as I always use distinct names ;-)

Try
http://msdn.microsoft.com/library/d...cpconsettingupdatatabledatacolumnmappings.asp

Patrice

 

[Patrice Scribe]

Can you perform updates on this datatable ? (if yes it's likely kept
somewhere).

--