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

My windows application form works finely but whenever i modify already values which are already modified it shows above subject line error how to solve it?

Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Me.Validate()
        Me.ItemsBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.ItemsDataSet)
    End Sub

i am using an sql server for connecting an mdf file for connecting through following command

Imports System.Data.SqlClient
Imports System.Data.Sql

Module Module1
    Public acscmd As New SqlCommand
    Public acsconn As New SqlConnection
    Public acsda As New SqlDataAdapter
    Public acsds As New DataSet
    Public strsql As String
    Public Strreportname As String
    Sub Connect()
        acsconn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Items.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;"
        acsconn.Open()
        If acsconn.State = ConnectionState.Open Then
            MsgBox("Connected")
        End If
    End Sub
End Module

please give me a valid code to correct my error. the error occurs in this line

Me.TableAdapterManager.UpdateAll(Me.ItemsDataSet)

Please help me.

Tags: All Topics