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