Checking MAX() of a table in C#

[Banjo Ayorinde]

Hi, I used sql 2005 as my backend. How do i check the MAX(of a field) in a table in from C# codes

[half life]

if one stores data in a DATATABLE it's easy to see that : DataTable DT; DT.Columns.Count;

Have Fun Never forget it

[Ashfield]

I think you want to get the max value of a column from a table in sql server? select max(column_name) from table You run this as an executescalar in your c# hope this helps

Bob Ashfield Consultants Ltd

[leppie]

MAX not SUM.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)