Hi Paul.
Thanks a lot for that..sounds like just what I want
Regards,
Gerard


>>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:
>
>

>// C#
>ds.Tables[0].Column["Name"].ColumnName = "NewName";
>
>'' VB
>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