Problem storing value in array from database

Question

0.00/5 (No votes)

See more:

Hi,

I want to store values in an 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:

VB

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")"<br />

Please advise.

Thanks and best regards,
Furqan

Posted 12-Apr-11 22:17pm

Furqan Sehgal

Updated 13-Apr-11 21:31pm

Dalek Dave

v3

Add a Solution

Comments

Dalek Dave 14-Apr-11 3:31am

Edited for Grammar and Readability.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pong D. Panda · Answer 1 · 2011-04-12T22:24:00

Solution 1

Hi, modify your condition to

Dim limit as integer = DsChooseSQsNow.tblChooseSQs.Rows.Count

Do While limit > 0 AND w <= limit
    vrSQsNoChosen(w) = DsChooseSQsNow.tblChooseSQs.Rows(w).Item("QNo")
    vrTotalSQsChosen = vrTotalSQsChosen + 1
    w = w + 1
Loop

Also, check the DsChooseSQsNow.tblChooseSQs.Rows if it has a value.

Good luck!

Posted 12-Apr-11 22:24pm

Pong D. Panda

Updated 13-Apr-11 21:35pm

v4

Comments

Dalek Dave 14-Apr-11 3:31am

Good Call.

shatrughnad · Answer 2 · 2011-04-12T23:49:00

decalration

dim ds as new dataset
dim da as new olebd.oldataadapter
dim sqlstring as string

sqlstring="sellect Qno from tablename"
da=new oledb.oledbdataadapter(sql,con)
con.open
da.fill(ds,"tablename")
dim temp as integer=ds.tables("tablename").rows.count;
dim arr() as integer
for i=0 to temp-1
arr(i)=ds.tables("tablename").rows(i).item("Qno")


next

shatrughna

Furqan Sehgal · Answer 3 · 2011-04-13T20:41:00

Solution 3

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

Posted 13-Apr-11 20:41pm

Furqan Sehgal

Comments

Ali Al Omairi(Abu AlHassan) 14-Apr-11 4:31am

then accept any solution.

Problem storing value in array from database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us