I turned on the autogenerate dtagrid columns otherwise I need to create 3 different datagrid froms my sql statements. I need to hide the second column in the datagrid which is the ID column of the table. If I put in my statement this.
myDataGrid.Columns(1).Visi
It gives me the follwoing error.
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
But if I take out it works fine, how can I hide the first autogenerated column of my statement.
Private Sub FillDatagrid()
Dim UicId As String = ddlUic.SelectedValue
sql = "Select af.intAssignedId as ID, uf.strTaskName as TaskName, uf.strProponent as Proponent, uf.strApprovalLevel as Approval, uf.strPriority as Priority, " _
& "Convert(varchar(12), af.dtAssigned, 106) as Date_Assigned, Convert(varchar(12), DateAdd(dd, uf.strSusDays, af.dtAssigned), 106) as Suspense_Date, uf.strSMEContact as SME_Contact " _
& "from tblUnitFilter as uf INNER JOIN tblAssignUnitFilters as af on af.intFilterID = uf.intFilterID where af.intUnitMobId = " & UicId & " AND dtRemoved IS NULL AND " _
& "dtCompleted IS NULL"
myDataTable = New DataTable
myDataTable = getData(sql)
myDataGrid.DataSource = myDataTable
myDataGrid.DataBind()
myDataGrid.Columns(1).Visi
End Sub
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
That's invorrect, after the databound method the grid is bound. The columns don't exists you did not make them thus you cannot make them invisible like that. However in the RowDataBound event you can make all the cells invisible for that specific column and thus making the column invisible:
In the row data bound event do this:
e.Row.Cells(1).Visible = False
Since all the cells are invisible so is the column
Choice between ItemDataBound and RowDataBound depends on whether you are using DataGrid (version 1.1) or GridView (version 2.0 and above).
RowDataBound event of later versions is equivalent ItemDataBound event of 1.1, and works exactly the same.
From the post it looks like we are using DataGrid here...
Same concept applies, columns are auto changerated so he can use ItemDataBound event to set the cells he wants to be invisible, he has to do it for all cells in that column:
e.Item.Cells[1].Visible = false;
However, after the Grid is databound, be it a DataGrid or GridView or any other bound control(that I know of) the data is available. The DataBind method does not execute asynchronously out of the box.
All,
Well I actually learned a lot from both in what I can and can't do and where to put events. Here is the final solution. You both had valid points and each had partial to teh whole solution. As this
myDatgrid.columns(1).visib
would throw and error the solution did not and hide the cell while still keeping my functionality.
Private Sub myDataGrid_ItemDataBound(B
e.Item.Cells(1).Visible = False
End Sub
Business Accounts
Answer for Membership
by: expertsoulPosted on 2009-11-02 at 13:33:50ID: 25723992
You cannot hide column while calling databind() as columns are not present at that moment.
You need to call this at ItemDataBound event of the grid.