select max inside a dataset table

  • Thread starter Thread starter Uzi Baruch
  • Start date Start date
U

Uzi Baruch

Hi!

is there a way to do a select max on a field inside a dataset datatable ?

Thanks,
 
Hi,

I don't think you can do a max select but what you can do
is a datatable.Select(expr, sort), sort the field DESC
and then access the first row. Datatable.Select will
return you an array of datarows.

hope this helps
 
Uzi,
Try the Calculate method of the DataTable. See
DataTable.Compute Method in the help files.

Ron Allen
 
You must log in or register to reply here.

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

Strongly typed datasets: Can table adapter handle multiple resultsets? 5
size of a varchar field in SQLserver table 2
DataSet Max Length Compared to Oracle Varchar2 1
DataSet data table name 3
Designing a Dataset 1
How do I measure the size of a dataset? 6
Design Question 3
SQL Table to DataSet to Dataview, to DataSet to XML! 4

Back
Top