473,711 Members | 3,004 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

maximum datagrid row count?

hello everyone,

one of my developers is working with a DataGrid component, which uses a
DataTable as its DataSource.

the DataTable is populated by a method which calls a stored procedure
through an SqlCommand object, which accepts two input parameters which
affect the query range.

the problem she's experiencing is that with all input parameter values,
the DataTable is built correctly, and has data in it (this can be
verified through runtime debugging inspection - but also through
manually running the stored procedures with all the possible input
parameter values - they all return greater than zero rows). however,
when the input parameters are least restrictive (meaning the largest
range of rows returned) - even though the DataTable has information in
it, the DataBind operation seems to have no effect whatsoever. after
the DataBind, the DataGrid displays no data.

the only thing we can think of is if the DataGrid has a limitation of
the number of rows it can display? or perhaps just a raw amount of data
that can be bound to it? that seems unlikely though, since the number
of rows being returned by the least restrictive search is only 32,581.

thanks for any help,

jason

Nov 19 '05 #1
6 4597
I do not mean to sound overly critical, but, realistically, who looks at 32
thousand rows on a web page? I am not stating that you might not have the
application that is the exception, but apps that dump huge amounts of data
are generally worthless, unless you are talking about reporting (which is
killing a lot of trees to make reams of paper that never get read ;-> ).

I would try paging and see if the data shows with paging on. If so, then you
are dealing with a huge amount of data and that is your problem. Attempt two
would be to turn off ViewState for the DataGrid, as every row you write out
could be writing out many bytes of ViewState data.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** ************
Think Outside the Box!
*************** ************
"jason" wrote:
hello everyone,

one of my developers is working with a DataGrid component, which uses a
DataTable as its DataSource.

the DataTable is populated by a method which calls a stored procedure
through an SqlCommand object, which accepts two input parameters which
affect the query range.

the problem she's experiencing is that with all input parameter values,
the DataTable is built correctly, and has data in it (this can be
verified through runtime debugging inspection - but also through
manually running the stored procedures with all the possible input
parameter values - they all return greater than zero rows). however,
when the input parameters are least restrictive (meaning the largest
range of rows returned) - even though the DataTable has information in
it, the DataBind operation seems to have no effect whatsoever. after
the DataBind, the DataGrid displays no data.

the only thing we can think of is if the DataGrid has a limitation of
the number of rows it can display? or perhaps just a raw amount of data
that can be bound to it? that seems unlikely though, since the number
of rows being returned by the least restrictive search is only 32,581.

thanks for any help,

jason

Nov 19 '05 #2
32,581 rows will easily eat up all the memory available for the browser and
you will end up with an "out of memory exception" on client side. Make sure
you are not getting client-side errors.

Eliyahu

"jason" <ia****@yahoo.c om> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .
hello everyone,

one of my developers is working with a DataGrid component, which uses a
DataTable as its DataSource.

the DataTable is populated by a method which calls a stored procedure
through an SqlCommand object, which accepts two input parameters which
affect the query range.

the problem she's experiencing is that with all input parameter values,
the DataTable is built correctly, and has data in it (this can be
verified through runtime debugging inspection - but also through
manually running the stored procedures with all the possible input
parameter values - they all return greater than zero rows). however,
when the input parameters are least restrictive (meaning the largest
range of rows returned) - even though the DataTable has information in
it, the DataBind operation seems to have no effect whatsoever. after
the DataBind, the DataGrid displays no data.

the only thing we can think of is if the DataGrid has a limitation of
the number of rows it can display? or perhaps just a raw amount of data
that can be bound to it? that seems unlikely though, since the number
of rows being returned by the least restrictive search is only 32,581.

thanks for any help,

jason

Nov 19 '05 #3
you're kidding me right? 32K text data rows is literally insignificant
for client side memory concerns, unless each row is an epic poem.
thanks though.

jason

Nov 19 '05 #4
paging did the trick. interesting that paging is required for a certain
volume of data. i'll tinker with the viewstate and see if that's what's
causing the threshold we're seeing.

and to your criticism, you are correct, it is reporting, but why would
you think we're killing trees? that's beauty of web-reporting, no paper
:)

Nov 19 '05 #5
Don't forget about DHTML DOM. Do you know how much memory every object
takes? I don't know, but 32K rows plus number_of_colum ns x 32K cells could
be too much. One of my applications used to choke up on just few thousand
rows until I limited the number of rows. It did produce an "out of memory"
exception on client.

Eliyahu

"jason" <ia****@yahoo.c om> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...
you're kidding me right? 32K text data rows is literally insignificant
for client side memory concerns, unless each row is an epic poem.
thanks though.

jason

Nov 19 '05 #6
Jason,

Things I'd try to check for scaling problems:

1) Try different browsers. Maybe you are hitting a browser limit. So try IE, Firefox,
Opera, etc.

2) Do an HTML GET via a non-browser method on the client and save the result to a
file. You can use Perl or other languages for sending the stuff. See if the text is
all coming back.

3) Try eliminating most of the columns in a trial build and see if you can get more
rows per page if you have less data per row.

I wonder if a large page load could cause a time-out on total transfer time. Don't
think so. But, again, using different browsers might help you control for that.

jason wrote:
hello everyone,

one of my developers is working with a DataGrid component, which uses a
DataTable as its DataSource.

the DataTable is populated by a method which calls a stored procedure
through an SqlCommand object, which accepts two input parameters which
affect the query range.

the problem she's experiencing is that with all input parameter values,
the DataTable is built correctly, and has data in it (this can be
verified through runtime debugging inspection - but also through
manually running the stored procedures with all the possible input
parameter values - they all return greater than zero rows). however,
when the input parameters are least restrictive (meaning the largest
range of rows returned) - even though the DataTable has information in
it, the DataBind operation seems to have no effect whatsoever. after
the DataBind, the DataGrid displays no data.

the only thing we can think of is if the DataGrid has a limitation of
the number of rows it can display? or perhaps just a raw amount of data
that can be bound to it? that seems unlikely though, since the number
of rows being returned by the least restrictive search is only 32,581.

thanks for any help,

jason

Nov 19 '05 #7

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

Similar topics

10
2101
by: KemperR | last post by:
Dear All, may be some of you can help me with an XSLT example how to solve the following challange. For the XML below I want to find out the maximum hierarchy level for a specific element in my XSLT. The result for the example (searching for <A/>) should be 4 as the element A is nested 4 times maximum. I guess I have to use somehow the count function with 'following::A' axes. But I could not get that to work yet.
3
539
by: sam | last post by:
Hello Group, Havent had luck posting it to microsoft.public.dotnet.framework.aspnet.datagridcontrol group. Excuse me for the cross posting. I have a datagrid which needs to be split into multiple pages when printing along with headers on every page. I came up with this routine below which adds 2 rows - one with datagrid headers and the other is also a headers which consists other related information. The 2 rows(headers) needs to be...
2
28593
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
3
4270
by: Bill C. | last post by:
Hello, I know this has been discussed a lot already because I've been searching around for information the last few weeks. I'm trying to implement a DataGridComboBoxColumn class. I've found several examples on the web. They all seem to have problems, though that I've been unable to resolve. The most promising example I have found is at:
2
4328
by: pei_world | last post by:
I want to implement a key hit with enter to dropdown a combobox that is in the datagrid. in this case I need to override its original behaviours. I found some codes from the web. Does anyone know how to use this code? please help! http://www.experts-exchange.com/Programming/Programming_Languages/C_Sharp/Q_20862953.html
4
2717
by: skOOb33 | last post by:
I successfully autosized the columns and rows on my Datagrid, and am now facing another issue. Having the sorting ability by clicking the column headers is key, but when I do that, it resizes all my rows back to their defaults. I populate the datagrid, resize it accordingly and it works fine...just when I click the headers is when it messes up. It would be fine if I could run my autosizing again after the sorting is done since there...
3
17923
by: Madmartigan | last post by:
Hello I have the following task but am battling with the final output. How do I keep two different vectors in sync and how would I retrieve the index for the maximum value of one of the vectors?? (using Dev-C++ compiler) Please see task and attempt below: TASK : 1.8.1 Exercise 1A - Temperature tracker Write a program that tracks temperatures during an experiment that takes 24 hours. The user should input the temperature. This...
1
1917
by: Brock | last post by:
Thanks in advance... (you can see a screenshot of what my form looks like currently at http://www.juggernautical.com/DataGrid.jpg - the Datalist is super-imposed in 'design view' but the DataGrid is the actual running of the page) I've almost got this working (?) but need a little help. I have an .aspx page that has a DataGrid listing employees with a "Select" button that is to be used to populate the DataList to the right of the DataGrid...
8
3084
by: Brock | last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The reason for this is that I want the user to be able to change values without updating the database, but still have their report reflect the values they anticipate committing to see hypothetical totals of columns from a set of records. These records are displaying properly on my DataGrid but I'm not sure how to get Crystal Reports 10 to use as its datasource the dataset...
0
8794
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
8699
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
9295
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9066
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5942
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4713
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3152
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2509
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2099
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.