Parameterised queries

[ashes]

Hi,

I am getting an error message saying:

“No value given for one or more required parameters.” And it points to this line
command.ExecuteNonQuery()

I am not sure what this means. The code I used is below:

With command.Parameters
 
                    .Add(New OleDbParameter("@Firstname", FirstName.Text))
 
                    .Add(New OleDbParameter("@LastName", LastName.Text))
 
                    .Add(New OleDbParameter("@Address", Address.Text))
 
                    .Add(New OleDbParameter("@Country", Country.Text))
 
                    .Add(New OleDbParameter("@PhoneNo", PhoneNo.Text))
 
                    .Add(New OleDbParameter("@Email", Email.Text))
 
                    .Add(New OleDbParameter("@UserName1", UserName1.Text))
 
                    .Add(New OleDbParameter("@Password1", Password1.Text))
 
                End With
 
 
 
                cmdText = "INSERT INTO Customer (FirstName, LastName, Address, Country, PhoneNo, Email, UserName, [Password]) VALUES (@FirstName,@LastName,@Address,@Country,@PhoneNo,@Email,@UserName1,@Password1)"
 
                command = New OleDbCommand(cmdText, myConnection)
 
                command.ExecuteNonQuery()
 
                Response.Redirect("RegistrationApproved.aspx")

can you help me please?