Welcome to Dream.In.Code
Become a VB.NET Expert!

Join 150,097 VB.NET Programmers for FREE! Get instant access to thousands of VB.NET experts, tutorials, code snippets, and more! There are 1,867 people online right now. Registration is fast and FREE... Join Now!




Updating using wizard

 
Reply to this topicStart new topic

Updating using wizard

Damage
21 Jun, 2008 - 10:01 PM
Post #1

D.I.C Addict
Group Icon

Joined: 5 Jun, 2008
Posts: 754



Thanked: 7 times
Dream Kudos: 75
My Contributions
Hey,
I joined a my app to an Access database using the wizard, how do you update changes made in the dataset to database? I know theres a bunch of tutorials on how to connect and update programmatically, but this is such a stupid little thing(a database of peoples birthdays so i don't forget) that i really don't feel like going through all that trouble. Besides i'd like to know how its done anyway.
thanks
User is offlineProfile CardPM
+Quote Post

Damage
RE: Updating Using Wizard
22 Jun, 2008 - 03:46 PM
Post #2

D.I.C Addict
Group Icon

Joined: 5 Jun, 2008
Posts: 754



Thanked: 7 times
Dream Kudos: 75
My Contributions
so i've figured out that i need to do something like this

CODE

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


        If Me.Validate Then
            Me.TblBirthdaysBindingSource.EndEdit()
            Me.TblBirthdaysTableAdapter.Update(Me.BirthdaysDataSet.tblBirthdays)
        Else
            System.Windows.Forms.MessageBox.Show(Me, "Validation errors occurred.", _
            "Save", System.Windows.Forms.MessageBoxButtons.OK, _
            System.Windows.Forms.MessageBoxIcon.Warning)
        End If
    End Sub


but the problem is it only updates the table stored in the bin folder of the project and this doesn't get reflected anywhere else
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/9/09 12:19AM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live VB.NET Help!

VB.NET Tutorials

Reference Sheets

VB.NET Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month