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

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

Get column average

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 AVG(Salary) FROM Employee";
   Console.WriteLine("Average of salary: {0:C}",(decimal)command.ExecuteScalar());


   con.Close();
 }
}
 
           
       

Related examples in the same category

1.	Execute aggregate function: sum
2.	Get max column value
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