how to change column headers in a datagrid?

Question

I connected to a database and got all the data but the headers of the columns have the namefields of the database i.e. local_name server_name....how do i modify the column headers in a datagrid so that I could rename them into Local Filename Server Filename? One more question how do I hide a column in a datagrid? Thanks a bunch! -aldrin

Adam Erstelle · Answer

An easy way (if datagrid is for display only) would be to change the column name in the select: select lfn Local FileName sfn Server Filename you will have to be carefull as the syntax may vary slightly depending on the database source. The other way is quite a bit more complicated. You would have to manually create a TableScheme for the datagrid and manually put together all the columns.