Quote Originally Posted by alexanderjames View Post
Thank you again Jmcilhinney

You have been a tremendouse help, you are right this my first app im doing in .net and its a small one for a client and it will be much less hassle to code the con as i need it as it.

Many Thanks again for your advice
AJ
That's particularly true if you use the Data Source wizard. You can add a Data Source to your project and point the wizard to a database and it will generate all the connection, schema and query information. You can then drag tables and columns from the Data Sources window onto your forms and many components will be created fro you and some code generated for you. It's a very quick and easy way to get up and running. As you get more advanced though, you'll want to do more (perhaps all) manually so that you can abstract your data access and have finer control in the places that you need it.