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 ...