NullReferenceException fix?

Question

Im new with vb.net and I know i still got a lot to learn. Research and lots of sample codes help me improve my programming skill but then theres still alot of things to be confused about.

Here's an error I just encountered.

Dim drv As DataRowView
    If e.RowIndex >= 0 Then
        If e.RowIndex <= ds.Tables("entrancequestion").Rows.Count - 1 ***Then***
                                                                          'Object reference not set to an instance of an object.
            drv = ds.Tables("entrancequestion").DefaultView.Item(e.RowIndex)
            Dim c As Color
            If drv.Item("TimesAnswered").Value <= (Convert.ToDouble(lblappcount.Text) * 0.2) Then

                c = Color.Yellow
            ElseIf drv.Item("TimesAnswered").Value >= (Convert.ToDouble(lblappcount.Text) * 0.8) Then
                c = Color.Red
            Else
                c = Color.Black
            End If
            e.CellStyle.ForeColor = c
        End If
    End If

this was written under the DataGridView.Cellformatting event. basicly i just wanted to changethe rows text color on the datagridview along those conditions.

row forecolor changes to yellow if "TimesAnswered" is less than or equal to 20% of the value on lblappcount.text.
row forecolor changes to redif "TimesAnswered" is less than or equal to 80% value on lblappcount.text.
and row for color if conditions above was not satisfied.

any suggestions is greatly appreciated.

Use the debugger to figure out what is null.. Also, learn about the `And` operator. — SLaks, Mar 14 '14 at 18:52
possible duplicate of [What is a NullReferenceException and how do I fix it?](http://stackoverflow.com/questions/4660142/what-is-a-nullreferenceexception-and-how-do-i-fix-it) — Ňɏssa Pøngjǣrdenlarp, Mar 14 '14 at 20:31

Crono · Answer 1 · 2014-03-14T19:35:58.677

2

Either ds is null or it does not contains a table named entrancequestion.

Use a little Assert magic here:

Debug.Assert(ds IsNot Nothing)

Dim tblEntranceQuestion As DataTable = ds.Tables("entrancequestion")

Debug.Assert(tblEntranceQuestion IsNot Nothing)

If e.RowIndex <= tblEntranceQuestion.Rows.Count - 1
    (...)

edited Mar 14 '14 at 19:35

answered Mar 14 '14 at 19:20

Crono

10,211
6
43
75

score 0 · Answer 2 · answered Mar 15 '14 at 11:00

Got it. Here's what I did. under the Cell formatting event I wrote this one.

  For i As Integer = 0 To EntranceQuestionDataGridView.Rows.Count - 1
        If EntranceQuestionDataGridView.Rows(i).Cells(10).Value <= (Convert.ToDouble(lblappcount.Text) * 0.2) And EntranceQuestionDataGridView.Rows(i).Cells(10).Value > 0 Then
            EntranceQuestionDataGridView.Rows(i).DefaultCellStyle.BackColor = Color.Red
        ElseIf EntranceQuestionDataGridView.Rows(i).Cells(10).Value >= (Convert.ToDouble(lblappcount.Text) * 0.8) Then
            EntranceQuestionDataGridView.Rows(i).DefaultCellStyle.BackColor = Color.Yellow
        Else
            EntranceQuestionDataGridView.Rows(i).DefaultCellStyle.BackColor = Color.White
        End If
    Next

Thanks anyways guys. I learned lots of stuff :)

Ooops. what I meant was I was able to get the desired output that I wanted. NOT that I was able to solve the NullReferenceException thingy — earl chester siaotong, Mar 15 '14 at 11:03

NullReferenceException fix?

2 Answers2