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 6 4600
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
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
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
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
:)
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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.
|
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...
|
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.
|
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:
|
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
| |
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
| |
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,...
|
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...
|
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |