CODEWITHSUNDEEP
sqlvb.net
user3726806
user3726806

Reputation: 1

Getting error: error no value given for one or more required parameters in vb.net for update sql query

These are the statement that having problems. Please do help me to solve this error which i believe because of my UPDATE statement

str = "UPDATE login SET Title=@Title,Author=@Author,Publisher=@Publisher,Series=@Series WHERE ISBN = @ISBN" 



            cmd = New OleDbCommand (str, Cn)
            cmd.Parameters.AddWithValue("@Title", title.Text)
            cmd.Parameters.AddWithValue("@Author", author_name.Text)
            cmd.Parameters.AddWithValue("@Publisher", publish.Text)
            cmd.Parameters.AddWithValue("@Series", series.Text)
            cmd.Parameters.AddWithValue("@ISBN", Isbn_.Text)

            cmd.ExecuteNonQuery()

Upvotes: 0

Views: 89

Answers (1)

Matt Wilko
Matt Wilko

Reputation: 27322

I don't think that OleDb support parameters using the @ syntax. Try using a ? instead likle this:

str = "UPDATE login SET Title = ? ,Author = ?,Publisher = ?,Series = ?" & 
      "WHERE ISBN = ?" 

        cmd = New OleDbCommand (str, Cn)
        cmd.Parameters.AddWithValue("@Title", title.Text)
        cmd.Parameters.AddWithValue("@Author", author_name.Text)
        cmd.Parameters.AddWithValue("@Publisher", publish.Text)
        cmd.Parameters.AddWithValue("@Series", series.Text)
        cmd.Parameters.AddWithValue("@ISBN", Isbn_.Text)

        cmd.ExecuteNonQuery()

Upvotes: 1

Related Questions