VB.NET Form Loaded or Similar

[Guest 32046]

Can't seem to find this event.

I'd like to connect to a database once the form has loaded because if I try connecting in form_load() and there's an error, it just hangs. Does anyone know if such an event exists?

Cheers...

[Guest 23135]

There are other events you could use, activated paint etc but they will occur more than once.

My question to you would be why are you getting an error and why is it hanging ?

[Guest 32046]

Originally Posted by killerwattsj

There are other events you could use, activated paint etc but they will occur more than once.

My question to you would be why are you getting an error and why is it hanging ?

Tried both activated and paint. Neither do the trick.

If I try and connect within form_load() and there's an error (server is down, incorrect login details) it will hang whilst trying to get a response. The user won't be able to see that the program has even loaded. Not very user friendly.

If I could figure out a way of opening the connection once the form has loaded, I could display a message while it's connecting.

[Guest 23135]

I'll admit I'm not a .Net expert but shooting from the hip I would say ....

1) any chance of lowering your timeouts ? So the user will get a quicker response and catching/displaying the errors ?

2) use a second form as a splash screen to let the user know something is loading and then close it once the connection is made (or not)

3) err ... scraping the barrel but start a timer in onload and connect to the db in the timer event ?

Hope that gives you some ideas

[Guest 32046]

Originally Posted by killerwattsj

I'll admit I'm not a .Net expert but shooting from the hip I would say ....

1) any chance of lowering your timeouts ? So the user will get a quicker response and catching/displaying the errors ?

2) use a second form as a splash screen to let the user know something is loading and then close it once the connection is made (or not)

3) err ... scraping the barrel but start a timer in onload and connect to the db in the timer event ?

Hope that gives you some ideas

Cheers mate.

The connectiontimeout property is read only so I think I'll have to look at the option in the server config.

The second form seems a good idea though, I'll give that a try.

[Guest 2612]

whsy it hanging? The connection should havea timeout property you can set or it defaults to 30 seconds i think. So long as you put it in a Try...Catch then it should drop out and report the error to the user.

try
conection gubbins here
catch ex as exception
msgbox ex.description
end try

that sort of thing?

[Guest 32046]

Originally Posted by Spam

whsy it hanging? The connection should havea timeout property you can set or it defaults to 30 seconds i think. So long as you put it in a Try...Catch then it should drop out and report the error to the user.

try
conection gubbins here
catch ex as exception
msgbox ex.description
end try

that sort of thing?

What happens is, the user launches the application, on launching it the application attempts to connect to the server. If there's a problem, it will take around 30 seconds (or however long the timeout is) to respond. So it's basically hanging. The user will wonder what the hells going on and probably end the task.

But this second form idea will probably do the trick.