Using this code.. i am trying to make sure everything is alright before i send the user to the next page.<BR><BR>If i remove the checks like the Check if user already exists thing i could use just IfPage.IsValid then <BR>Response.Redirect(RegisterOk.Aspx)<BR><BR>bu t when i have the UserCheck thing even if the User is new i can&#039;t get it to go to the next page.<BR><BR>my User Check Code is<BR><BR>-SQL<BR>ALTER procedure CheckUserName<BR>@Username nvarchar(16)<BR>as<BR>if exists (select Top 1 Username from Customer where @Username = Username)<BR>begin<BR>select &#039;User already Exists&#039;<BR>end<BR>return<BR><BR>and if the username already exists how do i make it so it only says it that one time say if the username already exists then they leave a blank when they click next so it doesn&#039;t say user already exists again.<BR><BR>-<BR><BR>Dim regUsername As String = usernameBox.Text<BR> Dim regFirstName As String = firstNameBox.Text<BR> Dim regLastName As String = lastNameBox.Text<BR> Dim regStreet As String = streetBox.Text<BR> Dim regCity As String = cityBox.Text<BR> Dim regProvince As String = provinceBox.SelectedIndex<BR> Dim regPostalCode As String = postalCodeBox.Text<BR> Dim regPhone As String = phoneBox.Text<BR> Dim regEmail As String = emailBox.Text<BR> Dim regPass As String = passwordBox.Value<BR> Dim regHintforPassword As String = hintBox.Text<BR> Dim IsPageValid As Boolean = False<BR> Dim IsUserNameValid As Boolean = False<BR><BR><BR><BR> <BR> Dim oCheckUser As SqlClient.SqlCommand<BR> oCheckUser = New SqlClient.SqlCommand("CheckUserName", SqlConnection1)<BR> oCheckUser.CommandType = CommandType.StoredProcedure<BR><BR> Dim pUserCheck As SqlClient.SqlParameter<BR> pUserCheck = New SqlClient.SqlParameter("@Username", SqlDbType.NVarChar, 16)<BR> pUserCheck.Value = regUsername<BR> oCheckUser.Parameters.Add(pUserCheck)<BR><BR> &#039;checking to see if the user name is taken or not<BR><BR> Try<BR> SqlConnection1.Open()<BR> Dim objDR As SqlClient.SqlDataReader<BR> objDR = oCheckUser.ExecuteReader()<BR> If objDR.Read() Then<BR> IsUserNameValid = True<BR> End If<BR><BR><BR> objDR.Close()<BR> SqlConnection1.Close()<BR> Catch objError As Exception<BR> UserNameExists.Text = "An Error Occured " & objError.Message & " " & objError.Source<BR> Exit Sub<BR> End Try<BR><BR> If Page.IsValid Then<BR> IsPageValid = True<BR> End If<BR><BR> Dim oRegisterUser As SqlClient.SqlCommand<BR> oRegisterUser = New SqlClient.SqlCommand("RegisterUser", SqlConnection1)<BR> oRegisterUser.CommandType = CommandType.StoredProcedure<BR><BR> Dim pUserID As SqlClient.SqlParameter<BR> pUserID = New SqlClient.SqlParameter("@UserID", SqlDbType.Int, 4)<BR> pUserID.Direction = ParameterDirection.Output<BR> oRegisterUser.Parameters.Add(pUserID)<BR><BR> Dim pUsername As SqlClient.SqlParameter<BR> pUsername = New SqlClient.SqlParameter("@Username", SqlDbType.NVarChar, 14)<BR> pUsername.Value = regUsername<BR> oRegisterUser.Parameters.Add(pUsername)<BR><BR> Dim pFirstName As SqlClient.SqlParameter<BR> pFirstName = New SqlClient.SqlParameter("@FirstName", SqlDbType.NVarChar, 50)<BR> pFirstName.Value = regFirstName<BR> oRegisterUser.Parameters.Add(pFirstName)<BR><BR> Dim pLastName As SqlClient.SqlParameter<BR> pLastName = New SqlClient.SqlParameter("@LastName", SqlDbType.NVarChar, 50)<BR> pLastName.Value = regLastName<BR> oRegisterUser.Parameters.Add(pLastName)<BR><BR> Dim pStreet As SqlClient.SqlParameter<BR> pStreet = New SqlClient.SqlParameter("@Street", SqlDbType.NVarChar, 100)<BR> pStreet.Value = regStreet<BR> oRegisterUser.Parameters.Add(pStreet)<BR><BR> Dim pCity As SqlClient.SqlParameter<BR> pCity = New SqlClient.SqlParameter("@City", SqlDbType.NVarChar, 50)<BR> pCity.Value = regCity<BR> oRegisterUser.Parameters.Add(pCity)<BR><BR> Dim pProvince As SqlClient.SqlParameter<BR> pProvince = New SqlClient.SqlParameter("@Province", SqlDbType.NVarChar, 3)<BR> pProvince.Value = regProvince<BR> oRegisterUser.Parameters.Add(pProvince)<BR><BR> Dim pPostalCode As SqlClient.SqlParameter<BR> pPostalCode = New SqlClient.SqlParameter("@PostalCode", SqlDbType.NVarChar, 10)<BR> pPostalCode.Value = regPostalCode<BR> oRegisterUser.Parameters.Add(pPostalCode)<BR><BR> Dim pPhone As SqlClient.SqlParameter<BR> pPhone = New SqlClient.SqlParameter("@Phone", SqlDbType.NVarChar, 12)<BR> pPhone.Value = regPhone<BR> oRegisterUser.Parameters.Add(pPhone)<BR><BR> Dim pEmail As SqlClient.SqlParameter<BR> pEmail = New SqlClient.SqlParameter("@Email", SqlDbType.NVarChar, 75)<BR> pEmail.Value = regEmail<BR> oRegisterUser.Parameters.Add(pEmail)<BR><BR> Dim pPassword As SqlClient.SqlParameter<BR> pPassword = New SqlClient.SqlParameter("@Pass", SqlDbType.NVarChar, 16)<BR> pPassword.Value = regPass<BR> oRegisterUser.Parameters.Add(pPassword)<BR><BR> Dim pHintForPassword As SqlClient.SqlParameter<BR> pHintForPassword = New SqlClient.SqlParameter("@HintforPassword", SqlDbType.NVarChar, 100)<BR> pHintForPassword.Value = regHintforPassword<BR> oRegisterUser.Parameters.Add(pHintForPassword)<BR> <BR> SqlConnection1.Open()<BR> oRegisterUser.ExecuteNonQuery()<BR> SqlConnection1.Close()<BR><BR><BR><BR> &#039;so get the value back from check user and if make it into a string<BR> &#039;If oCheckUser.Parameters.["@UsernameCheck" = "0"] Then<BR><BR> &#039;End If<BR><BR><BR><BR> If IsUserNameValid = True And IsPageValid = True Then<BR> Response.Redirect("registerOK.aspx")<BR> End If<BR><BR> <BR> End Sub