display last ID from bank in label

Question

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

Vulpes · 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";

Vulpes · Answer

Try replacing this line: label1.Text = reader["Num"].ToString() + " Number"; with this one: label1.Text = reader[0] .ToString() + " Number";

Ramesh Maruthi · Answer

Ya I know that Hemanth, thats what he mentioned in the question as access database :)

Hemant Srivastava · Answer

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 Maruthi · Answer

SELECT LAST(column_name) FROM table_name;

Dipankar Biswas · Answer

http://stackoverflow.com/questions/6746541/find-highest-number-in-ms-access-database-using-c-sharp

ghasem deh · Answer

yes ... tank's :)

ghasem deh · Answer

hi dear Vulpes ... i done it ... butt no change ! just read num 1 ---> table have 7 field (1,2,3 ... 7)

ghasem deh · Answer

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)

display last ID from bank in label

Answers (9)