I am building an applicationt that I need to insert data and then return the ID of the inserted record.
an examples of my code looks similar to this..
dim param as new sqlparameter("@risk", sqldbtype)
(there a number of parameters)
riskID = cint(sqlcmd.executescalar)
It is inserting the data, and returning the ID value...
however, its inserting it twice and returning the ID once... any suggestions?