I have been searching for a solution for this, but all the things I've found do not apply to my problem, so I am giving all the details, and please someone help me
I am using access database
I am using typed datasets as my DAL
I am using objectdatasource with my typeddataset
When inserting a new record (with objectdatasource) using the typed dataset insertstatement I want to get the autonumber of the last inserted record. How do I do this?