How to get highest value in a column in table in c#.net

Question

Dear all Gud Mrng!!! Here i need to know highest value available in a column of data table.Please help... Thanks&Regards VishnuVardhan D.

Bikesh Srivastava · Answer

Hi Use this query. String qry = select max(EmpSalary) from Emp;

vinit singh · Answer

DataTable dt = ds.Tables[0]; var maxRow = dt.Select(RankNo = MAX(RankNo)); here RankNo is Column

lakshmipathi vemula · Answer

Hithe following code gives the highest value available in a column of data table. class Program { static void Main(string[] args) { String ConnectionString = @Data Source=.\Sqlexpress;Initial Catalog=AdodotnetSamples;User ID=sa;Password=dotnet; SqlConnection con=new SqlConnection(ConnectionString); String qry = select max(EmpSalary) from Emp; SqlCommand cmd=new SqlCommand(qrycon); con.Open(); Console.WriteLine(cmd.ExecuteScalar()); con.Close(); } } Now console window shows the highest value. to know more about the .NETfollow the link http://www.bestdotnettraining.com/User/TrainingCourses.aspx

Vulpes · Answer

You could also do it without creating an aggregate column in your database. Suppose you want to calculate the maximum value of an int column 'Id' in a DataTable 'dt': DataView dv = dt.DefaultView; dv.RowFilter = Id = Max(Id); int max = (int)dv[0][Id]; MessageBox.Show(max.ToString());

vishnuvardhan diyyala · Answer

I got answer by using the bellow query column data type is varchar SELECT MAX(TO_NUMBER(ColumnName)) AS ColumnName FROM TableName then i got the highest value in the specified column.