473,799 Members | 2,868 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Grid View and recordSet

Ed
hi everyone, maybe someone can give me a hand here.

I am working with vb 2005 and i have a gridview that i am loading data from a recordset. I have the recordset returned from the query and i am loading the data, but the problem is... this recordset is going to hold about 25,000+ records and the grid view and form "goes to sleep" and i can click on anything. I would like the user to be able to scroll the grid view and maybe min and max the form while the data is being loaded. i have tried grid.refresh() and me.refresh() but it jsut refreshed the data, it does not let the user scroll the grid view

any ideas?
Thanks!!!!
May 3 '06 #1
1 2585
VJ
You will ahve to use Threads...and do the DataSet reading, in a Thread other
than UI thread, once the ds is available, you can set it to the grid... The
other option is to set grid rows from thread.. Read the below article it is
very helpful.., but it is 2003 and 1.1. I belivie in 2005 there is much
better option of using, but the below articles are a good start, so when you
see 2005 methods you will understand..

http://msdn.microsoft.com/msdnmag/is...T/default.aspx

http://www.devx.com/dotnet/Article/11358/1954?pf=true

http://msdn.microsoft.com/msdnmag/is...g/default.aspx

VJ

<Ed> wrote in message news:O9******** ******@TK2MSFTN GP05.phx.gbl...
hi everyone, maybe someone can give me a hand here.

I am working with vb 2005 and i have a gridview that i am loading data
from a recordset. I have the recordset returned from the query and i am
loading the data, but the problem is... this recordset is going to hold
about 25,000+ records and the grid view and form "goes to sleep" and i can
click on anything. I would like the user to be able to scroll the grid
view and maybe min and max the form while the data is being loaded. i have
tried grid.refresh() and me.refresh() but it jsut refreshed the data, it
does not let the user scroll the grid view

any ideas?
Thanks!!!!

May 3 '06 #2

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

Similar topics

1
4950
by: Bhom | last post by:
I am trying to create a grid on a form that looks like the 'Split Transaction' grid in Quicken - it allows drop down controls in various cells of grid to make a selection, and then stores the text of the drop down list/combo boxes in the grid. I know how to use hidden combo/list boxes that display when a user clicks on a cell that is setup with the drop down button and event. However, when the user makes a selection, the ID (bound...
0
1969
by: Mike | last post by:
I'm having a problem with the grid not getting refreshed after deleting a record. Even though the record is deleted from the table. I have the following code in a Delete button event: sql = "Delete from OrderDetails where Orderid = " & datOrderItems.Recordset!OrderId sql = sql & " and ProductId = '" & datOrderItems.Recordset!ProductId & "'" gconn.Execute sql datOrderItems.Recordset.Requery datOrderItems.Recordset.MoveNext
4
11262
by: sci | last post by:
Could someone help me by answering the questions below? What's a cursor? What's difference between Query and View? Is a RecordSet just part of a table? Can it be part of a query of view? If the content in a table changed, is it necessary for a old recordset to renew itself by do "Requery()"? Thanks for your help!
12
2393
by: pmud | last post by:
Hi, I am using teh following code for sorting the data grid but it doesnt work. I have set the auto generate columns to false. & set the sort expression for each field as the anme of that field... This grid displayes results based on users search.. public static int numberDiv; private void Page_Load(object sender, System.EventArgs e) {
12
2645
by: Neil | last post by:
I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC and has been in place for several years without any performance problems. Recently I added a couple of fields to the output of the view, and it became very slow when scrolling. When just opened in the database window, the linked view takes about...
3
1897
by: SAM | last post by:
Hey guys, Long time Access programmer, but never had to bother with these things until now. First, I use ADO all the time in VB, but now I need to use it in Access 2K. I never remember/know how to link the required libraries to get ADO functionality. It was easy enough in VB. Second, I've been surviving so far with subforms but I really want to try out a grid control. I registered a grid control that was available from ordinary...
0
2079
by: ¿ Mahesh Kumar | last post by:
I have created a XML file as datasource which i 'm binding to a grid view control. During runtime I'm capturing items in XML file and displaying in a GRID VIEW control. but i want to remove or flush the XML file content on page load. I tried parentnode.removeall () but no use.. (1) how to clean/delete the XML file nodes on page load for using as DATA SOURCE which again i'm binding to Grid view..?? (2) and also on page refresh my gird...
2
3861
by: Umeshnath | last post by:
Hi, I have placed a grid view inside Atlas panel. On click of a button event, data is populated in the grid view, I want to add scroll bar instead of increasing the size of grid view. I have written the following code. <div id="Layer1" style="width:350px; height:140px; z-index:1;overflow-y: scroll"> But the problem was scroll bar will be there if there no data aviabale in
0
1604
by: zafar | last post by:
I don't know what property should be used for hiding colums in Data Grid, whereas in Data Grid View we have DataGridView1.Colums(index).Visible = False , But how can I hide Colums in Data Grid.. Secondly Can I make multiple bands in Data Grid View, mean parent and child table appearance in Data Grid View, If so then how.. because when I pass a DataSet (which have relationships between the table in it) to data grid view it only shows the...
0
9689
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
10495
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...
0
10032
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...
1
7573
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
6811
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
5469
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
5597
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4148
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
3
2942
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.