please help me check this sql statement. it is giving me this error "No value given for one or more required parameters. "

    cn.Open()
    Dim cmd As New OleDb.OleDbCommand
    cmd.Connection = cn
    cmd.CommandType = CommandType.Text
    cmd.CommandText = "Update HallTransaction Set status=? where ID=?"

    cmd.Parameters.Add("@statu", OleDb.OleDbType.VarChar).Value = check
    cmd.Parameters.Add("@Custid", OleDb.OleDbType.VarChar).Value = txtcustid.Text

    cmd.executeNonQuery

thanks

Which line does the exception happen on?

Try setting the command to this string first

cmd.CommandText = "Update HallTransaction Set status=@statu where ID=@custid"

and don't forget to put single quotes around text fields.

just change this line of code

cmd.CommandText = "Update HallTransaction Set status=@status where ID=@ID"

Regards

Isn't that what the good reverend sugguested about 9 hours before you?

Except that my parameter names match the names the OP used in lines 7 and 8. If they don't match then it doesn't work.

•̸ŤђαϞĸs so much I can see where am making the error. It is at the field name. I can't believe I can make this error. •̸ŤђαϞĸs so much , I really appreciate your contribution. This is my first time θƒ using this forum. It has really help. Thanks

please mark this thread solved if your prob is solved

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.