I need help in database connectivity in vb.net

there are alot of example available on net and also alot is available on msdn.
here are steps i am considering sqlserver as database server.
1- past an sql connection control from toolbar to your form rename it to sqlcon.
2- Select sqlcon you have just created and in its properties click on its connection string.
3-click new then select connection provider as Microsoft SQL Server.
4- click ok your connection is open now on form load event of your form put this line
if sqlcon.state=connection.closed then sqlcon.open()
it will open the connection if it is still close.
now you can do your work databse is connected.