ID Row Just Added

[Jack]

Hello,

I have a table like

ID - Int - Primary Key - AutoNumber
Test_Tile - NVARCHAR

I am Using the following code to add a row.

Dim con As New SqlConnection(SQLConnectString)
Dim cmd As New SqlCommand("INSERT INTO Test(Test_Title)
VALUES(@sTest_Title)", con)
Dim pTest_Title As New SqlParameter("@sTest_Title", SqlDbType.varchar, 50,
ParameterDirection.Input, False, 0, 0, Nothing,
DataRowVersion.Current,"Test")
cmd.Parameters.Add(pTest_Title)
con.Open()
cmd.ExecuteNonQuery()
con.Close()

I would like to be able to get the ID of the newly created row.

Any help would be great!!

Thanks,

Jack

 

[Cor Ligthert]

Jack,

To get the last Id is very easy,

The most simple way is using the Select @@identity from table and than get
that with executescalar.

Bill made a complete article from that.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/manidcrisis.asp

If it is not an existing table, take than in mind to use Guid's for your
unique identifiers, that will probably save you a lot of trouble.

I hope this helps,

Cor

 

[Jack]

Thanks!!!!