ADO.NET - Inserting a row and getting the ID
-
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
-
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
You might get a faster answer if you post this question on the ADO.NET board instead of the C# board.
-
You might get a faster answer if you post this question on the ADO.NET board instead of the C# board.