If you want to do something with a Data Table then read the documentation for the Data Table class. Take another at the original code (post #3), you are missing lines like insert. Add Hi team, I find the post extremely useful not only for beginners but also to experienced developer. That should ALWAYS be your first source of information. " Videos: VB | C# VBForums Database Development FAQ My Code Bank Submissions: VB | C# My Blog: Data Among Multiple Forms (3 parts) Beginner Tutorials: VB | C# | SQL If code from an example doesn't work for you, the first thing you should do is check that you haven't missed anything (either code, or instructions of what to do). As for the question, have you read the documentation?

vb net code for updating access database-26vb net code for updating access database-14

There is all sorts of literature on this topic but people still keep asking the same questions. If you're not using SQL Server then it's a simple matter of switching to the corresponding types of the appropriate namespace for your data source. It can be used to execute a query but you'd never use it for that unless you were populating a view or temp table. Finally, this code uses all the "old style" data access types. NET 2.0 I suggest creating a Data Source to generate a typed Data Set and Table Adapters.

I'm creating this thread so I can send people here to look at some example code that I know will demonstrate all the principles they need. For example, if you're using an Access database then you'd use an Ole Db. Usually you'd use Execute Non Query to execute a DELETE, INSERT or UPDATE command: Note that I have not provided code for disposing objects or catching exceptions. The principles there are basically the same except that you have to write less code. " Videos: VB | C# VBForums Database Development FAQ My Code Bank Submissions: VB | C# My Blog: Data Among Multiple Forms (3 parts) Beginner Tutorials: VB | C# | SQL Hi, I found your compilation verry usefull in my project... Since I'm a new user of VB Express Edition 2008, can you help me in my problem regarding retrieving a recordset and afterwards editing one of its field.

(This is my first post.) Still i would request a good class/module for db connection in access. I m trying to work in i have done little programmings in vb6 and 05.

Particularly i need to access ms access though local would be the best class code.

You can simply build the Data Table schema yourself if you like. Particularly i need to access ms access though local would be the best class code. Editing the data in between is beyond the scope of this thread.

Here's the above code adapted to use the Sql Bulk Copy class, which allows for more efficient insertion of large amounts of data into SQL Server: Why is my data not saved to my database? " Videos: VB | C# VBForums Database Development FAQ My Code Bank Submissions: VB | C# My Blog: Data Among Multiple Forms (3 parts) Beginner Tutorials: VB | C# | SQL hi jmcilhinney, Its a nice documentation.

Ole Db Data Adapter("SELECT ID, Date, Driver, Truck, Customer, Rate, Where_From, Where_To, Pit_Ticket, PO_Number, Yards_Tons, Description, QP_Fee, Fuel, Expenses, Advances FROM Shenandoahs", connection) Dim insert As New Ole Db.

OLEDB.12.0; Data Source='C:\Users\Richard Colbert\Documents\Visual Studio 2008\Projects\Windows Application1\Windows Application1\shenandoah.accdb'") Dim adapter As New Ole Db.

Please don't clutter up Codebank threads with every question you may have that's remotely related to the topic.