average of columns

Question

Can somebody tell me how I can calculate the average of the columns in c#??

Bechir Bejaoui · Answer

Inspite of it's old you can get the column average in a single line of code using the 10th formulat look again on the article. The essencial is the efficiency and not the old my freind ;-}

Ryan Alford · Answer

c'mon Bechir, this topic is over 4 years old.

Bechir Bejaoui · Answer

Read this article it will clear several things for you http://www.c-sharpcorner.com/UploadFile/yougerthen/102162008174917PM/1.aspx

aylin_sk · Answer

Ok I'll try to write...If something is wrong, I'll write you back :) Cheers.. Aylin

eyes · Answer

Hi, U've to write this where u need the average ? ? ? Also add appropriate database connection string and select query . . . Please check this code. I didn't run this . . . Hope it is correct ? ? ? Cheers, Kanna . . .

aylin_sk · Answer

Kanna hi, After I wrote this code, will I write datasource code like this?? string connectionString = "" ; // Please enter the connection string . . . System.Data.Odbc.OdbcConnection connection = new System.Data.Odbc.OdbcConnection ( connectionString ) ; System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand ( ) ; command.Connection = connection ; System.Data.Odbc.OdbcDataAdapter adapter = new System.Data.Odbc.OdbcDataAdapter ( command ) ; adapter.SelectCommand.CommandText = "" ; // Please enter the SQL SELECT command string . . . System.Data.DataSet dataSet = new DataSet ( ) ; adapter.Fill ( dataSet ) ; dataGrid1.DataSource = dataTable ; // To set the data source to datagrid . . . Then we can find the average by, decimal sum = 0 ; for ( int i=0; i<dataTable.Rows.Count; i++ ) { sum = sum + Convert.ToInt32 ( dataTable.Rows[i]["Numbers"] ) ; } decimal average = sum / dataTable.Rows.Count ; RIGHT??

aylin_sk · Answer

Can someone tell me the small differences between DataSet, DataView, DataGrid, DataTable, DataList??I am confused sometimes..

aylin_sk · Answer

Thanks again so much..:)

eyes · Answer

Hi, Yes. I think U'll get the values as rows and columns from the oracle database as a DataSet or a DataTable and then set set those to the DataGrid . . . So U can use that DataSet or DataTable ( which U used as a DataSource for the DataGrid ) directly, not the datagrid . . . I think Ur using Odbc, so the code MAY look like this . . . string connectionString = "" ; // Please enter the connection string . . . System.Data.Odbc.OdbcConnection connection = new System.Data.Odbc.OdbcConnection ( connectionString ) ; System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand ( ) ; command.Connection = connection ; System.Data.Odbc.OdbcDataAdapter adapter = new System.Data.Odbc.OdbcDataAdapter ( command ) ; adapter.SelectCommand.CommandText = "" ; // Please enter the SQL SELECT command string . . . System.Data.DataSet dataSet = new DataSet ( ) ; adapter.Fill ( dataSet ) ; Now u can use this dataSet or dataSet.Tables[0] as a data source for the data grid . . . Cheers, Kanna . . .

aylin_sk · Answer

Kanna by the way if these datargid values are coming from Oracle db,then there is no need to create a datatable right??

aylin_sk · Answer

So muucchh thanksss Kanna!!:)

aylin_sk · Answer

For example in a datagrid, I have columns...And inside one column there are lots of numbers(values)..I want to find the average of these numbers..Give me an example..

pchandekar · Answer

Do you want to calculate average of the columns or want to count the number of columns ? Still why do you need average of DataGrid columns ?

eyes · Answer

Hi, Hope, u are set the values in the datagrid through any one of the DataSource. For example DataTable or DataSet or etc . . . So through that DataSource itself u can calculate what u want . . . Once u change the values in the datagrid during runtime, it is updated in the data source also . . . So u can use it . . . Example: Let us consider a DataTable as a data source . . . First let we create a DataTable object with some values . . . DataTable dataTable = new DataTable ( ) ; dataTable.Columns.Add ( "Numbers" ) ; DataRow dr = null ; dr = dataTable.NewRow ( ) ; dr[ "Numbers" ] = 3 ; dataTable.Rows.Add ( dr ) ; dr = dataTable.NewRow ( ) ; dr[ "Numbers" ] = 5 ; dataTable.Rows.Add ( dr ) ; dr = dataTable.NewRow ( ) ; dr[ "Numbers" ] = 8 ; dataTable.Rows.Add ( dr ) ; dataGrid1.DataSource = dataTable ; // To set the data source to datagrid . . . Then we can find the average by, decimal sum = 0 ; for ( int i=0; i<dataTable.Rows.Count; i++ ) { sum = sum + Convert.ToInt32 ( dataTable.Rows[i]["Numbers"] ) ; } decimal average = sum / dataTable.Rows.Count ; Hope this helps ! ! ! Cheers, Kanna . . .

aylin_sk · Answer

yeah datagrid columns.... aylin

eyes · Answer

Hi, Sorry I didn't get u . . . What u mean by "columns". Is it datagrid columns or any other . . . Cheers, Kanna

average of columns

Answers (16)