VB.NET 2005 SQL 2005 return ID after insert statement

[Maurice Mertens]

Hello,

how do I insert a new row in a table and get the auto-number field value
back from the database (sql)? I don't have any experience with Stored
Procedures.The next thing I want to do is using a TimeStamp field to check
for concurrency. What would be the best way to do this?

My idea is like this:
1. insert new row into table in dataset.
2. update this change to the database.
3. receive the autonumber field and the timestamp value back from database.
4. reload these returned value into row in dataset.

So when a change is done to this row I know the ID and the TimeStamp value
to check if someone changed the row.

I hope someone knows where to find an example in which this is explained or
can tell me how to accomplish this.
Thx!