Binding DataGridView without default DataVeiw, it's possible?

[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?

 

[Miha Markic [MVP C#]]

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.

 

[mtczx232]

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.

 

[Miha Markic [MVP C#]]

If you need that amount of data it has to be stored somewhere...

 

[mtczx232]

unfortunate dotnet not have ready to use, Datatable that cache to
client HD