Solved

vb.net dataset question

Posted on 2011-02-18
11
497 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:geedub1961
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
11 Comments
 
LVL 1

Author Comment

by:geedub1961
ID: 34931084
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.
0
 
LVL 19

Expert Comment

by:Shahan Ayyub
ID: 34933688
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.
0
 
LVL 19

Expert Comment

by:Shahan Ayyub
ID: 34933690
Since you need Vb.Net code so use this converter:
http://www.developerfusion.com/tools/convert/csharp-to-vb/
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 35021924
Still around?
0
 
LVL 1

Author Comment

by:geedub1961
ID: 35041497
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


0
 
LVL 19

Accepted Solution

by:
Shahan Ayyub earned 500 total points
ID: 35043881
Also,

        Try
            Me.Validate()
            Me.TblStdBindingSource.EndEdit()
            Db2DataSet.tblStd.AcceptChanges()
            Me.TblStdTableAdapter.Update(Db2DataSet.tblStd)
        Catch ex As Exception
            MsgBox("Update failed")
        End Try

Open in new window

0
 
LVL 1

Author Comment

by:geedub1961
ID: 35044326

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

gw
0
 
LVL 1

Author Comment

by:geedub1961
ID: 35044351
Ok - I got it is the table "customers" in my case
0
 
LVL 1

Author Comment

by:geedub1961
ID: 35044426
Thanks Shahan
0
 
LVL 1

Author Closing Comment

by:geedub1961
ID: 35044428
thanks
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question