I got an unhandled exception of type 'System.OutOfMemoryException' occurred in System.Data.dll
Code Snippet
DataTable dtMeter = null;
DataTable dtRevClassAvgByDate = null;
foreach (DataRow row in ds.Tables[0].Rows)
{
// Create datatable for each meter
dtMeter = new DataTable(row[Global.MeterIdColumnName].ToString());
dtRevClassAvgByDate = new DataTable();
.......... code...........
}
dtMeter.Dispose();
dtRevClassAvgByDate.Dispose();
Would you please let me know what I am missing.
Thanks
SaiRam
Sairam SohamPosted Oct 15, 2015, 1:00 PM
Its resolved.
After each iteration in the for loop I added the following statements and it worked
dtMeter.Clear();
dtMeter.Dispose();
dtMeter = null;
dtRevClassAvgByDate.Clear();
dtRevClassAvgByDate.Dispose();
dtRevClassAvgByDate = null;