Move to the last row of a table

How to move to the last row of a table in VB.Net

kuntal sarkar
Profile Answers by kuntal sarkar Questions by kuntal sarkar
Mar 2nd, 2008
1
3079

Questions by kuntal sarkar answers by kuntal sarkar

Showing Answers 1 - 1 of 1 Answers

Behamcraq
Profile Answers by Behamcraq

May 3rd, 2008

If any one want to get the last row it simple:

Try
Dim cmd As New SqlCommand
cmd.CommandText = "SELECT Max(Tour_ID) FROM Tours"
cmd.CommandType = CommandType.Text
cmd.Connection = sconnect
sconnect.Open()
Label20.Text = cmd.ExecuteScalar()
Catch ex As SqlClient.SqlException
Finally
sconnect.Close()
End Try

in this example we have selected the last row and actually we have output it into the form by using label20.text

I hope it will be help full for you