An exception of type 'System.NullReferenceException' occurred

Question

I am trying to load a dataTable with a dataReader but for this simple process i am getting following error:

An exception of type 'System.NullReferenceException' occurred in project.dll but was not handled in user code. Additional information: Object reference not set to an instance of an object.

My Code:

while (dtaRdr.Read())
{
   testVar = dtaRdr.GetValue(5).ToString(); //DataExists.
}
sqlTbl.Load(dtaRdr);

possible duplicate of [Null Reference Exception](http://stackoverflow.com/questions/452613/null-reference-exception) — Anarion, Oct 20 '13 at 11:08
all columns are `not-nullable`, there is one which may have `""` strings but no nulls. — Maven, Oct 20 '13 at 11:10

score 0 · Accepted Answer · answered Oct 20 '13 at 11:16

0

Have you tried sqlTbl = new DataTable(); before starting your while loop?

answered Oct 20 '13 at 11:16

Nisha

1,379
16
28

An exception of type 'System.NullReferenceException' occurred

1 Answers1