get last inserted id

hi ...
i cant not done ....

con.Open();
            str = "select Num from Pic";
            com = new OleDbCommand(str, con);
            OleDbDataReader reader = com.ExecuteReader();
            reader.Read();
            label1.Text = reader["Num"].ToString() + "  Num";

this show num 1 ...
how change to get last num ....
please help !

You have already got answer of your problem but following link would be helpful for you in future to get clear idea about how can get last inserted id.

Interview Question: What are the Differences between @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT()[^]

try the below codes:

SELECT MAX(id) FROM [tablename]

OR

SELECT TOP 1 id FROM [tablename] ORDER BY id DESC

OR

--INSERT STATEMENT HERE
SELECT @@IDENTITY

Regards,
Eduard