Rename database fields in DataSet XML...

[steverbs]

Hi all.

So, is it possible to rename the fields in XML created from a DataSet. For example, I have a Table called Company and its fields are named using the convention F001, F002, F999, etc (Don't ask why, as it was outside of my control). I would like to give these fields more meaningful names in the XML, so that F001, would become CompanyRef, and so on.

Any ideas?

Stephen.

 

[ThatRickGuy]

you could try this:

DataTable.Columns.Item("OldName").ColumnName = "NewName"

Untested though.

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[steverbs]

Looks like it will do the trick.

Cheers.

Stephen.