How to set a Datagrid Column to invisible when that Column is an AutoGeneratedColumn

In the DataGrid’s declaration, add the following code in OnItemDataBound event VB.NET Dim dv As DataView = DataGrid1.DataSource ’Bind you DataGrid1 in Page_Load to DataView Dim dc As DataColumnCollection = dv.Table.Columns e.Item.Cells(dc.IndexOf(dc(‘field_name))).Visible = false C# DataView dv = DataGrid1.DataSource ;//Bind you DataGrid1 in Page_Load to DataView DataColumnCollection dc = dv.Table.Columns; e.Item.Cells[dc.IndexOf(dc[‘field_name’])].Visible = false;

Why do I get error message ‘Login failed for user DOMAIN\USERNAME’

You’ll have to create an account in SQL Server for the aspnet user. Start enterprise manager-> expand the server-> select security->Right-click in the right view and select new login, enter the DOMAIN\USERNAME and select your database as the default database of the user at the bottom of the page, Select last tab Database Access -> select your database, and add the db_datareader and db_datawriter policies to your user.