Hiding a column in Datagrid

Hi, I am using the following technique to hide a column in a datagrid. It works great, however, I am not able to get the item value anymore by calling

DataGrid1.Item(DataGrid1.CurrentRowIndex(), 0)

Is there a way to hide a column using this method and still get the value from the datagrid?
I do not want to use a Datagrid Table Style

VB Code:

Dim cn As New SqlConnection("Data Source=MyServer;User Id=MyUser;Password=MyPassword;Initial Catalog=Northwind")
cn.Open()
Dim da As New SqlDataAdapter("Select * From Products", cn)
Dim ds As New DataSet()
da.FillSchema(ds, SchemaType.Source, "Products")
da.Fill(ds, "Products")
' Next line hides column.
ds.Tables("Products").Columns("QuantityPerUnit").ColumnMapping = MappingType.Hidden
DataGrid1.SetDataBinding(ds, "Products")

Thanks in advance
Diego

You can also use your DataSet's ColumnMapping property to hide a column.


Imports System.Data.OleDb
'
' Retrieve "Customer" data from database.
'
Dim strConnection = "Provider=..."
Dim strSQL = "SELECT * FROM Customers"
Dim conn As New OleDbConnection(strConnection)
Dim DA As New OleDbDataAdapter(strSQL,conn)
Dim DS As New DataSet()
DA.Fill(DS, "Customers")
'
' Hide the column.
'
DS.Tables("Customers").Columns("LastName").ColumnMapping = MappingType.Hidden
DataGrid.DataSource = DS.Tables("Customers")

Am I missing something? That is exactly what I did and explained above.

Please elaborate.

The problem is not how to hide the column but how to access the information from the hidden column on the datagrid

You could set the width to 0.

Thank you but that will involve defining a DataGridTableStyle and that is exactly what I want to aviod (see code below).

Alternatively, I can get the value from the Dataset by using

DS.Tables("tblSQL").Rows(grdObs.CurrentRowIndex())("bObsNumber")

but if the user changes the sorting order on the datagrid this method does not work.

VB Code:

Dim aGridTableStyle As New DataGridTableStyle
        aGridTableStyle.MappingName = "tblSQL"
 
        Dim aCol1 As New DataGridTextBoxColumn
        Dim aCol2 As New DataGridTextBoxColumn
        Dim aCol3 As New DataGridTextBoxColumn
        Dim aCol4 As New DataGridTextBoxColumn
        Dim aCol5 As New DataGridTextBoxColumn
 
        With aCol1
            .MappingName = "bObsNumber"
            .Width = 0
        End With
        With aCol2
            .MappingName = "SupNumber"
            .Width = 0
        End With
        With aCol3
            .MappingName = "Invoice"
        End With
        With aCol4
            .MappingName = "Date"
        End With
        With aCol5
            .MappingName = "Time"
        End With
 
 
        With aGridTableStyle.GridColumnStyles
            .Add(aCol3)
            .Add(aCol4)
            .Add(aCol5)
            .Add(aCol1)
            .Add(aCol2)
        End With
        '
        ' Add the GridColumnStyles to the aGridTableStyle.
        '
        grdObs.TableStyles.Add(aGridTableStyle)

Anybody??