> Using conRFPData

> cmd = New SqlCommand

> cmd.CommandText = "rfp_insProperty"

> cmd.CommandType = Data.CommandType.StoredProcedure

> cmd.Connection = conRFPData

> cmd.Parameters.Add("@Address", Data.SqlDbType.VarChar)

> cmd.Parameters("@Address").Value = txtAddress.Text

> cmd.Parameters.Add("@BuildingName", Data.SqlDbType.VarChar)

> cmd.Parameters("@BuildingName").Value = txtBuildingName.Text

> cmd.Parameters.Add("@BuildingPark", Data.SqlDbType.VarChar)

> cmd.Parameters("@BuildingPark").Value = txtBuildingPark.Text

> cmd.Parameters.Add("@Submarket", Data.SqlDbType.VarChar)

> cmd.Parameters("@Submarket").Value = ddlSubmarket.SelectedValue

> cmd.Parameters.Add("@City", Data.SqlDbType.VarChar)

> cmd.Parameters("@City").Value = txtCity.Text

> cmd.Parameters.Add("@State", Data.SqlDbType.VarChar)

> cmd.Parameters("@State").Value = txtState.Text

> cmd.Parameters.Add("@ZipCode", Data.SqlDbType.VarChar)

> cmd.Parameters("@ZipCode").Value = txtZipCode.Text

> cmd.Parameters.Add("@County", Data.SqlDbType.VarChar)

> cmd.Parameters("@County").Value = txtCounty.Text

> cmd.Parameters.Add("@GroupCode", Data.SqlDbType.Char)

> cmd.Parameters("@GroupCode").Value = ddlGroupCode.SelectedValue

> cmd.Parameters.Add("@LeaseSaleCode", Data.SqlDbType.Char)

> cmd.Parameters("@LeaseSaleCode").Value = ddlLeaseSaleCode.SelectedValue

> cmd.Parameters.Add("@newPropID", Data.SqlDbType.Int)

> cmd.Parameters("@newPropID").Value = 0

> Try

> conRFPData.Open()

> newPropID = Convert.ToInt32(cmd.ExecuteScalar())

> Catch ex As Exception

> LblMsg.Text = "Adding the new property failed due to error below<br />" &
> ex.Message

> End Try

> End Using

> LblMsg.Text = "New PropertyID = " & newPropID.ToString

> The LblMsg.Text returns "New PropertyID = 0"

> David
> "Aaron Bertrand [SQL Server MVP]" <ten.@dnartreb.noraa> wrote in
> message news:e5uFFeupHHA.4196@TK2MSFTNGP06.phx.gbl...
>> Are you expecting to SELECT the value from @newPropID, or are you
>> properly using it as an OUTPUT?  Can you show the code where the value
>> "is not returning"?

>> --
>> Aaron Bertrand
>> SQL Server MVP
>> http://www.sqlblog.com/
>> http://www.aspfaq.com/5006

>> "David C" <dlch@lifetimeinc.com> wrote in message
>> news:OrQudaupHHA.4544@TK2MSFTNGP02.phx.gbl...
>>> Below is my stored proc that is inserting but is not returning the
>>> identity value.  Below is the sp. Can anyone see what is wrong?  Thanks.

>>> CREATE PROCEDURE [dbo].[rfp_insProperty]

>>> (@Address nvarchar(100),

>>> @BuildingName nvarchar(100) = NULL,

>>> @BuildingPark nvarchar(50) = NULL,

>>> @Submarket varchar(100) = NULL,

>>> @City nvarchar(40) = NULL,

>>> @State varchar(2) = 'WI',

>>> @ZipCode varchar(50) = NULL,

>>> @County varchar(50) = NULL,

>>> @GroupCode char(1) = NULL,

>>> @LeaseSaleCode char(1) = NULL,

>>> @newPropID int output)

>>> AS

>>> BEGIN

>>> -- SET NOCOUNT ON added to prevent extra result sets from

>>> -- interfering with SELECT statements.

>>> SET NOCOUNT ON;

>>> -- Insert statement for creating Pproperties record

>>> INSERT INTO [RFPData].[dbo].[Properties]

>>> ([Address], [BuildingName], [BuildingPark], [Submarket], [City],
>>> [State], [ZipCode], [County], [GroupCode], [LeaseSaleCode])

>>> VALUES

>>> (@Address, @BuildingName, @BuildingPark, @Submarket, @City, @State,
>>> @ZipCode, @County, @GroupCode, @LeaseSaleCode);

>>> SELECT @newPropID = CAST(SCOPE_IDENTITY() AS int);

>>> END

>>> David