474,039 Members | 2,662 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Displaying a datagrid X rows at a time

Hi-
I have a datagrid that in some cases can be several thousand rows in
length. What I'd like it to do is have the data pushed to the browser
after every, say, 100 rows or so. Kind of a "response.flush " effect--
at a certain recurring point in the process, take what we've got and
send it to the browser. Is this possible?

Thanks.

Nov 19 '05 #1
5 1685
Hi,

that is called paging.

here are a few resources for yiou:

<qu****@gmail.c om> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .
Hi-
I have a datagrid that in some cases can be several thousand rows in
length. What I'd like it to do is have the data pushed to the browser
after every, say, 100 rows or so. Kind of a "response.flush " effect--
at a certain recurring point in the process, take what we've got and
send it to the browser. Is this possible?

Thanks.

Nov 19 '05 #2
Sorry, typed too fast :-)

Resources:

ASP.NET DataGrid Paging
http://www.dotnetjunkies.com/Tutoria...6F8C883E6.dcik

ASP.NET DataGrid Paging Part 2 - Custom Paging
http://www.dotnetjunkies.com/Tutoria...B871F967F.dcik

ASP.NET DataGrid Paging - Custom Paging w/ Caching & Numeric Links
http://www.dotnetjunkies.com/Tutoria...1BA3A12DD.dcik

Easy DataGrid Paging with the DataGridPager
http://aspalliance.com/628

--
Teemu Keiski
ASP.NET MVP, Finland
<qu****@gmail.c om> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .
Hi-
I have a datagrid that in some cases can be several thousand rows in
length. What I'd like it to do is have the data pushed to the browser
after every, say, 100 rows or so. Kind of a "response.flush " effect--
at a certain recurring point in the process, take what we've got and
send it to the browser. Is this possible?

Thanks.

Nov 19 '05 #3
Not without using paging as Teemu recommended. It seems as though you still
want to show the 1000+ rows at a time. The DataGrid is rendered as an html
table. Internet Explorer renders table in one pass. IOW, the table (grid)
will not be show to the user on their machine until the whole table has been
received and parsed by the browser.

bill

<qu****@gmail.c om> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .
Hi-
I have a datagrid that in some cases can be several thousand rows in
length. What I'd like it to do is have the data pushed to the browser
after every, say, 100 rows or so. Kind of a "response.flush " effect--
at a certain recurring point in the process, take what we've got and
send it to the browser. Is this possible?

Thanks.

Nov 19 '05 #4
Yeah Bill, that's more of what I had in mind; we want to show the whole
list and avoid paging if we can. Sounds like we might have to split up
the data into separate datagrids somehow. Thanks to you and Teemu for
your help.

Nov 19 '05 #5
qua...@gmail.co m wrote:
Yeah Bill, that's more of what I had in mind; we want to show the whole list and avoid paging if we can. Sounds like we might have to split up the data into separate datagrids somehow.


You could do Response.Flush( ) if you didn't use bound controls like the
DataGrid or Repeater. Render the page like it was classic ASP. Render
the tableHeader, flush, then do a foreach on your rows, rendering HTML
rows and flushing periodically.

It's easy enough to do. In fact, it's exactly how you did it 3 years
ago.
Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

Nov 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
3588
by: Bil Muh | last post by:
Esteemede Developers, I would like to Thank All of You in advance for your sincere guidances. I am developing a software using Visual C++ .NET Standard Edition with Windows Form (.NET) template. Briefly -------------------------------------------------------------------------------------------- I need to create dynamically some controls on the forms, and display these
3
2569
by: Diego TERCERO | last post by:
Hi... I'm working on a tool for editing text resources for a family of software product my company produces. These text resources are found in a SQL Server database, in a table called "Resource" with the following structure : Resource{,en,fr,es} Yes.. these are the only languages supported actually. A couple of rows in that table would look like this :
5
12268
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. The ID is a member of the keys array. I then create a DataView dv over the table, and sort it by Display and ID column (in case of duplicate Display). I then set my DataGrid.DataSource = dv; I then load the datatable with my rows, and this is...
3
4939
by: vinayak | last post by:
Hi I am displaying data in Datagrid in ASP.NET with Edit/Update functionality for each row. On the same page I have 2 Button controls which submits the request to server. These button controls are Web Control & not HTML control. One of these buttons whose title is Delete is added on the aspx page in design view & also I double clicked on this button in design view to get the onclick code for this button in the code behind page. & for...
3
4907
by: Jim Heavey | last post by:
Trying to figure out the technique which should be used to add rows to a datagrid. I am thinking that I would want an "Add" button on the footer, but I am not quite sure how to do that. Is that the best method? Do you have a sample of how to do this?
4
2216
by: Tim T | last post by:
Hi, I have a stored procedure executing a search and an asp.net page displaying the results in a datagrid. The datagrid has paging on it, I am using Visual Studio.NET and can't see any option to show the number of results found. Is there an easy way to add this to the top of the datagrid, along with the total number of pages ie: 67 resuts found page 1 of 7 (where the numbers in are hyperlinks to that
2
2414
by: Eric Dan | last post by:
Hi, Even tough I was able to implement what I want in a weird and non efficient way, I would like to get an opinion what is the right way to achieve my task: Scenario: • Display a DataGrid that contains rows from a table from a databse (so far easy). • I would like to add a column to the DataGrid that will be a drop-down list so the user will be able to select a value from a pre-defined list of values
3
2149
by: Gerhard | last post by:
I would like a DataGrid I am using to show a default number of rows (10) with the heading, even if the dataset it is bound to returns less than that number of rows (0-9). It is a databound grid that sometime returns less than 10 rows (paging is enabled with a row count of 10). I would like the grid to always show 10 rows (blank rows if no data bound to them). Is there a way to do this?
0
1527
by: latin & geek via DotNetMonster.com | last post by:
hi! ok, im working on a database application. ive successfully managed to establish a relationship between two tables and display them on a datagrid, edit and add new records to them. now i need to generate a report using the parameters in the child table, and two columns from the parent table. this is where the problem starts. when i use two seperate connection links and extract the required data, adding it all to the same dataset,...
0
10532
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10328
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11591
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
11129
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
10297
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8685
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6641
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6814
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4933
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.