Select in DataSets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry - 12 Jul 2007 15:04 GMT

Hi

I want to select specific records in a DataSet

eg ds.Tables[0].Select("Max(Volume)");

Voulme is the ColumnName, i need the record(s) with Max in Volume Column.

the above throws an error at runtime, is there a wayout.

TIA
Barry

Reply to this Message

Braulio Diez - 16 Jul 2007 08:40 GMT

Hello,

Have you tried ?

"Volume=Max(Volume)"

http://www.dotnet247.com/247reference/msgs/28/143428.aspx

Good luck
Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------

> Hi
>
[quoted text clipped - 8 lines]
> TIA
> Barry

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...