Selecting one field from the MAX?

[andycharger]

Hi all.

Im trying to get the id of a record I have just added in my database. As it will be the last record im doing:-

 

"select max from errors"

 

Trouble is, im not sure how to get the field I want from the record!!!

 

For example, I can get an entire row back, stick it in a sqldatareader and put it in a datagrid.

 

But that is not what I want. I dont want to put it in a datagrid, I just want to get the ID of the row and assign it to a variable so I can reuse it.

Can someone show me how I do this?

 

Cheers.

 

Andy

[PlausiblyDamp]

rough and ready but will show you how - works with northwind but should be easy to adapt to any database.

 

Dim conn As New SqlClient.SqlConnection("Data Source=(local);Initial Catalog=Northwind;Integrated Security=true")
conn.open()
Dim cmd As New SqlClient.SqlCommand()
cmd.CommandText = "SELECT MAX(EmployeeID) From Employees"
cmd.CommandType = CommandType.Text
cmd.Connection = conn
Dim i As Integer = DirectCast(cmd.ExecuteScalar(), Integer)