Get max column value : OleDbCommand « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. OleDbCommand

Get max column value

using System;
using System.Data;
using System.Data.OleDb;

public class DatabaseInfo {    
 public static void Main () { 
   String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb";
   OleDbConnection con = new OleDbConnection(connect);
   con.Open();  
   Console.WriteLine("Made the connection to the database");

   OleDbCommand command = con.CreateCommand();
   command.CommandText ="SELECT MAX(Salary) FROM Employee";
   Console.WriteLine("Max of salary: {0:C}",(decimal)command.ExecuteScalar());
   con.Close();
 }
}
 

           
       

Related examples in the same category

1.	Execute aggregate function: sum
2.	Get column average
3.	Get count value from a select query
4.	Between certain dates
5.	Delete database records through OleDbCommand and verify the results
6.	Create table and populate data
7.	Pass parameter to OleDbCommand
8.	How to execute a TableDirect command