TableAdapter Update Method

Expand Post »

Hi guys, I have got a button to update and save data changes.

When I did not make any changes, I will have a successful update.

When I made changes, it will be give me this error

Without Try statements)

Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

The below is my codings. Anyone have suggestions? Thanks.:eek:

 If Me.Validate Then

            Try

                Me.CanDrinksBindingSource.EndEdit()

                Me.CanDrinksTableAdapter.Update(Me.StockDataSet.CanDrinks) 'Update method

                MessageBox.Show("Update Successful!")



            Catch ex As Exception

                MessageBox.Show("Update failed")

            End Try

        End If

Similar Threads

data adapter update method won't work in VB.NET
oleDbCommand - Update in ASP.NET
Need help debugging program in Java
Making a ball move down and up in an Applet in Java
Help With Datagrid RE: Creating and Saving DropDownList ReportsToID in C#

LiBOC

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

73 posts
since Jul 2005

Permalink

Sep 30th, 2006

Re: TableAdapter Update Method

What did you set the UpdateCommand property as?

Inanna

Reputation Points: 53

Solved Threads: 6

Junior Poster in Training

Offline

90 posts
since Sep 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Datagrid - no value at index ### error when scroll and sort

Next Thread in VB.NET Forum Timeline: how to retrieve the Microsoft Access DAtabase from the INternet using web services

DaniWeb Message

Cancel Changes

User Name
Password