Skip to main content

datatable compute sum in c# | datatable compute() function

By

datatable compute sum in c# | datatable compute() function

Hi Readers, Today I am going to explain you the use of compute() function of Data table using C#.NET. 

Let's begin..

datatable compute sum in c# ,calculate sum of datatable column c# , datatable column sum c#,datatable compute,c# datatable column average,find minimum value in datatable,find max value in datatable column c#
datatable column sum in c#

datatable compute sum in c# | datatable compute() function


Let's say that we have the following rows filled in the Data table with the columns ID,NAME,AGE and SALARY as shown in snapshot below:-

datatable compute sum in c# ,calculate sum of datatable column c# , datatable column sum c#,datatable compute,c# datatable column average,find minimum value in datatable,find max value in datatable column c#
employees detail in datatable



In order to calculate the figures like total of salary, average of salary, maximum salary and minimum salary, we can use the compute() function of the Data table.

The compute() function loops through each value of the column's cell and then perform the calculation.

For the above data table's salary column, lets find the total, average, maximum and minimum of salary one by one using compute() function:-

datatable compute sum in c# | datatable compute() function

  1. Calculate the total of salary:  
To calculate the total of the salary, we need to have the following lines of code in C#.NET:

decimal salaryTotal=0;
salaryTotal = Convert.ToDecimal(dtEmployee.Compute("SUM(SALARY)", string.Empty));
dtEmployee.Rows.Add(DBNull.Value,"TOTAL:-",DBNull.Value,total);

The above code on execution will calculate the total and add the calculated total in the last row as shown in snapshot below:

datatable compute sum in c# ,calculate sum of datatable column c# , datatable column sum c#,datatable compute,c# datatable column average,find minimum value in datatable,find max value in datatable column c#
employees detail with total salary
As shown in the above snapshot, the last row is added using Add() function of Data table showing the total of salary column.


The compute() function takes 2 arguments, one to calculate the total of the salary column as "sum(salary)" and second as "string.Empty" which filters the value of the salary column i.e. it will avoid the cell having no value in it. The value may be an empty string or null value.

         2. Calculate the average of salary:

To calculate the average of the salary, we need to have the following lines of code in C#.NET:

decimal averageSalary=0;
averageSalary=Convert.ToDecimal(dtEmployee.Compute("avg(SALARY)",string.Empty));
dtEmployee.Rows.Add(DBNull.Value,"Salary Average:-",DBNull.Value, averageSalary);

The above code on execution will calculate the average and add the calculated average in the last row as shown in snapshot below:

datatable compute sum in c# ,calculate sum of datatable column c# , datatable column sum c#,datatable compute,c# datatable column average,find minimum value in datatable,find max value in datatable column c#
employees detail with average of salary

The compute() function takes 2 arguments to find the average of salary. 
The first argument "avg(salary)" find the average of salary among the different values of the salary column.             
The second argument is passed as "String.Empty" which will avoid calculation of the cell having value as empty string or null value as cell having such value will generate run time error during execution.

       3. Find the maximum/highest salary:

To find the max of the salary column of the Datatable , we need to have the following lines of code in C#.NET:

decimal maxSalary=0;
maxSalary=Convert.ToDecimal(dtEmployee.Compute("max(SALARY)", string.Empty));
dtEmployee.Rows.Add(DBNull.Value,"Max Salary:-", DBNull.Value, maxSalary);

The above code on execution will find the maximum or highest salary and add it to  the last row as shown in snapshot below:

datatable compute sum in c# ,calculate sum of datatable column c# , datatable column sum c#,datatable compute,c# datatable column average,find minimum value in datatable,find max value in datatable column c#
employees detail with the maximum salary in the last row

The compute() method takes 2 arguments to find the maximum of salary. 
The first argument "max(salary)" find the maximum or highest salary among the different values of the salary column.      
The second argument is optional and  can be passed as "" but it will give error message when there will be an empty string or null value in the salary column. 
So to avoid such value, we need to pass the second argument as "String.Empty" so that such value can be avoided.

          4. Find the minimum/lowest salary:

To find the minimum of the salary column of the above Data table , we need to have the following lines of code in C#.NET:

decimal minSalary=0;
minSalary=Convert.ToDecimal(dtEmployee.Compute("min(SALARY)",string.Empty));
dtEmployee.Rows.Add(DBNull.Value,"Minimum Salary:-",DBNull.Value, minSalary);

The above code on execution will find the minimum or lowest salary and add it to  the last row as shown in snapshot below:

datatable compute sum in c# ,calculate sum of datatable column c# , datatable column sum c#,datatable compute,c# datatable column average,find minimum value in datatable,find max value in datatable column c#
employees detail with the minimum salary in the last row
The above code works the same way as that of the maximum of the salary code. 
The only difference is that we need to pass the first argument as "min(salary)". 
That's it and we will get the lowest salary among all the rows.

Therefore if we summaries the use of the compute() function, we can conclude that -
    "compute() function is used to find the":-
  1. Total.
  2. Average.
  3. Maximum.
  4. Minimum.
That's it!!!

Hope you have enjoyed by programming the above code in your project. 
Please comment if you have any query regarding the above coding. 
And share with your co-programmers to help them out in coding. 
  
Enjoy Coding!!!!

LIKE COMMENT & SHARE
Labels:

Comments

Post a Comment

Popular posts from this blog

Generics

By SHANTILAL
Reusability in C#: C# lets you  reuse  code in two major ways: Inheritance Generics Let’s look at each: 1.  Inheritance: Inheritance is an  object-oriented  concept. You write a  base class  and then extend it to create more  specific classes . Example:      class Animal       {            public void Eat() { Console.WriteLine("Eating..."); }      }      class Dog : Animal       {            public void Bark() { Console.WriteLine("Barking..."); }      }      // Reusing code via inheritance     Dog d = new Dog();     d.Eat(); // From Animal     d.Bark(); // From Dog ✅  Pros : Useful when classes share common behavior. ❌  Cons : Less flexible when working with  types  (like  int ,  string , etc.) 2.  Generics: Gen...
Post a Comment
Read more

C# Dictionary

By
> In this post, we will see how to use a dictionary in C#. > A dictionary in C# is used to store collection of values with key values as pair. > So whenever user wants to get the value then he will have to pass the key value to the dictionary and it will return the value to the user. > The namespace of the C# dictionary is System.Collections.Generic. > Let’s take a simple example of storing digits from 0 to 9 as key value and these digits in the word form as the collection values. > Here, the user will type a digit from 0 to 9 and on clicking the button, it gives the digit in the word form. > To keep this example simple, here the dictionary will be having digits from 0 to 9 only and if user enters a value less than 0 or greater than 9 then he will get the appropriate message. > Following is the code for demonstrating the use of the Dictionary : HTML Code: <body>    <form id="form1" runat="server">   ...
Post a Comment
Read more