Problems with stored procedure not updating database

[Bomac8]

I have a stored procedure:

CREATE PROCEDURE [AddResident]
(
@residentID int OUTPUT,
@resNames [varchar](100),
@LName [varchar] (100),
@resAddress [varchar](50),
@resEMail [varchar](50),
@resPhone [varchar](50),
@statusID [int])

AS INSERT INTO [RHills].[dbo].[tblResidents]
( [resNames],
[LName],
[resAddress],
[resEMail],
[resPhone],
[statusID])

VALUES
( @resNames,
@LName,
@resAddress,
@resEMail,
@resPhone,
@statusID)

Select @@IDENTITY
GO

When I run this through the execute in Visual Web Developer 2005, it will update the database. When I enter this data in the webpage, it runs but does not update the database.

The code in the webpage is:
Protected Sub btnSubmit_Click (ByVal sender As Object, ByVal e As System.EventArg s) Handles btnSubmit.Click

Dim connectionStrin g As String = WebConfiguratio nManager.Connec tionStrings("RH illsConnectionS tring").Connect ionString

Dim con As New SqlConnection(c onnectionString )
Dim cmd As New SqlCommand("Add Resident", con)

cmd.CommandType = CommandType.Sto redProcedure

cmd.Parameters. Add(New SqlParameter("@ resNames", SqlDbType.VarCh ar, 100))
cmd.Parameters( "@resNames").Va lue = Me.txtNames.Tex t
cmd.Parameters. Add(New SqlParameter("@ LName", SqlDbType.VarCh ar, 50))
cmd.Parameters( "@LName").V alue = Me.txtLName.Tex t
cmd.Parameters. Add(New SqlParameter("@ address", SqlDbType.VarCh ar, 50))
cmd.Parameters( "@address").Val ue = Me.txtAddress.T ext
cmd.Parameters. Add(New SqlParameter("@ email", SqlDbType.VarCh ar, 50))
cmd.Parameters( "@email").V alue = Me.txtEmail.Tex t
cmd.Parameters. Add(New SqlParameter("@ phone", SqlDbType.VarCh ar, 15))
cmd.Parameters( "@phone").V alue = Me.txtPhone.Tex t
cmd.Parameters. Add(New SqlParameter("@ statusID", SqlDbType.Int, 4))
cmd.Parameters( "@statusID").Va lue = 1
cmd.Parameters. Add(New SqlParameter("@ residentID", SqlDbType.Int, 4))
cmd.Parameters( "@residentID"). Direction = ParameterDirect ion.Output

Try
con.Open()
cmd.ExecuteNonQ uery()

Catch ex As Exception

Finally
con.Close()
Me.txtLName.Tex t = ""
Me.txtNames.Tex t = ""
Me.txtPhone.Tex t = ""
Me.txtEmail.Tex t = ""
Me.txtAddress.T ext = ""



End Try

End Sub

Why wont this update the database with the new data?

[kenobewan]

Are you getting any error? Are you writing the exception in the catch? I would double check the connection string. Try debugging - e.g. try writing the update statement in the code first and then use SP. HTH.

[Bomac8]

I put the catch error in the code. Seems there was a problem with the connection string. I fixed that. However, When I run it again, it still will not work. Is there possibly some incompatability problem using web developer express addition with SQL server 2000? It seems I can get the information from the database, but I cant insert into it.