Improve company productivity with a Business Account.Sign Up

x
?
Solved

vb.net dataset question

Posted on 2011-02-18
11
Medium Priority
?
520 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
  • 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 2000 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …
Watch the working video to know how to import Outlook PST/OST files to Amazon WorkMail. Kernel released this tool which is very easy to use and migrate single or multiple PST and OST files to Amazon WorkMail. To know more about Kernel Import PST to …

606 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