Get Key of SQL Insert

Hello everyone,

I have a SQL query in a data source, and some VB code posted below - as I understand it, the query should give me the primary key value of the record that was just inserted.  Currently I get a 1 every time!

Someone please help me out and let me know where I have gone wrong.

Thanks!

VB CODE:
Dim RMSAdapter As New RMSTableAdapters.ComputersTableAdapter
Dim NewComputer As Integer = Convert.ToInt32(RMSAdapter.InsertWithIDPassback(Request.QueryString("CustomerID"), Me.TxtNickName.Text, Me.TxtType.Text, Me.TxtMake.Text, Me.TxtModel.Text, Me.TxtMfgInfo.Text))
 
SQL CODE IN DATATABLE:
INSERT INTO Computers(OwnerCustomerID, NickName, ComputerType, ComputerMake, ComputerModel, MfgTagInfo)
VALUES        (@OwnerCustomerID,@NickName,@ComputerType,@ComputerMake,@ComputerModel,@MfgTagInfo);  
 
SELECT SCOPE_IDENTITY()

Select allOpen in new window