VB.NET - datagrid column invisble with autogenerate column set to false

hi all

i want to make the first column in datagrid to be set to say ProductID.

but i dont want it to be visible.

i have generated all other columns with code(autogenerate column is set to false)

how can i do this?

also i want the value of that invisible first column to be used as parameter to a function

can anyone please help me

thanks

>> but i dont want it to be visible. <<

To make the first column invisible, simply set the Visible property of the column to false:

DataGrid1.Columns[0].Visible = false;

this will not work :
 datagrid1.columns(columnnumber).visible=false

instead you have to bind the ItemDataBound event and using the DataGridItemEventArgs item to hide the dynamic column. for eg :

private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
    e.Item.Cells[3].Visible = false;
}

Kevin k,

I am very new to vb.net and need some help knowing just where to place the code you provided for hiding the column in a datagrid control.

I want to hid the ID field that I have in my datagrid, but I want it to be bound to the control so that when the user selects a row, I can take the appropriate action.

Your assistance is appreciated.

goto Datagridproperties , from events select ItemDataBound Event

by doule clicking on that event ItemDataBound event added to code behind page

here dg is datagridname

   e.Item.Cells[3].Visible = false;

here index 3 is column index, hiding Column 4 in datagrid

private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
    e.Item.Cells[3].Visible = false;
}

hope now u got how to do it

praveen

I do appreciate the response. However, I am not able to implement your description of what to do.  When I go to the code behind the form and select the datagrid, I do not have an "ItemDataBound" event available from the list of datagrid events. 

If it makes any difference, I am using VB.net 2003 and developing a Windows Form.  Would it be advantageous to upgrade to VB.net 2005?  The code almost looks as if it is something that would be used in a web form.

1) You can use your DataSet's ColumnMapping property to hide a column.      // Creating connection and command sting
 
     string conStr = @"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\northwind.mdb";
 
     string sqlStr = "SELECT * FROM Employees";
 
     // Create connection object
 
     OleDbConnection conn = new OleDbConnection(conStr);
 
     // Create data adapter object
 
     OleDbDataAdapter da = new OleDbDataAdapter(sqlStr,conn);
 

 
     // Create a dataset object and fill with data using data adapter's Fill method
 
     DataSet ds = new DataSet();
 
     da.Fill(ds, "Employees");
 

 
     // Hide the column and attach dataset's DefaultView to the datagrid control
 
     ds.Tables["Employees"].Columns["LastName"].ColumnMapping = MappingType.Hidden;
 
     dataGrid1.DataSource = ds.Tables["Employees"];

2)
You must first declare an new DataGridTableStyle object.
Then set the .Mappingname = your Datasets tablename.
Add the datagridtablestyle object to the grid by using

Datagrid.TableStyle.Add
Declare a GridColumnStyleCollection
Set GridCSCObject = DataGrid.TableStyles(index of your created
tablestyleobject).GridColumnStyle
Then you can add and remove columns by using
MyGridColumnStyleCollectionObject.
Ex: MyGridColumnStyleCollectionObject.RemoveAt(ColumnIndex) hides the column
at position ColumnIndex.

Praveen

Thanks for being patient with a beginner.

Also, thanks for being so thorough.

I'll be giving this a try later this evening.

Mr. B