Retrieve The ID Of The Record Just Added

I would like to retreive the identity field value of a record that was just added to the table.





In other words, I have a form and on submission, if it is a new record, I would like to know the identity value that the SQL Server has assigned it.





This may be overkill, but here is my code to process the form:





Protected Sub processForm(ByVal thisID As String, ByVal myAction As String)


Dim sqlConn As New SqlConnection(ConfigurationSettings.AppSettings("connectionString"))


sqlConn.Open()


Dim sql As String


Select Case myAction


Case "save"


If thisID > 0 Then


sql = "update INCIDENT set " & _


"RegionID = @RegionID, " & _


"DistrictID = @DistrictID, " & _


"DateReported = @DateReported, " & _


..CODE...


"WHERE IncidentID = " & myIncidentID


Else


sql = "insert into INCIDENT(" & _


"RegionID, " & _


"DistrictID, " & _


"DateReported, " & _


...CODE...


") " & _


"values(" & _


"@RegionID, " & _


"@DistrictID, " & _


"@DateReported, " & _


...CODE...


")"


End If


Case "delete"


sql = "delete from INCIDENT where IncidentID = " & myIncidentID


Case Else


End Select





Dim sqlComm As New SqlCommand(sql, sqlConn)


sqlComm.Parameters.Add(New SqlParameter("@RegionID", SqlDbType.NVarChar))


sqlComm.Parameters.Add(New SqlParameter("@DistrictID", SqlDbType.NVarChar))


sqlComm.Parameters.Add(New SqlParameter("@DateReported", SqlDbType.NVarChar))


...CODE...





sqlComm.Parameters.Item("@RegionID").Value = ddRegionID.SelectedValue


sqlComm.Parameters.Item("@DistrictID").Value = ddDistrictID.SelectedValue


sqlComm.Parameters.Item("@DateReported").Value = db.handleDate(txtDateReported.SelectedDate)


...CODE...





Dim myError As Int16 = sqlComm.ExecuteNonQuery


'Response.Redirect("incident.aspx?id=" & )


End Sub





The response.redirect at the end of the sub is where I would like to put the identity field value.