how to get row number from DataTable.Compute method

E

eliza

Compute is one of the methods of DataTable class. This method computes an expression on the current rows that pass the filter criteria.

Syntax
Object DataTable.Compute(string expression , string filter)

Expression - The expression to compute.
Filter - The filter to limit the rows that evaluate in the expression.

This method's return type is System.Object. So, you have to cast it with appropriate data type.

The following operations can be passed through as expression parameter.
Sum -> Sum
Average -> Avg
Minimum -> Min
Maximum -> Max
Count -> Count
Statistical standard deviation ->StDev
Statistical variance -> Var

http://www.mindfiresolutions.com/DataTable-Compute-Method-628.php



AboutJA wrote:

how to get row number from DataTable.Compute method
12-Mar-07

how do you get the row number from the DataTable Compute() method

Thanks

Previous Posts In This Thread:

how to get row number from DataTable.Compute method
how do you get the row number from the DataTable Compute() method

Thanks


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint List Usage and Statistics
http://www.eggheadcafe.com/tutorial...d-9723a79fdb14/sharepoint-list-usage-and.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dataTable.Compute("Count(GuidCol)", "") generates Exception 4
More than one aggregate function in datatable.compute. 1
DataTable.Compute() question 5
Group By in DataTable? 4
Defining a block of consecutive rows in a datatable 8
datatable.compute method 1
Datatables Compute Count(xxxx) with filters using Guid datatype error 0
DataTable.Compute() Result type 6

Top