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.