Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > Visual Basic 2005 Basics
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old April 24th, 2007, 08:49 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database not updated

Hi All,

What I simply want to do is just to add a record to a MS Access table. I have found out that the dataset has been updated but the changes didn't reflect in the database.

here is a piece of code that I used and failed.

    Protected Const conString As String = _
        " Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\AddressBook.mdb; User Id=; Password="
    Dim cnn As New OleDbConnection(conString)
    Dim da As New OleDbDataAdapter()
    Dim ds As New DataSet




I have filled up the data adapter in the form load. After that the dataset is updated with the data from textboxes on button click event.



        Dim dr As DataRow

        dr = ds.Tables("Patron").NewRow()
        dr.Item("PID") = Trim(txtPID.Text)
        dr.Item("PName") = Trim(txtPName.Text)

        ds.Tables("Patron").Rows.Add(dr)
        BindingContext(ds).EndCurrentEdit()
        ds.AcceptChanges()

        da.Update(ds, "Patron")


I found out that the dataset is updated but it didnt' reflect to the database. I have binded the textboxes with the fileds from the table at design time from the properties.

Any help will be appreciated :(

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database not getting updated vsc33 VB How-To 4 May 15th, 2008 10:30 AM
updated report dominikm86 Crystal Reports 0 May 28th, 2007 01:03 PM
OPeration must be updated khzahid Classic ASP Basics 1 April 27th, 2005 06:01 PM
Last Updated Record mrideout BOOK: Beginning ASP.NET 1.0 1 September 20th, 2004 09:50 AM
Data not getting updated Renu ASP.NET 1.0 and 1.1 Basics 10 August 21st, 2004 05:39 PM



All times are GMT -4. The time now is 04:39 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.