How do I make multiple DataGridTableStyles serve the same table?
(I can get multiple styles for the same datagrid, but not multple
styles for the same *table* on the same datagrid)
I want to do this because I want to have multiple views of the same
table. I have a ComboBox where I select the view I want. There are ten
views, but only three tables.
I have no problem when I have a one for one relationship
view=tablestyle as shown here;
\\
'run by a selection in a comboBox
My fill goes like this;
datagrid.fill(ds, "MyTableName")
My datagrid
datagrid.datamember = "MyTableName"
datagrid.datasource = ds
//
\\
'several table styles loaded with the form_load
My datagridtablestyle
Dim dgts As New DataGridTableStyle
dgts.MappingName = " MyTableName "
....
....
//
The problem I have is when there are more than one view on the same
table for the same datagrid.
How do I do this?
Thank you,
-Doug
I have tried . . .
I have tried using an alias in place of the actual table name. It made
sense to me, but it does not work.
\\
'run by a selection in a comboBox
My fill goes like this;
datagrid.fill(ds, "TableAliasName")
My datagrid
datagrid.datamember = "TableAliasName"
datagrid.datasource = ds
//
\\
'several table styles loaded with the form_load
My datagridtablestyle
Dim dgts As New DataGridTableStyle
dgts.MappingName = " MyTableName "
....
....
//