Displaying only selected columns in a data grid?

[What-a-Tool]

Have an Access table loaded into a DataTable that was created at run time,
and am displaying these contents in a data grid.
Me.dgGames.Data Source = Me.DsGameInfo.T ables("Games")

I would like to display only a selected few of the columns, rather than the
whole table.
Is this possible?
Thanks - Sean

[Lucas Tam]

"What-a-Tool" <Fr************ ***********@cox .net> wrote in
news:mSMcb.1542 8$0Z5.1761@lake read03:

Have an Access table loaded into a DataTable that was created at run
time, and am displaying these contents in a data grid.
Me.dgGames.Data Source = Me.DsGameInfo.T ables("Games")

I would like to display only a selected few of the columns, rather
than the whole table.
Is this possible?

http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q708q
--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Cor]

Hi What-a-tool,

Have an Access table loaded into a DataTable that was created at run time,
and am displaying these contents in a data grid.
Me.dgGames.Dat aSource = Me.DsGameInfo.T ables("Games") I would like to display only a selected few of the columns, rather than the
whole table.

Take a look for "datarow", I think that will explain it for you.
(It is one or more rows from your table that has columns).

I hope this brings you on the route for the solution.
Cor

[Dmitriy Lapshin [C# / .NET MVP]]

Hi,

If we are speaking of the System.Windows. Forms.DataGrid class, this is
definitely possible.
In the Windows Forms designer, click on the grid and choose the TableStyles
property in the Properties window. Then click on the small button with
ellipsis (...) to the right of the property name to bring up the Table
Styles Collection Editor. Add a new item and set its MappingName to "Games".
Then, go to the property grid for the newly created table style and choose
the GridColumnStyle s property. Click on the similar button with ellipsis
(...) to bring up the Grid Column Styles Collection Editor. Add a number of
columns you want and specify header name and mapping name for each column.
Mapping names for the columns should correspond to the names of data columns
in the data table.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"What-a-Tool" <Fr************ ***********@cox .net> wrote in message
news:mSMcb.1542 8$0Z5.1761@lake read03...

Have an Access table loaded into a DataTable that was created at run time,
and am displaying these contents in a data grid.
Me.dgGames.Data Source = Me.DsGameInfo.T ables("Games")

I would like to display only a selected few of the columns, rather than the whole table.
Is this possible?
Thanks - Sean

[Armin Zingler]

"What-a-Tool" <Fr************ ***********@cox .net> schrieb

Have an Access table loaded into a DataTable that was created at run
time, and am displaying these contents in a data grid.
Me.dgGames.Data Source = Me.DsGameInfo.T ables("Games")

I would like to display only a selected few of the columns, rather
than the whole table.
Is this possible?
Thanks - Sean

This is a question about the Datagrid and not specific to the VB.NET
language. Please turn to one of the
microsoft.publi c.dotnet.framew ork.windowsform s groups.
--
Armin

[What-a-Tool]

Thanks again -guys. Your the best. I'd be one frustrated aspiring programmer
if it wasn't for this group (still am frustrated most of the time - but not
quite as frustrated as I would be!).
Thanks-Sean

"What-a-Tool" <Fr************ ***********@cox .net> wrote in message
news:mSMcb.1542 8$0Z5.1761@lake read03...

Have an Access table loaded into a DataTable that was created at run time,
and am displaying these contents in a data grid.
Me.dgGames.Data Source = Me.DsGameInfo.T ables("Games")

I would like to display only a selected few of the columns, rather than the whole table.
Is this possible?
Thanks - Sean

[Ken Powers]

Or try this

Dim dgtsAdj As DataGridTableSt yle

Private Sub SetDataGrid()
Try
Dim sFilter As String
sFilter = "Code = '" & tbCode.Text.Tri m & "'"
dvViewAdj.RowFi lter = sFilter

dgtsAdj = New DataGridTableSt yle
dgtsAdj.Mapping Name = "Adjustment s"

With dgActiveAdj
.DataSource = dvViewAdj
.AllowSorting = True
End With

dgActiveAdj.Tab leStyles.Clear( )
dgActiveAdj.Tab leStyles.Add(dg tsAdj)
dgActiveAdj.Tab leStyles(0).Rea dOnly = True

With dgtsAdj
.GridColumnStyl es(0).Width = 0 'MAKES THEM HIDDEN
.GridColumnStyl es(1).Width = 0
.GridColumnStyl es(2).Width = 150
.GridColumnStyl es(2).HeaderTex t = "Adjustment Description"
.GridColumnStyl es(3).Width = 150
.GridColumnStyl es(3).HeaderTex t = "Adjustment Amount"
.GridColumnStyl es(4).Width = 85
.GridColumnStyl es(4).HeaderTex t = "Begin Date"
.GridColumnStyl es(5).Width = 85
.GridColumnStyl es(5).HeaderTex t = "End Date"
End With
Catch ex As Exception
MessageBox.Show (ex.Source.ToSt ring & " - " & ex.Message,
Application.Pro ductName, _
MessageBoxButto ns.OK, MessageBoxIcon. Error)
End Try

End Sub

[What-a-Tool]

Ended up using the following to hide unwanted columns and set the width of a
column. Now I want to re-arrange the displayed order of the columns, so I
tried creating another table style and adding the columns in the order I
wanted them, but for some reason I end up with all table style settings
gone. Anyone see what I'm doing wrong?
Thanks - Sean

'Hide un-wanted column
Me.DsGameInfo.T ables("Games"). Columns("Home") .ColumnMapping =
MappingType.Hid den

'Set column widths

Dim dgts As New DataGridTableSt yle()

dgts.MappingNam e = "Games"

Me.dgGames.Tabl eStyles.Add(dgt s)

dgts.GridColumn Styles("Game"). Width = 150

'Re-arrange colums

Dim dgts2 As New DataGridTableSt yle()

dgts2.GridColum nStyles.Add(dgt s.GridColumnSty les("Game"))

dgts2.GridColum nStyles.Add(dgt s.GridColumnSty les("Home Score"))

dgts2.GridColum nStyles.Add(dgt s.GridColumnSty les("Guest Score"))

dgts2.GridColum nStyles.Add(dgt s.GridColumnSty les("Week / Year"))

Me.dgGames.Tabl eStyles.Remove( dgts)

Me.dgGames.Tabl eStyles.Add(dgt s2)

Me.dgGames.Refr esh()

"What-a-Tool" <Fr************ ***********@cox .net> wrote in message
news:mSMcb.1542 8$0Z5.1761@lake read03...

Have an Access table loaded into a DataTable that was created at run time,
and am displaying these contents in a data grid.
Me.dgGames.Data Source = Me.DsGameInfo.T ables("Games")

I would like to display only a selected few of the columns, rather than the whole table.
Is this possible?
Thanks - Sean