C# :: Get ID Value Of Newly Created Row In MySQL Visual Studio

im trying to get the row id created when inserting, ive tried ; SCOPE_IDENTITY(), get_last_identity() adding it to the end of my query string but get nothing back, it doesnt even add row to database. ive also tried adding a stored procedure but it doesnt even have the option in adding that when i right click to add it,(i thinks its because im using microsoft Access MySql)

public static Boolean checkoutOrder(string CustomerEmailId) {
DateTime CreatedDate = DateTime.Now;
DateTime ShippedDateDate = DateTime.Now;
string CustomerId = CustomerEmailId;
OleDbConnection myConnection = GetConnection();

[Code] .....