Visual studio 2010 - vb.net Lesson #4 - Insert data into Access Database

In this lesson, we are going to perform the following:
Create a Form with 2 input fields
Create an Access Database with 1 table and 3 columns.
Create a connection string to our newly created access database.
Insert data into our access database.

Help support our work here on YouTube by purchasing a copy of Wayne Barron's first published book.

What we use in our office.

The microphone
Audio-Technica AT2020USB Plus Condenser Microphone
UK Customers

Keyboards with a sleek design, ease of use, and easy to type on.
Kensington Slim Type Wired Keyboard
UK Customers

Read about Wayne Barron's Authoring Work.

Thank You
Wayne Barron
Dark Effects Studios
(Like Us On Facebook)
Follow us on Twitter
Spotlight on Dark Effects
View all our videos on Dark Effects Video Site

[yahyaotaif]

Thank you so much. you're a life saver. I would suggest you update this video with good quality picture and sound.

[RoyTerrazas]

I have questions for this video, you used only text, i mean you only inserted text in to the database, but what happens when it is a number or a date?, you didnt use the '' used when inserted a text field into sql server, I know that numbers dont require it, and dates are inputed using #. some other thing, how do you avoid inputing the same user twice and how do you manage sessions?  Thanks for your answers

[luciaalboaie]

In vb why you wrote: Dim objConnection as OleDbConnection= nothing and you don't use it? ☺

[adityakumar-dghs]

I'm getting overflow errors for this can i do for this???? will u plzzz help

[Newwaver]

Lol at the point where you was using Access i got confused xD I didn't see anything that looked like it in my visual studio. Its ok now though :)

[amanikhabthani]

merci mais vraiment la qualite de video est trés movaise je ne peut pas comprendre bien.

[Dpr]

Thanks for the tutorial, however, you are deviating from the purpose for which studio was invented. you're writing a lot of code!! use drag and drop of control to save your time. Otherwise you may use the notepad to create your code and save as html :D

[nadeemkhalani]

Server Error in '/' Application.



Line 24: objcmd.ExecuteNonQuery()
Line 25:
Line 26: 'close the damnn connection


Source File: E:\asp dot net web virsion Tutorial\Access Database vb dot net\Lessons\access database\Default.aspx.vb Line: 24


insitpe of i did all correction and my database in the same folder as the website and changed table name to user(my tabale name in database mydata)

[agramsoft]

is verbose since you imported System.data.Oledb.
You could only write OleDBParameter instead.