Retrive PrimaryKey Value after insertion

See more:

C#

MySQL

Hello ,
I Have Problem of retrieving Auto-incremented Primary Key Value after Insertion...
Can not Use MAX because if during the retrieving two or more results are inserted then it will returns false value..


For Example I Use Following Query :

INSERT INTO OrderDetail (OrderName, OrderAddress, OrderCity, OrderState, OrderCountry, OrderPincode, OrderContact1, OrderContact2, OrderEmailid, Cost, Total)Values (......)

Then I Want to Retrieve The OrderID which is Primary Key and also auto-increment in table OrderDetail


So please help me...