>What's the prefered method for getting data from a SQL Server database
>using Vb.Net?
>
>Also, if anyone has any small to mid side code examples of data retreival,
>I could use a look at them.
>
>Many Thanks

Good morning Kevin;

There are a number of ways to handle data in Dot NET. I could give you some samples of ASP.NET VB.NET code, if that would be of any help.

There are a few ways to handle data on a WebForm and here are four:

1. Drop a data object on the form
2. Drop a stored procedure on a form.
3. Write code to create data objects on a form.
4. Use a multi tiered approach.

Approaches 1 and 2 are simple, 3 requires slightly more work and 4 requires a bit of planning, and thinking but in the long run is a good way to go. A fifth suggestion is from Microsoft and is called “Data Application Blocks”.

http://support.microsoft.com/default.aspx?scid=kb;en-us;829028

There may be times when you want to use any of these based upon your requirements.

Let me know if you want any or all examples of 1-4 above. I am very busy at this time so please have patience if you have any questions that I may be able to assist you with.

Tom