how to get the highest value (not max value), in a dataset or database in vb

E

exsavior10

Joined
Mar 5, 2011
Messages
1
Reaction score
0
for example i entered the following in the database columns are (student_id,name,course):

student_id - 2011001, name - john, course - computer science

then

student_id - 2011002, name - jane, course - business management

how can i get jane's student_id without using the name and course columns?

and not using this method

sam = New SqlDataAdapter("Select student_id from studtable where student_id = " & 2011002 & "" con) of something like that...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get the value with the highest ID number 6
Formula to Find Max in a Row and Return Column Title 4
Highest value for a field 2
How to get the max value??? 11
How to databind a dropdownlist in a datagrid 2
How to map all changes of a dataset to the original database? 1
how to save a dataset back to the database 1
how to move all info in column a to seperate columns 1

Top