Mega Code Archive

 

Categories / C# / ADO Database

 

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();  } }