How to get the Id of something i currently inserted into access db
c#, ms-access, sql
Solution
See the MSDN article here. In MS Access, you'll want to `SELECT @@IDENTITY` within the scope of the statement which inserted the record.
Problem
i found many answers to this question for other databases, but didn't found any answer for Microsoft access. I have a table that has the following columns : ID A B C the id is auto number , how do i get the ID of a row i just inserted. btw : i'm using C# thanks