retrieve highest number from dataset

[Grant]

Hello,

How would I get the highest number from a column? The table has an ID column
but it does not auto imcrement and I have to do it manually so I need to get
the hihest integer value and increment it by one before adding data to the
dataset.

Thanks,
Grant

 

[William Ryan eMVP]

You can use DataTable.Compute(Max(IDColumn), "IDColumn> -1")

The filter is BS, it's just a condition that will always be false.

HTH,

Bill

www.devbuzz.com
www.knowdotnet.com

 

[Grant]

Thanks for your reply - Ill give it a go.

You can use DataTable.Compute(Max(IDColumn), "IDColumn> -1")

The filter is BS, it's just a condition that will always be false.

HTH,

Bill

www.devbuzz.com
www.knowdotnet.com

 

[Grant]

Thanks Bill that works.

You can use DataTable.Compute(Max(IDColumn), "IDColumn> -1")

The filter is BS, it's just a condition that will always be false.

HTH,

Bill

www.devbuzz.com
www.knowdotnet.com