vb.net: Does anyone know of any good tutorials that can show me how to
1) connect and retrieve data from an Acess and SQL Server DB
2) Update data in the db
3) Add new data to db


I can actually query the northwind db and display the results in a
datagrid already but i do not know if its the proper way to go about
it efficiently.

What i would like to see is code that actually adds new data to an
access database. let me give a scenario
Access db (dbPeople) consists of one table - tblPerson
tblPerson has 3 fields, pkey (autogenerated primary key), FirstName,
LastName.

Lets also say we have a form that has a first name text box and a Last
name textbox, with an ADD button. If data has been entered and add
clicked, what is the code to make the connection, add new rows to the
DB.

This seems like it would be simple, but as i am learning VB.net 2003
it is not so to me. i can do this already with CBuilder and Delphi,
but there are certain things in the .net framework that i would like
to be able to use and write the results to a DB

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

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

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

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

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1393&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=3218&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2186&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=255&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=595&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2883&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2125&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1312&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=3444&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2707&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1991&lngWId=10

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=279&lngWId=10

There's a few to be going along with. Just search Google for ADO, MDB, SQL,
Access & you will literally find millions. I just typed in to Google:

"ADO", "VB.NET"

and it came up with 797, 000

Crouchie1998
BA (HONS) MCP MCSE

On Sun, 1 May 2005 04:59:43 +0100, "Crouchie1998"
[quoted text, click to view]
I did some searching for tutorials already and some offered more info
than i wanted or not enough. I think i found what i need now, i just