Inserting a Row - Returning the ID

[AJ123]

Hi There This has got to be an easy one... I am coming to ADO.NET from an ADO background, so i appologise if it comes across as totally stupid! All i want to do is insert a new row into a table and pull back the autonumber primary key assigned to it. What i don't want to have to do is: 1) Fill a Dataset in order to get a DataTable definition. 2) Use stored procedures. Anybody know the answer off the top of their head? Guess i really need to buy a good ADO.NET book. Thanks In Advance Rich

[AJ123]

Found my answer :- There is a good discussion of this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/manidcrisis.asp[^]