We’ve posted a new Expert Spotlight! Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.
SLOW SHOWING WINDOWS FORM
Hi All,
I have experienced of slow showing windows form, because I have to load huge data to datagridview or other tasks.
I want to show the form first then after that loading data to gridview.
How could I solve this problem ?
Thank you.
I have experienced of slow showing windows form, because I have to load huge data to datagridview or other tasks.
I want to show the form first then after that loading data to gridview.
How could I solve this problem ?
Thank you.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"I want to show the form first then after that loading data to gridview."
Wire up the Shown() event of the Form, and place your code to load the grid in there. You could also use the BackgroundWorker() control to do the query in the background...
Wire up the Shown() event of the Form, and place your code to load the grid in there. You could also use the BackgroundWorker() control to do the query in the background...
Hi Idle_Mind,
-Wire up the Shown() event of the Form
I don't get this ?
-You could also use the BackgroundWorker() control to do the query in the background...
Any sample of it ?
Thank you.
-Wire up the Shown() event of the Form
I don't get this ?
-You could also use the BackgroundWorker() control to do the query in the background...
Any sample of it ?
Thank you.
Double click on the form and select the Shown() event. Put your code in there.
(my code is just a sample you need to get the event from the IDE.
Public Sub Shown()
'Load Database code
End Sub
Here is how to use background worker: http://msdn.microsoft.com/en-us/library/cc221403%28v=vs.95%29.aspx
(my code is just a sample you need to get the event from the IDE.
Public Sub Shown()
'Load Database code
End Sub
Here is how to use background worker: http://msdn.microsoft.com/en-us/library/cc221403%28v=vs.95%29.aspx
Select the Form. In the Properties Pane, bottom right by default, click on the "Lightning Bolt" icon. Scroll down and find the "Shown" entry and double click to the right of it.
you can use asynchronous data loading. check http://emoreau.com/Entries/Articles/2006/11/MARS-and-Asynchronous-ADONet.aspx
Hi Idle_Mind and themrrobert,
There is no big difference with between shown and load event.
Thank you.
There is no big difference with between shown and load event.
Thank you.
You could also try forcing a repaint before the other loading code continues:
Me.Show()
Application.DoEvents()
' ... rest of the loading code ...
-You could also try forcing a repaint before the other loading code continues:
At what event ?
Thank you.
At what event ?
Thank you.
Yes, it improve showing form.
I would like also consider asynchronous data loading by emoreau.
Thank you.
I would like also consider asynchronous data loading by emoreau.
Thank you.
Hi emoreau,
Where to put the asynchronous data loading, at what event in order to make the data appear after form has shown?
Thank you.
Where to put the asynchronous data loading, at what event in order to make the data appear after form has shown?
Thank you.
you can call the BeginExecuteXXX directly from the form_load event but I would create a LoadData method (called by the form_load event for that purpose.
-you can call the BeginExecuteXXX directly from the form_load event but I would create a LoadData method (called by the form_load event for that purpose.
- I am sorry, miss your point. BeginExecuteXXX at load event but LoadData at load event also ?
Thank you.
- I am sorry, miss your point. BeginExecuteXXX at load event but LoadData at load event also ?
Thank you.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial