Adding a New Row into a MS SQL Database Using ADO.NET

Question

Hello!

I am looking for the simplest way to push a new row to a database by inserting one record and then retrieving the Primary Key generated by inserting that row.

I know there are several ways this can be done but I can't seem to get any of them to work yet.

Thank you in advance for any advice you can give me.

Patrick

Answer 1

Did you try the below method?

Retrieving Identity or Autonumber Values (ADO.NET)

---

Paul ~~~~ Microsoft MVP (Visual Basic)