datagrid problem with dynamically bound columns

i have a datagrid in my web forms, where i'm binding columns at run time... however, for these bound columns, there are some problems in some of the datagrid event handlers... * although the edit command recognized the columns in the grid (i am even able to make some columns read-only here...), the update command does not recognize the existence of the bound columns and keeps saying that 'specified parameter was invalid: index out of range' when i tried to access e.Item.Cells[x] where x is the column number... i tried to use e.Item.Cells[x].Controls[0] but Controls[0] does not seem to be working anyways with bound columns... Is there a way to fix this OR to get access to the columns' information in the Update Command? * when i am binding the columns at run time, i set the sortExpression of the bound columns to the header text of the column... and when I try to access this in the Sort Command event of the DataGrid and try to Re-Bind according to SortExpression, I either get all columns generated 2 times(when I re-bind the DataGrid at both the Sort Command as well as Page_load) or do not get the columns to be bound at all (when I try to Re-Bind either ONLY at the Sort Command event handler OR ONLY at the Page_Load)... please advise on both issues if you have any ideas... thanks a lot - arvind

1) Here is an extract of working code on how I perform the update. If your index is out of range, it means you need to manipulate your x variable. The number is probably too large, and you are trying to use a column that doesn exist. Remember, the column count starts at 0 not at 1. Dim intDISK_DRIVE_ID As Integer = dgDiskDrive.DataKeys.Item(e.Item.ItemIndex) Dim txtDISK_DRIVE_TYPE As TextBox = e.Item.Cells(2).Controls(0) Dim txtDISK_DRIVE_BURNER As TextBox = e.Item.Cells(3).Controls(0) Dim txtDISK_DRIVE_MODEL As TextBox = e.Item.Cells(4).Controls(0) Dim txtDISK_DRIVE_SPEED As TextBox = e.Item.Cells(5).Controls(0) Dim strReplaceDISK_DRIVE_TYPE As String = (Replace(txtDISK_DRIVE_TYPE.Text, "'", "''")) Dim strReplaceDISK_DRIVE_BURNER As String = (Replace(txtDISK_DRIVE_BURNER.Text, "'", "''")) Dim strReplaceDISK_DRIVE_MODEL As String = (Replace(txtDISK_DRIVE_MODEL.Text, "'", "''")) Dim strReplaceDISK_DRIVE_SPEED As String = (Replace(txtDISK_DRIVE_SPEED.Text, "'", "''")) --------------------------------------------------------------------------------------------- 2) I'm not sure what your problem is on the sort command. Here is the sort command that I use for your reference. I fill a datagrid and setup a dataview, but don't fill it: myDataAdapter.Fill(dsTemp, "Results") dvServers = New DataView(dsTemp.Tables(0)) dgServers.DataSource = dsTemp dgServers.DataBind() myConn.Close() Then I pull the sortexpression from the dataview, and use it to rebind the datagrid: Private Sub dgServers_SortCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles dgServers.SortCommand dvServers.Sort = e.SortExpression Session("SortExpression") = e.SortExpression dgServers.DataSource = dvServers dgServers.DataBind() End Sub Hope some of this helps. =)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

wardenofdeath21y ago
1) Here is an extract of working code on how I perform the update. If your index is out of range, it means you need to manipulate your x variable. The number is probably too large, and you are trying to use a column that doesn exist. Remember, the column count starts at 0 not at 1. Dim intDISK_DRIVE_ID As Integer = dgDiskDrive.DataKeys.Item(e.Item.ItemIndex) Dim txtDISK_DRIVE_TYPE As TextBox = e.Item.Cells(2).Controls(0) Dim txtDISK_DRIVE_BURNER As TextBox = e.Item.Cells(3).Controls(0) Dim txtDISK_DRIVE_MODEL As TextBox = e.Item.Cells(4).Controls(0) Dim txtDISK_DRIVE_SPEED As TextBox = e.Item.Cells(5).Controls(0) Dim strReplaceDISK_DRIVE_TYPE As String = (Replace(txtDISK_DRIVE_TYPE.Text, "'", "''")) Dim strReplaceDISK_DRIVE_BURNER As String = (Replace(txtDISK_DRIVE_BURNER.Text, "'", "''")) Dim strReplaceDISK_DRIVE_MODEL As String = (Replace(txtDISK_DRIVE_MODEL.Text, "'", "''")) Dim strReplaceDISK_DRIVE_SPEED As String = (Replace(txtDISK_DRIVE_SPEED.Text, "'", "''")) --------------------------------------------------------------------------------------------- 2) I'm not sure what your problem is on the sort command. Here is the sort command that I use for your reference. I fill a datagrid and setup a dataview, but don't fill it: myDataAdapter.Fill(dsTemp, "Results") dvServers = New DataView(dsTemp.Tables(0)) dgServers.DataSource = dsTemp dgServers.DataBind() myConn.Close() Then I pull the sortexpression from the dataview, and use it to rebind the datagrid: Private Sub dgServers_SortCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles dgServers.SortCommand dvServers.Sort = e.SortExpression Session("SortExpression") = e.SortExpression dgServers.DataSource = dvServers dgServers.DataBind() End Sub Hope some of this helps. =)