ashraf_t
asked on
Compute method in dataset
I always use compute function to calculate data in some columns in the output datatable variable, so is there a way i can use if i want for example the sum of the top 10 rows in datatable, can i use compute, i donot want to return to the original table
Thanx
Thanx
Ted Bouskill
The DataSet object actually uses a substantial amount of overhead (memory and CPU) An aggregate operation can even consume more resources. I would strongly recommend you do this in the SQL database.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no i want to use the top 10 in the output data not to the original table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Looping method hmmm, i think this will take time specially if the records are too big
It's either that or do it in the SQL server. You don't have any other choices. The Select() method in the DataTable doesn't support aggregate functions.
I manage 5 software developers building web applications. I wouldn't allow them to do this in a dataset at all. I'm just trying to answer your question, I don't agree with the strategy.
If you are worried about performance, minimize or avoid using the dataset and use the SqlDataReader instead and define your own collection.
If you are worried about performance, minimize or avoid using the dataset and use the SqlDataReader instead and define your own collection.