SQL Server comment can't be the field name ?

[Sébastien]

Hi,

I would like to know if there is any way to get the Description SQL
Server field in the header row of my datagrid or simply in a textbox. I did
not found any way to get the Description field (I think it is the field we
use to display something else than the field name). I would like to assign a
dataset to my datagrid and have the Description on the header row instead
the field names.

Thank you for your time and your help.
Sébastien

 

[Mary Chipman]

You can put anything you want as the column name by aliasing it in the
SELECT statement:

SELECT MyCol AS DescriptionHere FROM dbo.TableName

-- Mary
MCW Technologies
http://www.mcwtech.com

 

[William Ryan eMVP]

Sebastien:

You can apply a DataGridColumnStyle to you TableStyle and set the
..HeaderText property
http://msdn.microsoft.com/library/d...windowsformsdatagridcolumnstyleclasstopic.asp

One of my partners has a good article walking you through this
http://www.knowdotnet.com/articles/cgrid.html

HTH,

Bill