a good tutorial for making a vb.net app to read / write SQL db

Question

can someone please recommend some tutorials that show very simple examples on how one can read / rwite to an SQL db?

Answer 1

Check this question : http://stackoverflow.com/questions/71956/vb-net-tutorials

http://www.startvbdotnet.com/ is a nice website to start with.

Using DataReaders, SQL Server

Answer 2

There are literally hundreds of tutorials out there for this, but here are some keywords in order of complexity for you to Google for.

Working with "raw" SQL data (understand how the basic process works):

• SqlConnection Class
• SqlCommand
• SqlDataReader

Working with abstracted SQL data (tables turned into objects and the commands taken care of for you); these are also called ORM tools (Object Relational Mapping):

• LINQ to SQL Classes
• Entity Framework
• NHibernate (not Microsoft, but this is also a popular one)

First example to get you started: http://www.startvbdotnet.com/ado/sqlserver.aspx

Answer 3

The usual sample database for SQL Server is called "Northwind". It is used extensively in example applications for SQL Server, ASP.NET, ASP.NET MVC, WinForms apps and others.
A google search of Northwind + vb.net will quickly find you a few interesting tutorials like these:

WinForms databinding
Microsoft VB.NET code samples