moving average calculations in Dataset Datatable

Question

0.00/5 (No votes)

See more:

Is there any way to do moving average calculations in Dataset Datatable. Is this the best option for calculating moving average calculations by using C sharp? what i am thinking is Datatable looks like excel, because of i am very familier with Excel and vba macros i think this is the best options. I am just beginer in C sharp i don't know other options, so anyone have any information about it, it will very helpful for me. And thanks in advance for your time.

Posted 10-Dec-11 19:21pm

anilkeettikal

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Monjurul Habib · Accepted Answer · 2011-12-10T19:41:00

Solution 2

Read the following links:
Do more with a DataTable and improve performance
Using DataTables More for Improving Performance

Hope you will get your idea from the above links.

Posted 10-Dec-11 19:41pm

Monjurul Habib

Comments

Abhinav S 11-Dec-11 1:42am

My 5! However, can even think about calculating the averages at query level.

Monjurul Habib 11-Dec-11 2:11am

yes this is actually worthwhile, anyway thanks for your vote.

thatraja 11-Dec-11 7:26am

Agree with Abhinav, 5!

Monjurul Habib 11-Dec-11 7:45am

thank you RAJA

Abhinav S · Accepted Answer · 2011-12-10T19:42:00

Solution 3

You could write an extension method that can be called on the datatable and does the calculations.
You don't really need to do calculations on the datatable itself.

On the other hand, it might actually be worthwhile to calculate the moving averages at the query level as well.

Posted 10-Dec-11 19:42pm

Abhinav S

Comments

Monjurul Habib 11-Dec-11 2:10am

my 5!

Abhinav S 11-Dec-11 2:11am

Thank you.

thatraja 11-Dec-11 7:25am

Right, 5!

Abhinav S 11-Dec-11 7:26am

Thank you thatraja.

anilkeettikal 11-Dec-11 12:01pm

Can you give an example or link how i could do it in query level?

Abhinav S 11-Dec-11 12:18pm

This might help you - http://oreilly.com/catalog/transqlcook/chapter/ch08.html.
Definitely worth a look. Goes into my bookmarks.

Incidentally mark this question as answered if these answers help you.