I solved insert query.now see this Update Query.

amit_mande@yahoo.com · September 20th, 2006, 08:20 AM

see this code

Private Sub cmdUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdUpdate.Click
        Dim intPosition As Int16
        myCommand = New OleDbCommand
        intPosition = myCurrencyManager.Position
        myCommand.CommandText = "UPDATE login SET Password=@Password WHERE UserId=@UserId"
        myCommand.Parameters.Add("@UserId", BindingContext(myDataView).Current("UserId"))
        myCommand.Parameters.Add("@Password", txtPassword.Text)
        myCommand.CommandType = CommandType.Text
        myCommand.Connection = myConnection

        myConnection.Open()
        Try
            myCommand.ExecuteNonQuery()
        Catch ex As Exception
            MessageBox.Show(ex.ToString)
        End Try
        FillDataSetAndView()
        BindFields()

        myCurrencyManager.Position = intPosition
        ShowPosition()

        StatusBar1.Text = "Record Updated"
        myConnection.Close()
    End Sub

The error is "Syntax error in UPDATE Query" Its is catch by try...catch statement
which is correct form of Query?

BrianWren · September 20th, 2006, 03:08 PM

In my opinion, it would have been good if this had been continued in the thread where it was begun; that would have made it so that your statements had a context. Saying in this thread that you fixed something means nothing to those who don't know what you fixed...
For those coming to this new, the original is in http://p2p.wrox.com/topic.asp?TOPIC_ID=49965

____________________ _
Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯Â¯ Â¯

Perhaps your query is trying to translate the field name as a keyword.

What happens if you use

Code:

Private Sub cmdUpdate_Click(ByVal sdr As System.Object, _
                            ByVal e As System.EventArgs) _
            Handles cmdUpdate.Click

        Dim intPosition As Int16
        intPosition = myCurrencyManager.Position

        myCommand = New OleDbCommand
        myCommand.CommandText = "UPDATE login                      " & _
                                "SET    login.Password = @Password " & _
                                "WHERE  UserId         = @UserId   "

or

Code:

Private Sub cmdUpdate_Click(ByVal sdr As System.Object, _

Code:

                            ByVal e As System.EventArgs) _
            Handles cmdUpdate.Click

        Dim intPosition As Int16
        intPosition = myCurrencyManager.Position

        myCommand = New OleDbCommand
        myCommand.CommandText = "UPDATE login                         " & _
                                "SET   [login].[Password] = @Password " & _
                                "WHERE [login].[UserId]   = @UserId   "

?

amit_mande@yahoo.com · September 21st, 2006, 12:48 AM

Ya Its Working.Thanks.