Binding DataGridView without default DataVeiw, it's possible?

microsoft.public.dotnet.framework.adonet

3 Mar 2006 1:42 PM

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?

3 Mar 2006 2:00 PM

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.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

<mtczx***@yahoo.com> wrote in message

Show quote

news:1141393372.880098.228660@z34g2000cwc.googlegroups.com...
>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?
>

3 Mar 2006 2:36 PM

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.

3 Mar 2006 2:41 PM

Miha Markic [MVP C#]

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

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

5 Mar 2006 7:23 AM

mtczx232

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