>Hi.
>Anybody know of a way to programtically change a Field Name of a daaset
>e.g. I have a dataset (that comes from a Table) with Field names of :
>CUS_AcNum
>cUS_Nam
>CUS_TEL
>
>and I want to change the Dataset field names to:
>Account
>Name
>Tel
>
>and then use these renames in all my data handling
>
Code like this should work:
ds.Tables[0].Column["Name"].ColumnName = "NewName";
ds.Tables(0).Column("Name").ColumnName = "NewName";
I did a bit of more searching and found this article, which suggests copying the resulting dataset because of an error with case sensitivity:
http://support.microsoft.com/kb/815545