1

I have a GridView control which I am dynamically binding to a DataTable which is populated by a query built based on a set of selected options.

What I am trying to do is simply handle the RowDataBound event in order to format specific rows based on the value of a database field. The code in this event handler works fine. My problem is, calling this event causes the GridView to only display the first record in the DataTable, almost as if the Gridview stops after binding to the DataTable after the first row is bound.

I have attempted adding the handler dynamically, but I get the same results.

Any ideas as to why simply handling this event causes the Gridview to do this?

I know for a fact that there is sufficient data being returned (the DataTable fills with all of the records, and the GridView shows all the records fine when not touching the RowDataBound event).

I'm adding the handler immediately after generating the query, filling the DataTable, and binding the GridView: 

oDA.Fill(oDTbl)
figs_gv.DataSource = oDTbl
figs_gv.DataBind()
AddHandler figs_gv.RowDataBound, AddressOf gvRowDataBound

The handler itself: 

Protected Sub gvRowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

    If e.Row.RowType = DataControlRowType.DataRow Then
        If (e.Row.DataItem("Have") = "Yes") Then
            For i As Integer = 1 To e.Row.Cells.Count
                e.Row.Cells(i).BackColor = Drawing.ColorTranslator.FromHtml("#d3f1c7")
            Next
        End If
    End If

End Sub

I have also determined that, when handling RowDataBound, the GridView's DATABOUND event never gets fired; it seems to stop binding right after binding the first row.

Zogglet
  • 39
  • 2
  • 10
  • It shouldn't do this, the only reason is that there could be is that it is only receiving one record to bind, or that an exception is being thrown somewhere. But if the latter was the case, you would see that show up. We're going to need to see some code to help further. – Brian Mains Jun 28 '11 at 14:24
  • Can you please post code, so that we can figure out the problem. – Muhammad Akhtar Jun 28 '11 at 14:34

1 Answers1

1

I have resolved my problem.

When stepping through my code, I discovered that I had been getting an "Index out of range" error when looping through the cells of each row as such: 

For i As Integer = 1 To e.Row.Cells.Count
     e.Row.Cells(i).BackColor = Drawing.ColorTranslator.FromHtml("#d3f1c7")
Next

The exception was being thrown before it got the chance to move on to the next row. Since I wanted to skip the first cell, and apply the background color only to all subsequent cells, I had to set it to loop to one less than the count of cells, as such: 

For i As Integer = 1 To e.Row.Cells.Count - 1
     e.Row.Cells(i).BackColor = Drawing.ColorTranslator.FromHtml("#d3f1c7")
Next
Zogglet
  • 39
  • 2
  • 10