get last ID from database access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ghasem
    New Member
    • Aug 2014
    • 1

    #1

    get last ID from database access

    hi
    i use this code :

    Code:
    str1 = "select ID from Album";
                com = new OleDbCommand(str1, con);
                OleDbDataReader reader1 = com.ExecuteReader();
                reader1.Read();
                label2.Text = reader1["ID"].ToString() + "   picture";
    butt read ID number 1 ... i want get last ID ?
    please help !
    Last edited by Rabbit; Aug 13 '14, 04:22 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
Working...