Using column description as column header instead of column name

[csutton]

I am currently using a DATAGRIDVIEW...

I have several "configuration" tables, basically tables that hold lists like customer type, activity type, etc. and each table could have additional attributes (like checkboxes) for each item in the table.

Instead of making a form for each table, I have 1 form, with a dropdown the user can click on to edit each of the table lists.

I have everything working well, except in the grid, the column headers display the column names. Is there anyway of telling the datagridview (or I also have componentOne grids) to use the column descriptions in the table instead o the column name?

I know I could set it in code, but once I have a lot of tables, I run the risk of coding errors, etc. I am NOT using stored procedures at this point.

Thanks,
Chris


~~ Chris ~~

http://www.pettechservices.com

 

[woyler]

After you set the datasource and set your bindings, you can change the column attributes...

YourGrid.Columns(0).HeaderText = "MyDescription"
YourGrid.Columns(0).Width = 100

 

[csutton]

woyker, thanks but that doesn't answer my question... I'm looking to use the COLUMN DESCRIPTION that is in the actual table definition...

thank you though.

~~ Chris ~~

http://www.pettechservices.com

 

[Kliot]

I think your problem is the Column Description is not readily available in the DataSet. You will need to run a query to get the Descriptions from the Database, then use the Descriptions retreived in your datagridview.

Assuming you are using SqlServer you should look into "fn_listextendedproperty (Transact-SQL)" to get the extended properties for the table.

 

[woyler]

Sorry, misread the question. My fingers were more anxious than my eyes.