I have a test application that uses databinding to a table of about
20,000 records. The SQL statement for the databinding is "SELECT *
FROM tbl_CID_XRef". From this I can move forward and backward in the
data, edit, add and delete records. It all works fine. There are two
problems.
The first is that it takes awhile for the app to load. The dataset is
filling up with all the records. The second is that the app takes too
much RAM.
Do datasets have a paging feature? Where, for example, I could set it
to a specific size and only that number of records get loaded into the
dataset. Then when moving to a record that is not in that page it will
get the next page.
Or does all this have to be done manually? If so, could you give any
code examples or documentation on this?
4  926 
Hi,
Here is a method that will work with sql server 2005 http://www.windowsformsdatagridhelp....6-def86a1baeef
Ken
-----------------------
"Paul" <pw****@gmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com... I have a test application that uses databinding to a table of about
20,000 records. The SQL statement for the databinding is "SELECT *
FROM tbl_CID_XRef". From this I can move forward and backward in the
data, edit, add and delete records. It all works fine. There are two
problems.
The first is that it takes awhile for the app to load. The dataset is
filling up with all the records. The second is that the app takes too
much RAM.
Do datasets have a paging feature? Where, for example, I could set it
to a specific size and only that number of records get loaded into the
dataset. Then when moving to a record that is not in that page it will
get the next page.
Or does all this have to be done manually? If so, could you give any
code examples or documentation on this?
Ken, thanks for your response. I should have mentioned that we are
using SQL Server 2000. The link you gave me said that the solution
given would not work with 2000. Any other ideas?
Hi,
Sorry there is no simple way to page the data with sql server 2000.
Ken
----------------
"Paul" <pw****@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com... Ken, thanks for your response. I should have mentioned that we are
using SQL Server 2000. The link you gave me said that the solution
given would not work with 2000. Any other ideas?
Could anyone provide some sample code for doing this in VB.NET using
SQL Server 2000 as the back-end?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Natehop |
last post by:
I've been attempting to design an n-tiered framework leveraging .NET's
strongly typed Dataset. My Framework will serve as the foundation to
several client apps from Windows applications to web...
|
by: Bill Stock |
last post by:
The few times in the past that I've loaded unbound data, I've tended to
cheat and use temp tables (not really unbound) or use code for small
datasets.
I'm currently involved in a project that...
|
by: Ben |
last post by:
So, at my place of employment, we use a national standard to transmit
data between certain applications. This standard consists of a fixed
width, flat file 4500-some-odd chars wide that contain...
|
by: sameer |
last post by:
Hi all,
Application environment :
VB.Net desktop application,.NET 1.1 Framework, VS 2003.
communicates between the database and the application is done over
webservices using ADO.NEt Datasets....
|
by: Paez |
last post by:
Hi There.
This post is a extension of thread "Serialize or not to Serialize", on 5 of
December of 2006.
The reason why my teacher insists that a WS cannot return a Dataset is due
to low rate...
|
by: Peter Bradley |
last post by:
Hi all,
This post is sort of tangentially related to my earlier posts on
configuration files for DLLs.
Does anyone know how to create typed DataSets using VS2005's new DataSet
designer, but...
|
by: Peter |
last post by:
Hi!
I am frustrated! I spent a lot of time designing a custom dataset schema
(XSD file) using the Dataset designer. In my main form I had created an
instance of a typed dataset using that...
|
by: Chris |
last post by:
Hello,
I have a problem with re-loading datasets.
As a simple example, if I have an SQL table of addresses
comprising active and inactive addresss, I wish to load either
sub-set by clicking on...
|
by: Leighya |
last post by:
Im currently working on this xml file but when i load it to Mozilla, i got an error
"Error Loading Stylesheet: Xpath parse failure: invalid variable name"
It loads on IE properly. Only with the...
|
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: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
| |
