Object reference not set to an instance of an object

Question

0.00/5 (No votes)

See more:

Dear Sir,

Object reference not set to an instance of an object in
this code

Dim dtSchema As DataTable = dr.GetSchemaTable()

Posted 9-Oct-11 21:12pm

DINESH K MAURYA

Updated 9-Oct-11 21:16pm

Richard MacCutchan

v2

Add a Solution

Comments

P.Salini 10-Oct-11 3:24am

don't re-post your question

koolprasad2003 10-Oct-11 8:42am

your datareader must be NULL

6 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)

Richard MacCutchan · Answer 1 · 2011-10-09T21:17:00

Solution 1

Your variable dr needs to point to an object.

Posted 9-Oct-11 21:17pm

Richard MacCutchan

P.Salini · Answer 2 · 2011-10-09T21:19:00

Solution 3

Object reference not set to an instance of an object
this means
dr in your code is null
so check the query is retrieving any results or not

Posted 9-Oct-11 21:19pm

P.Salini

hitech_s · Answer 3 · 2011-10-10T02:36:00

Solution 4

dr.GetSchemaTable()

returns null value .
it returns nothing thatswhy error came

Posted 10-Oct-11 2:36am

hitech_s

dreamz9 · Answer 4 · 2011-10-10T02:38:00

Solution 5

have you declared dr ?
You dont have declared dr thats y the error comes..

Posted 10-Oct-11 2:38am

dreamz9

Ram Balak Sharma · Answer 5 · 2011-10-10T03:02:00

A data table object is a reference type that has
to have a value. You don’t have to use the “new” keyword, but by
default the value is Nothing/null. You would have to at least
initialize to dtSchema = new DataTable, before
it will compile in C#, or run without exception in VB.Net

OriginalGriff · Answer 6 · 2011-10-09T21:19:00

Solution 2

From that code fragment, it can only be dr that is not valid - you need to look at your previous code and work out why it has a value of nothing

Try putting a breakpoint at the start of the function, and single stepping through, if you can't spot it from the code.