How to calculate the sum of the datatable column in asp net

Question

I have a DataTable which has 5 columns    ID Name Account Number Branch  Amount   The DataTable contains 5 rows   How can I show the sum of the Amount Column in a Label Control as  Total Amount

User · Accepted Answer

To calculate the sum of a column in a DataTable use the DataTable.Compute method.

Example of usage from the linked MSDN article:

DataTable table = dataSet.Tables["YourTableName"];

// Declare an object variable.
object sumObject;
sumObject = table.Compute("Sum(Amount)", string.Empty);

Display the result in your Total Amount Label like so:

lblTotalAmount.Text = sumObject.ToString();

User · Answer

You can do like    DataRow   dr   dtbl Select  SUM Amount     txtTotalAmount Text   Convert ToString dr 0

User · Answer

I think this solves  using System Linq     datagridview1 DataSource as DataTable  AsEnumerable   Sum c   gt  c Field lt double gt   valor

User · Answer

this LabelControl Text   datatable AsEnumerable        Sum x   gt  x Field lt int gt   Amount         ToString      If you want to filter the results    this LabelControl Text   datatable AsEnumerable        Where y   gt  y Field lt string gt   SomeCol       foo        Sum x   gt  x Field lt int gt   MyColumn          ToString

User · Answer

Try  this   int sum   0  foreach  DataRow dr in dt Rows         dynamic value   dr index  ToString         if   string IsNullOrEmpty value                    sum    Convert ToInt32 value

User · Answer

Compute Sum of Column in Datatable   Works 100   lbl TotaAmt Text   MyDataTable Compute  Sum BalAmt        ToString      if you want to have any conditions  use it like this     lbl TotaAmt Text   MyDataTable Compute  Sum BalAmt     srno 1 or srno in 1 2    ToString

User · Answer

public decimal Total               decimal decTotal  datagridview1 DataSource as DataTable  Compute  Sum FieldName              return decTotal

User · Answer

You Can use Linq by Name Grouping     var allEntries   from r in dt AsEnumerable                               select r  Amount      using name space using System Linq   You can find the sample total subtotal grand total in datatable using c  at Myblog

User · Answer

If you have a ADO Net DataTable you could do  int sum   0  foreach DataRow dr in dataTable Rows       sum    Convert ToInt32 dr  Amount         If you want to query the database table  you could use  Select Sum Amount  From DataTable

[c#] How to calculate the sum of the datatable column in asp.net?

Examples related to c#

Examples related to asp.net

Examples related to user-controls

Examples related to datatable