RE: Lazy Loading Grid Object

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: blackhawk (blackhawk_at_discussions.microsoft.com)
Date: 11/12/04


Date: Fri, 12 Nov 2004 08:03:05 -0800

Adolf,

I am not looking for paging. I guess you could say that what I am looking
for is very similar to how Query Analyzer works when you open a table for
viewing that is very large.

You open the table, it loads the first X records and then as you scroll
down, it loads those records. It does not try to load the entire table at
once.

This is effectively what I am trying to accomplish, but on the web instead
of in a windows app.

Do you have any samples or can you point me to some blogs that discuss this
in more detail?

"adolf garlic" wrote:

> not quite sure what you are on about but -
>
> in our websites (classic and .net)
> we call out from the client using the xmlhttp object which can either
> - call a page which returns xml
> - call a sqlxml template which returns xml
>
> you can then easily bind the grid to the xml
>
> this is not a .net postback
> this doesn't require the page to reload and can happen in the background
> you can also do it from classic asp
>
> what you are on about sounds more like paging rather than scrolling
>
> datagrid supports paging and i'm sure you could easily link 2 grids to fire
> on each others page change event
>
> i just don't think the 'load a bit at a time on scrolling with a scroll bar'
> is going to work
>
> when you've got the xml down on the client (can assume msxml3 if using IE6)
> you can always use an XSL to transform the result to an html doc. This is
> another approach we have used in the past
>
> "blackhawk" wrote:
>
> > I need to build a web page that has to potentially display a large amount of
> > data in two grids on the same page. The HTML file with all of the formatting
> > is about 7MB in size. This is too large and I need to implement some kind of
> > "client side" lazy loading.
> >
> > What I mean is this: I want to display a grid that only shows, say, 20
> > records. I need an external scrollbar control that I can then show on the
> > screen next to the grid. When the user moves the scroll bar, I want to load
> > only that window of data into the grid.
> >
> > Preferably, I would like to do this client-side without a postback event,
> > because I have more than one grid of data on a single web page. Both of
> > which will need this capability.
> >
> > Anyone have any suggestions, third party software, or otherwise that I can
> > look at?
> >
> > P.S. I would prefer an external scroll bar rather than one that comes with
> > each grid because I want one scroll bar to control two grids simultaneously.
> > I.e. The horizontal scrollbar control scrolls both grids' right and left
> > movement. Vertical scrollbars are associated with each grid independently.
> >
> >



Relevant Pages

  • RE: Lazy Loading Grid Object
    ... Yeah, I realize that I will be doing a "paging" type functionality, but make ... to an xml file and then running the grid from the local xml. ... row count and use to set the size, then when the user clicks on the scroll ... > as such you are going to have to load the whole lot or load it in sections ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Paging, Filtering and Sorting
    ... The reason I want to use the paging is because of the number of records. ... only show a chunk at a time in the grid. ... > like to be able to load pages into the grid. ... > entire resultset into the dataset and pick up the next block of results as ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Searching in a multipage gridview in an updatepanel is extremely difficult (for me) !
    ... If you are using default paging, ala declarative in ASP.NET, the only records on the server side are the ones you are showing - as well. ... grid, meaning client side JavaScript. ... For intRecordCounter As Integer = 0 To CType ... However, on changing pages, the selection gets lost (setting the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: light switch tax
    ... Especially when those lesson plans have to be geared towards teaching ... turning off your lights makes no difference in the grid is irrelevent ... If the grid needs to be load balanced on the fly generators can be ... Ohm's law is E=IR or Voltage equals Current times Resistance ...
    (rec.martial-arts)
  • Re: How to simulate the double-click event?
    ... large list and I wanted the scroll bars. ... The tool bar I see does not include a "Grid" so I ... If NumberOfLinesOfText> VisibleRows Then ... Private Sub MSFlexGrid1_MouseDown(Button As Integer, ...
    (microsoft.public.vb.general.discussion)