Problem storing value in array

Question

I want to store value in array, from my database. I am using following code but it return error: "Object reference not set to an instance of an object."

Code is:

Dim w as integer=0

Do While DsChooseSQsNow.tblChooseSQs.Rows.Count > w
      vrSQsNoChosen(w) = DsChooseSQsNow.tblChooseSQs.Rows(w).Item("QNo")
      vrTotalSQsChosen = vrTotalSQsChosen + 1
      w = w + 1
Loop

Error comes on "vrSQsNoChosen(w) = DsChooseSQsNow.tblChooseSQs.Rows(w).Item("QNo")"

Nighil · Accepted Answer · 2011-04-13 08:38:28Z

1

try to print the value DsChooseSQsNow.tblChooseSQs.Rows(w).Item("QNo")

or debug the code

"Object reference not set to an instance of an object." means Item("QNo") may be null

answered Apr 13, 2011 at 8:38

Nighil

4,1277 gold badges34 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Furqan Sehgal Over a year ago

I printed DsChooseSQsNow.tblChooseSQs.Rows(w).Item("QNo") and value is not Null

Grzegorz Gierlik · Accepted Answer · 2011-04-13 08:29:11Z

0

There are many reasons why this code fails. I would start checking from:

Size (and boundings) of vrSQsNoChosen array.
w value when error occurs (is valid index for vrSQsNoChosen array and Rows collection?).
Item("QNo") value when error occurs (maybe is null?).

Also -- VB.NET implements += operator so you can write:

  w += 1

instead of:

 w = w + 1

answered Apr 13, 2011 at 8:29

Grzegorz Gierlik

11.3k4 gold badges49 silver badges57 bronze badges

1 Comment

Furqan Sehgal Over a year ago

The problem was with the bound of array. Solved ! Thanks a lot.

Collectives™ on Stack Overflow

Problem storing value in array

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related