Dataset - Out of memory Exception
Posted on 2011-03-17
I have a database table with 60 columns.
I am bringing the data from the table into the dataview and using the dataview, i am filling a grid.
This dataset will be having around 300 rows or more.
dataSet = New DataSet
dv = New DataView(dataSet.Tables("Regulars"))
This grid will refresh every 30 seconds. So, every 30 seconds, a connection to the databse is made and the above 3 steps are repeated.(Winforms Application)
Now i am getting outofmemoryexception.
Is there anything wrong with the way i am filling the grid?
Each time a dataset is created and filled, would it automatically clear or dispose the existing dataset?
Thanks in Advance