Link to home
Start Free TrialLog in
Avatar of geedub1961
geedub1961

asked on

vb.net dataset question

I am a novice with vb.net  - I have used access alot but very little experience in vb.net.

I built a simple form that has two fields and is connected via dataset.

I need help understanding how to update from  the dataset back to the table from where it came from.
 

THIS IS THE CODE
Public Class Form1

    Private Sub CustomersBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CustomersBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.CustomersBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.NwindDataSet)

    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'NwindDataSet.Customers' table. You can move, or remove it, as needed.
        Me.CustomersTableAdapter.Fill(Me.NwindDataSet.Customers)

    End Sub

    Private Sub BindingNavigatorAddNewItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorAddNewItem.Click

    End Sub
End Class
Avatar of geedub1961
geedub1961

ASKER

As of now I am able to get the data on the form in the text boxes - I just can not figure out how to save the data back to the table.

Thanks for any help on this.
Avatar of Shahan Ayyub
Hi!

check your code by doing it this way:
http://forums.asp.net/p/1390628/2978412.aspx

Also, check it by using AcceptChanges() method of DataSet.
Since you need Vb.Net code so use this converter:
http://www.developerfusion.com/tools/convert/csharp-to-vb/
Still around?
Yes - I finally figured this out - at least to update the database.   For anyone else trying this it might be important to note that I needed to build the application before the update would actually work.

I am not able to add a record and have it saved yet.   Maybe I can get some help on that part.

Whenever I add a record i get "failed to update".

gw

Try
            Me.Validate()
            Me.CustomersBindingSource.EndEdit()
            Me.CustomersTableAdapter.Update(Me.NwindDataSet1.Customers)
            MsgBox("Update successful")

        Catch ex As Exception
            MsgBox("Update failed")
        End Try


ASKER CERTIFIED SOLUTION
Avatar of Shahan Ayyub
Shahan Ayyub
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

Db2DataSet.tblStd.AcceptChanges()
What is the tblstd in the middle?  is that the same as my CustomersTableAdapter?

gw
Ok - I got it is the table "customers" in my case
Thanks Shahan
thanks