473,725 Members | 2,067 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Loading data in the flexgrid takes long time

I have a flex grid and I am loading data to this flex grid in this way
While sqldr.Read
j = j + 1

MSFlexGrid1PLSu mmary.set_TextM atrix(MSFlexGri d1PLSummary.Row ,
MSFlexGrid1PLSu mmary.Col, sqldr("date1") & "q-" & sqldr("date2"))

MSFlexGrid1PLSu mmary.Row = 1
MSFlexGrid1PLSu mmary.CellFontB old = True
If Not IsNothing(sqldr ("Total1")) Then
MSFlexGrid1PLSu mmary.set_TextM atrix(MSFlexGri d1PLSummary.Row ,
MSFlexGrid1PLSu mmary.Col, VB6.Format(sqld r("Total1"), "##,##0.00" ))
End If

MSFlexGrid1PLSu mmary.Row = 2

If Not IsNothing(sqldr ("Date2")) Then
MSFlexGrid1PLSu mmary.set_TextM atrix(MSFlexGri d1PLSummary.Row ,
MSFlexGrid1PLSu mmary.Col, VB6.Format(sqld r("Date2"), "##,##0.00" ))
End If

etc...
and I have about 100 rows.

With 9 records that I have filling this flexgrid takes about 4 second.
Then I have few flexgrids on tabs, so the whole form is running very
slow.
Query itself in query analyzer runs immediatelly: 0 second.
I use flexgrid because I have grouping of data and didn't find out how
can I use datagrid for the same display of data.

How can I improve performance of that form?
Thank you
Schapopa

*** Sent via Developersdex http://www.developersdex.com ***
Jan 6 '06 #1
5 4330
Hi

suddenly I see a link in my message, I don't know how that came there.

Cor
Jan 6 '06 #2
Thank you for your reply. I will try to learn more about datagrids and
maybe replace existing flexgrid with that control.
Cheers
Schapopa


*** Sent via Developersdex http://www.developersdex.com ***
Jan 7 '06 #3
As I am looking through your webside and examples that you posted I am
wondering if it is possible to have first column of the grid to be just
a text, something like in flex grid:

MSFlexGrid1PLSu mmary.set_TextM atrix(1, 0, "TOTAL SALES")

and then the remaining part of the row filled with data.
Thank you
Schapopa


*** Sent via Developersdex http://www.developersdex.com ***
Jan 7 '06 #4
Schapopa,

There are with the styles a lot of possibilities almost the same as with the
normal textbox. You can by instance make a column enable false or set it to
read only.

http://msdn2.microsoft.com/en-us/lib...x_members.aspx

I hope this helps,

Cor

<schapopa> schreef in bericht
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
As I am looking through your webside and examples that you posted I am
wondering if it is possible to have first column of the grid to be just
a text, something like in flex grid:

MSFlexGrid1PLSu mmary.set_TextM atrix(1, 0, "TOTAL SALES")

and then the remaining part of the row filled with data.
Thank you
Schapopa


*** Sent via Developersdex http://www.developersdex.com ***

Jan 7 '06 #5
Hi, I saw your post when doing some googling on the datagrid, and just a tip
for you and future googlers to speed up the flexgrid is using the
flexgrid.redraw property, befor loading the data set flexgrid.redraw = false
then after the loading is done, set flexgrid.redraw = true.

Hth

Greetz Peter

--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning. (Rich Cook)

"Cor Ligthert [MVP]" <no************ @planet.nl> schreef in bericht
news:Oa******** *****@TK2MSFTNG P12.phx.gbl...
Schapopa,

There are with the styles a lot of possibilities almost the same as with the normal textbox. You can by instance make a column enable false or set it to read only.

http://msdn2.microsoft.com/en-us/lib...datagridtextbo
x_members.aspx
I hope this helps,

Cor

<schapopa> schreef in bericht
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
As I am looking through your webside and examples that you posted I am
wondering if it is possible to have first column of the grid to be just
a text, something like in flex grid:

MSFlexGrid1PLSu mmary.set_TextM atrix(1, 0, "TOTAL SALES")

and then the remaining part of the row filled with data.
Thank you
Schapopa


*** Sent via Developersdex http://www.developersdex.com ***


Mar 6 '06 #6

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

Similar topics

4
1776
by: simon | last post by:
Hi, I have a fairly complicated script that seems to load fairly fast. But that's because it is on my local server in the office and not on the main one, (and I am the only one on it). So I would like to run some tests, for example how long the pages take to load on average and what load it place on the server. Currently the pages load very fast indeed, but I suspect it is because I am the only one on the server and php/MySQL are not...
3
8500
by: Roy Wang | last post by:
hi, My problem is how to determining when the XML file has loaded using javascript. I loaded an xml file using javascript in a web page. The code below is loading the xml file for IE: this.xmlDoc= new ActiveXObject("Microsoft.DomDocument"); this.xmlDoc.load(url);
5
2728
by: Kurt Bauer | last post by:
I have an ASP group calendar application which pulls calendar data from Exchange via webdav into an XML string. I then loop the XML nodes to populate a collection of appointments. Finally I use the appointment collection to populate the calendar control. The performance getting the XML data is fine, but loading the data into the collection is slow. My question/problem is should I be using the collection, a dataset, or something else to...
5
12236
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...
2
4536
by: JC Carette | last post by:
Hello I am experiencing extremely long time for loading a windows form in my Visual C++ .NET project This Windows form has just 40 labels, 4 checkBoxes, 2 buttons and 11 numericUpDown. It takes several minutes to load this form in the form designer when I double click on the . file in the Visual Studio .NET Solution Explorer. It gets worse with another form that has more controls. It gets really dramatic when I try to compile in...
0
1148
by: ali mootab | last post by:
Hi all, In my database project I use the 'Data' & 'Microsoft FlexGrid Control 6.0' objects to link to my database file. In installation time I place the 'MSFLXGRD.OCX' in application and in system32 directories. In run time, windows messages that 'Class not registerd. Looking for CLSID {...}'. When click OK my main form will display but didn't find database and the FlexGrid fields are empty. I set the 'DatabaseName' property of Data...
1
4122
by: Bails | last post by:
Hi, apologies first up - im a newby and am teaching myself. I need to take data from a flexgrid and display it on a label (on another form). so I have 2 questions 1) how do I get the data off the flexgrid 2) How do I make the data visible on another form. Thanks in advance
5
2820
by: =?Utf-8?B?V2FubmFiZQ==?= | last post by:
We have a page that is loading very slow. There is not a lot of data, not a lot of users are connected at the same time and the page does not produce an error, so I am not sure where to start to look for why it is slowing down. I thought about the DB first and added NOLOCK to a couple of stored procedures that were being run, but with no effect. Can someone offer some tips on where to start looking or how I can begin to diagnose this...
2
1829
by: Curious | last post by:
There's a problem with what is displayed on a tab in my UI. At first, it's a message, "loading...". Then it should be replaced with the actual file name on the tab. Now the issue is that it takes a long time before the message "loading..." is replaced by file name. In my debugger, the switch between "loading..." and file name happens AFTER the last line of code below: void LoadReportFilesWorker_RunWorkerCompleted(object sender,
0
8886
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
8750
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
9401
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
9168
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
9105
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
6010
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
4509
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...
1
3218
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
2154
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.