VB.NET Tutorial - Update Records In An Access Database

Series Part 4 - In this VB.NET tutorial I will show you how to edit and update records in a Microsoft Access Database. I will also demonstrate how to load database results into textboxes and other form controls and cycle through your record set.

PROJECT SOURCE CODE:

Thank you for supporting this channel!

[devindwight]

As always, very professional and useful information for people working with databases. Thank you for the time you put into these great videos!

[rowanbalana]

You're literally a hero ! Thank you and you have the best tutorials on YouTube :)

[pw]

Thanks you for a great series of videos. I’ve used your methods on a number of programs I use at home.
Is it possible to set up a DBControl Class using Excel instead of Access as I’d like to replicate your programs for my daughter but using an Excel Spreadsheet as that’s what she receives from the head company. She doesn’t have the ability to change to Access
Thanks for any advice

[woodywickliffe]

Thanks for your tutorials.  They've helped me immeasurably.  I wrote a scheduling program in VB6 connecting to an Access database for a local company.  The program grew over the years to about 45, 000 lines of code.  I'm moving it to Visual Studios 2015.  I'm actually a civil engineer who enjoys dabbling in code so I had no idea how to use VB.Net to connect to an Access database.  Your tutorials have given me all the info I need to figure it out.  Once I get it moved to VB.Net, I'm going to change the type of database, which will be simple given your code.  Then I want to move it from a form based program to a web-based program, and possibly sell it commercially.  Your tutorials have opened the door for me so I can move on with this.   Thanks a bunch.Woody

[pw]

Once again a Great Tutorial. Thanks for showing

[bradleywwiitala]

Very nicely done. I've been looking through all the usual website searches on this subject and found exactly what I needed here! I am converting a fairly large VB6 MDI EEG analysis application that uses both ado data controls and code generated database stuff. I have all the windows form stuff and threading figured out and my next step is getting database access down since they are a huge part of the application.
IMO the 'wizards' and build-in data controls seem very confusing compared to the ones in VB6...although I have only worked with them a bit. I may stop using any kind of controls that you have to drop on a form and use code like this.
I particularly like how you encapsulated the database stuff into your DBControl.vb. Thanks again for saving me a huge amount of searching and learning time! (Also typing time with your dropbox link.)

[jasonport]

Hi, Great Video, I have followed this an implemented into my application. I am however having an issue, by where my a combobox draws data from the PersonT table, I want to display the persons full name in the combobox, but store the personID in the table. if that makes sense

[bsworldsolution]

Great tutorial, Please am having a problem in an application am developing which your class has been helpful, the application works with a single database which has multiple tables in it, how can i put out a data from on table to the other and also print different data from different tables to a single page... Thank you

[trevordaniels]

Is it possible to use multiple parameters in the AddParam query, so that the user can either enter the product name or the product code into the search textbox?

[rezasurya]

hello, your tutorial was help me out with my project, thank you for tutorial, i hope you make another tutorial VB in an Access Database

[trevordaniels]

Great series of videos but I keep getting "Syntax error in UPDATE statement and I simply can't find the error. Any ideas?

[josemunozvargas]

Hi, are you still working on it? Your videos are great.

[rowanbalana]

Please help asap How to do it like when i click on the record on the datagrid and click update on the menu strip, it will show the record/data that i chose instead of the first one showing on the datagrid.

[zackduncan]

These videos have been excellent...THANK YOU! I have one question and it may be simple so sorry if I am missing something obvious. Each time I run the program the changes I made in the last run are not there. They do show up as long as I don't close the form. I tried a COMMIT TRANSACTIONS command but I either did not do it right or it is not the correct fix.

[lildemon]

Hello can you tell me the codes for data types of integer and date??? I really need this now for my project at school thanks for the tutorial but I cannot update my database it said "Data type mismatch in criteria expression."

[NathanWynn]

Great tutorial. I was able to get mine to work. I got into issues where my col names are reserved words. I later rewatched the video again and picked up the [].

[vanjomampusti]

hello. I realy love your toturials and I want to learn more because I forgot how to code vb.net. I have a question, when I try to update there is an error and it said "syntax error in UPDATE statement" what do you think went wrong? I follow all your code and videos. Hope you answer my query. Thanks and more tutorials!!

[eximious]

Hi,

Quick question, how do I Update a Selected row in the DataGrid and show all the fields in a new window? instead of showing all records and flicking through all of them to find what I want to update, I would like to click on a record in the initial form and then click edit opening a new window with all of the relevant fields.

Thank you!
Great Videos, have really helped in my project!!

[bkpickell]

I hate doing this, but I'm completely stuck. I'm getting a syntax error on the update string. And as far as I can tell it is correct. It's possible it's because I have a date field, and that field is causing me all kinds of headaches in this string of tutorials. I'll post my update string below, I'm not too confident that I will get any help since this video is over three years old, but a man can wish right? It's word wrapping the long strings, but I think you can still work out what's going on.


Access.ExecQuery("UPDATE * VehicleInfo " & _

[ksmemon]

Sir Could you please Help me to Saving Data Into Database From Data Grid View Control, I am already using Your DbControl Class in my Project,
Thanks and Regards