VB.NET 2013: Databases - Connecting, Retrieving and Inserting Data (Part 2/5)

This is a set of video which cover working with database in VB.NET, how to retrieve, delete and manipulate a database via SQL all from VB.NET.

This video covers:
* Creating the project for the first time
* Inserting a database to the project
* Connecting to database
* Retrieving students from database
* Adding students to the database

The next video covers how to get related data, insert marks for students and delete students.

[RusliAliasHalPoli]

Thank you.
This is the BEST, step by step tutorial on the subject that I follow.

[Gmike]

Hi, thank you for the fantastic tutorials! I have a question - if I write a program that connects to a database on a shared network at work do I need to use a specific setup so all clients can access the database from their machines. Thanks in advance for any insight you can offer

[tekilagerila]

very nice tutorial...must see all. good job

[ruchikarathi]

I am having problm with the synatx of INSERT query, when I am running this code it is being shown that there is a syntax error in the INSERT statemnt

[hipparchos]

Does the { } format work for vb2008 when using printline to print into a file? I tried it using your exact syntax and it would print the { } string along with the text.
Great videos btw!

[brodmontgomery]

Hey Nicholas - I'm trying to follow your video, but I'm using Visual Studio 2015 community edition, and the screen I'm looking at is completely different to yours - I've tried changing it to look like yours but I'm getting errors all over the place. Is there a work-around for this? If not I hope you make some videos using Visual Studio 2015.
PS. Your video on creating Access Data bases was very good.

[arafathossen]

+Nicholas Dingle I followed your code it worked but addStudent() function added new student and showed in the console when viewStudent() is asked. But it does not add to the real database file. Can you help me?

[SAGARSANKANNAVAR]

Sir, I am getting the error as "Could not find installable ISAM.". What is the solution? Can you tell me??

[jokezed]

Thank you very much sir! This helped me a lot

[canucka]

Hello from Canada!
Visual Studio 2013 Community Edition and MS Access 2007
The ViewStudents subroutine as provided resulted in the date column being populated with a time. You left it it up to us to figure out how to display the details without the time. After some effort to resolve issues later on in the tutorials I stumbled on a solution that worked for me.
The DOB returned from the database, in my case, will contain date and time details.
The trick was to catch the details of DOB as read and convert it to a formatted string.
At each read I used two new variables; one as date and one as string. The date var held the returned date while the second string held the formatted converted to ShortDate value that was then swapped in the WriteLine statement in the loop.

While reader.Read
            ' commented out
            'Console.WriteLine("{0, -5} {1, -20} {2, -20} {3, -20}", reader("ID"), reader("Firstname"), reader("Lastname"), reader("DOB"))

            ' Revised method to show the last column as a short date only
            rdate = reader("DOB")
            sdate = FormatDateTime(rdate, DateFormat.ShortDate)

            Console.WriteLine("{0, -5} {1, -20} {2, -20} {3, -20}", reader("ID"), reader("Firstname"), reader("Lastname"), sdate)

        End While

Thanks for the guidance and inspiration.

[dmbfan]

Cant seem to connect; Windows 10, Access 2016. Connection string not working, cant seem to find the correct string online. Any help would be greatly appreciated! Great video by the way!

[michaelboahen]

Hi Nick, Please I'm having an error that says:

An unhandled exception of type occurred in System.Data.dll
Additional information: Syntax error in INSERT INTO statement.

when I run my project, can you please help to solve this problem? I appreciate your effort so much Thanks

[ianpOSoftware]

Hola amigo tendras un ejemplo de vb.net almacenar y leer imagenes desde una bd SQLITE

[shimaashams]

I was receiving the "'microsoft.ace.oledb.12.0' provider is not registered on the local machine" error still.  On Win 8 x86, Office 2013 x86
how I can fix this problem

[haydarm.al-samawe]

i have problem (( .. the data not save .. when i close the program and open agen i lost everything i add, i made all the steps, , but i use VB 2015 and access 2010 maybe there is some Different ? and i cannot find locals window in VB 2015 ?1

[Joystick_Legend]

I have a problem with the last line syntax error in INSERT INTO statment Please help

[harir]

hey, i want to communicate to a CNC controller (FANUC) using focas libraries, and Visual Basic is my way through it, can u guide me in fetching data from the machine through Visual basic and storing it in database

[masoodmd]

excellent video tutorials
it would more better if this tutorial will be done in windows application, hope in future

[MrMrbadbad]

So if i want to make a simpe card game and play with my friend across the world he can connect to my database??

[ahsansaif]

my programe keeps crashing although its the same as yours pleeease help, message keeps appearing visual studio has stopped working, wonderful tutorails though