Search code examples
c#datatablesql-server-2012datareader

An exception of type 'System.NullReferenceException' occurred


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

Solution

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