plusplus 0 Posting Whiz in Training

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.