Can you avg. a column in a datatable?[RESOLVED]

[Nintendo_Wizard]

Hello. Is there a way to avg. a specific column in a datatable then display the results in the datagrid? Also, i am building a reports application. Whats the best feature to use in vb.net that isn't a third party software or add in. I am thinking about using a dataview and then SQL select statements to allow the user to select the report criteria. Much thanks!

Nintendo_Wizard

[Lunatic3]

Select Avg(mytable.mycolmn) As clmAvg from .....

See some SQL tutorials like this for more help on aggregate functions.

There is an article on printing in .NET available in MSDN.

[Nintendo_Wizard]

Thanks Lunatic3! That SQL site helped out alot! I was leaving off the ; at the end. One quick question, you could save me alot of trial & error. How do I assign the AVG- value to a new row in a datagrid. If that's not possible how can I assign it to a label? Thanks for all your help!

[Lunatic3]

Well it needs that you have some basic knowledge ADO.NET and various data providers for windows forms in VB.NET. To put it in a nutshell you may add a DATAADAPTER to your form, generate a DATASET and then work with the data in the dataset. Your dataadapter select statment may include that avg function. I strongly recommend you to take a look at MSDN for further information on how to work with databases in .NET

[Nintendo_Wizard]

I'm familar with ADO.net. I think I can figure it out. Thanks.