Hi,
I am new in ASP.NET.
Is there a way to get the identity ID from a SQL table after insert a record?
I have those 3 lines of code I am using to insert user into a table, and this table has a column called ID as its identity column.
Dim comm As New Odbc.OdbcCommand("insert into tbl_User (name) values ('User1')", conn)
comm.CommandType = CommandType.Text
comm.ExecuteNonQuery()
I am new in ASP.NET.
Is there a way to get the identity ID from a SQL table after insert a record?
I have those 3 lines of code I am using to insert user into a table, and this table has a column called ID as its identity column.
Dim comm As New Odbc.OdbcCommand("insert into tbl_User (name) values ('User1')", conn)
comm.CommandType = CommandType.Text
comm.ExecuteNonQuery()