display last ID from bank in label

ghasem deh

12y1.3kVisual Basic .NET

hi guy's
how to show last (maximum) ID from table (access database) in label on the Form ...

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
In that case I think I'd forget the LAST() function and use the same query as we'd use if this were SQL Server rather than Access (Hemant's post above).

So I'd try:

con.Open();
string str;
str = "SELECT TOP 1 Num FROM Pic ORDER BY Num DESC;";
com = new OleDbCommand(str, con);
OleDbDataReader reader = com.ExecuteReader();
reader.Read();
label1.Text = reader["Num"].ToString() + " Number";
ghasem deh12y ago
yes ... tank's :)
ghasem deh12y ago
hi dear Vulpes ... i done it ... butt no change ! just read num 1 ---> table have 7 field (1,2,3 ... 7)
Vulpes12y ago
Try replacing this line:

label1.Text = reader["Num"].ToString() + " Number";

with this one:

label1.Text = reader[0].ToString() + " Number";
ghasem deh12y ago
tanks guy's ...
first use this code :
            con.Open();
            string str;
            str = "SELECT Num FROM Pic;";
            com = new OleDbCommand(str, con);
            OleDbDataReader reader = com.ExecuteReader();
            reader.Read();
            label1.Text = reader["Num"].ToString() + " Number";
butt display number 1 from table ... i want display last number !
now use this code :
            con.Open();
            string str;
            str = "SELECT LAST(Num) FROM Pic;";
            com = new OleDbCommand(str, con);
            OleDbDataReader reader = com.ExecuteReader();
            reader.Read();
            label1.Text = reader["Num"].ToString() + " Number";
error in last line:
( Index Out Of Rang Exception Was Unhandled)
Ramesh Maruthi12y ago
Ya I know that Hemanth, thats what he mentioned in the question as access database :)
Hemant Srivastava12y ago

Ramesh, Last() works only in MS Access but not in SQL Server, MySQL, Oracle.
So the alternative of LAST() is :
SELECT TOP 1 column_name FROM table_name
ORDER BY column_name DESC;
If it helps you, please accept the answer.
Ramesh Maruthi12y ago
SELECT LAST(column_name) FROM table_name;
Dipankar Biswas12y ago
http://stackoverflow.com/questions/6746541/find-highest-number-in-ms-access-database-using-c-sharp