Form Loaded very slow

[Gidi]

hello, i have few windows forms in my application and those whom connected to my sql dataBase are loading very very slow, what can be the problem?

at the Form_load event i'm clearing my dataset and filling the dataAdapter with this dataSet.

one of the forms has radio box that each one gets data from different table (same dataSet and DataAdapter) and when i'm swithching the transfer between the the tables is fast.

thank you

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

If you are accesing the SQL server at load time that can be the problem, on
the other hand there is nothing much you can do if you need that data in the
main form, the best solution for this escenario is using a Splash screen
while you are loading the data. Do a search in this NG by "splash screen"
and you will find several ways of doing it.
Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Gidi" <sh*****@hotmail.com.dontspam> wrote in message
news:CF**********************************@microsof t.com...

hello, i have few windows forms in my application and those whom connected to my sql dataBase are loading very very slow, what can be the problem?
at the Form_load event i'm clearing my dataset and filling the dataAdapter with this dataSet.
one of the forms has radio box that each one gets data from different table (same dataSet and DataAdapter) and when i'm swithching the transfer
between the the tables is fast.
thank you