Execute aggregate function: sum : OleDbCommand « Database ADO.net « C# / C Sharp

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

Execute aggregate function: sum

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


   con.Close();
 }
}
 

           
       

Related examples in the same category

1.	Get column average
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