Generate Columns Dynamically

[andy]

I have a datagrid that will display data from the database. Each user will
specify list of columns he wants to see and in the order he wants to see.
User A can specify that he wants to see only columns A,B,C and in the order
A,B,C and the user might say I want to see only only columns A,G,H but the
order should be
G,A,H. It's possible that column G might have a hyperlink.

How can I do it in Dot.Net? Any help will be appreciated.

Tahnks,
Andy

[RickHodder]

Hi Andy,

To dynamically add columns to a grid, you create DataGridColumnS tyle objects
and add them to the GridColumnStyle s collection of an object called a
TableStyle.

1. Drop a grid on a form
2. Add a TableStyle to the grid. For sake of example, lets say you name it
oTableStyle
3. When you know the name of the datatable you are binding the grid to, you
set the MappingName of oTableStyle to the name of the datatable
4. When you are adding the columns, you create a DataGridTextBox Column or
DataGridBoolCol umn, set the MappingName to the name of the field in the
DataTable.
5. Add the columnstyle object to oTableStyle.Gri dColumnStyles collection.

oTableStyle.Map pingName="MyTab le"

Dim oColumn As DataGridTextBox Column

oColumn = New DataGridTextBox Column()
oColumn.Mapping Name = "Age"

oTableStyle.Gri dColumnStyles.A dd(oColumn)

oColumn = New DataGridTextBox Column()
oColumn.Mapping Name = "ZipCode"

oTableStyle.Gri dColumnStyles.A dd(oColumn)