Binding DataGridView without default DataVeiw, it's possible?

  • Thread starter Thread starter mtczx232
  • Start date Start date
M

mtczx232

I know that when binding DataGridView to Datatable, the ADO.NET create
Dataview.
the problem is with large data, this process take long time and consume
RAM.

if i not need sorting service have a way to avoid the default dataView?
 
Hi,

Here is what I usually do: I give user filters to filter data before
fetching from database and at the same time I limit the max number of
records that can be fetched.
Having enormous amount of data in grid is counterproductive anyway.
 
I'm find your solution before 2 hours. I use with it, to fill datagrid
by loop of DataReader, while records apears on Datagrid as it come
more and more. like SQL Mng Studio do.
 
Back
Top