Posted on: 7/3/2015 7:19:49 AM | Views : 699

Hi, 
I am not able to retrieve the record identity from my INSERT statement, Please Advise.
Dim CMDInsrt As New SqlCommand("INSERT INTO [TblReg] (Filenum, Fname, Sname, Tname, Lname, DOB, NatID, SexID, TelNum, FileStat, MarStatID) VALUES (@FileNumTxt, @Fnametxt, @SnameTxt, @TnameTxt, @LnameTxt, @DOBTxt, @NatIDTxt, @SexTxt, @TelNumTxt, @FileStattxt, @MarStattxt) SELECT SCOPE_IDENTITY() AS RecID", ARTSQLCON) CMDInsrt.Parameters.AddWithValue("@FileNumTxt", FileNumTxt.Text) CMDInsrt.Parameters.AddWithValue("@FnameTxt", FnameTxt.Text) CMDInsrt.Parameters.AddWithValue("@SnameTxt", Snametxt.Text) CMDInsrt.Parameters.AddWithValue("@TnameTxt", Tnametxt.Text) CMDInsrt.Parameters.AddWithValue("@LnameTxt", Lnametxt.Text) CMDInsrt.Parameters.AddWithValue("@DOBTxt", DobTxt.Text) CMDInsrt.Parameters.AddWithValue("@NatIDTxt", NatIDTxt.Text) CMDInsrt.Parameters.AddWit ...

Go to the complete details ...