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. 4 3248
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.
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.
you are not going to be able to do it how you want and the reason is simple
- query analyzer is a client server app
the web is stateless
as such you are going to have to load the whole lot or load it in sections
that's why i said about paging
you could have some kind of false scroll bar to fire an event which would
get an xmlhttp object to call to either a webpage or a sqlxml template to
return the section of data that you want
you could then cache those values in a local xml doc linked to the grid
by checking if you have it in the local xml doc, it will appear faster to
the user
the reason you won't be able to process some of the xml doc as it loads is
that it would not be well formed if you had a partial doc and so xmlhttp
object would have a fit
"blackhawk" wrote: 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.
Adolf,
Yeah, I realize that I will be doing a "paging" type functionality, but make
it look like lazy loading to the user. I originally thought of just loading
the data page by page into a grid, but I kind of like the idea of sending it
to an xml file and then running the grid from the local xml.
Really, what it sounds like I need is a scrollbar object that I can get the
row count and use to set the size, then when the user clicks on the scroll
bar (or drags it down) I get the top position of the scroll bar then query
the server (perhaps a session state variable) for that starting record for n
records in length.
Problem is, I don't know of any scrollbar objects for the web.
Hey, I appreciate the thoughts, and sometimes having a sounding board helps
me. If you know of anyone doing this, please let me know....but it sounds
like I am blazing the trails once again! ;-(
"adolf garlic" wrote: you are not going to be able to do it how you want and the reason is simple
- query analyzer is a client server app
the web is stateless as such you are going to have to load the whole lot or load it in sections that's why i said about paging
you could have some kind of false scroll bar to fire an event which would get an xmlhttp object to call to either a webpage or a sqlxml template to return the section of data that you want you could then cache those values in a local xml doc linked to the grid by checking if you have it in the local xml doc, it will appear faster to the user
the reason you won't be able to process some of the xml doc as it loads is that it would not be well formed if you had a partial doc and so xmlhttp object would have a fit "blackhawk" wrote:
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. > > This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Vinay Aggarwal |
last post by:
I have been thinking about the lazy initialization and double checked
locking problem. This problem is explain in detail here
http://www.cs.umd.edu/~pugh/java/memoryModel/DoubleCheckedLocking.html...
|
by: Siemel Naran |
last post by:
What is a good idiom for handling a lazy object? I see 2 good
possibilities. Any more, any comments? Which way do people here use?
(1)
class Thing {
public:
Thing(double x, double y) :...
|
by: VM |
last post by:
If I wanted to load an ascii file (which contains 400,000+ lines and each
line is a table row) to a datatable and then display it to a datagrid, what
would the best approach be? I initially had a...
|
by: John Richardson |
last post by:
I've been bothered for some time about my DataGrid not populating my rows
very quickly. I have about 10K rows loading into the grid.
I create a datatable dt with 2 columns, an ID and a display. ...
|
by: schapopa |
last post by:
I have a flex grid and I am loading data to this flex grid in this way
While sqldr.Read
j = j + 1
MSFlexGrid1PLSummary.set_TextMatrix(MSFlexGrid1PLSummary.Row,
MSFlexGrid1PLSummary.Col,...
|
by: koonda |
last post by:
Hi guys,
I am trying to create a web interface in C# using ASP.NET. The database being used is SQL Server. I have some problems loading the tables in the datalist controls. When I run the program...
|
by: fredd00 |
last post by:
Hi,
i'm trying to use lazy loading with Linq to sql and related objects
seems like you can only call the child object if the context is still
open, this is not real lazy loading.
here is my...
|
by: Michael Bray |
last post by:
With the recent release of EF I've decided to dig into it a bit more than I
did before... the question I'm specifically interested in, but haven't
been able to find a resource to answer it is......
|
by: teressa |
last post by:
Hi,
I am new to Grid view Control.
I have a page with many icons on it for different purposes.
I want to add a Grid View where I want to load data with different columns.
Below is my...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |