How to get average of column of grid in case of null entry?

Muhammad Shah

I want to get the sum and also the average of GridView column .If there is any "null" entries in the column then it is not give me the sum.

int i = 0;
int j = 0;
int sum = 0;
try
{
for (i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (j = 0; j < dataGridView1.Columns.Count; j++)
{
sum = sum + (Convert.ToInt32(dataGridView1.Rows[i].Cells[j].Value));
}
}
MessageBox.Show("sum"+sum);
}

I want to get average of the column and then place it in the null value cell.

any body help me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raghav Jhavar10y ago
Hi,

Suppose your column number you want to get sum of and average is '1':

You can do:

int sum = 0;
int avg = 0;
int rowCount = 0;

//this part calculates sum
foreach(DataGridViewRow DR in dataGridView1.Rows)
{
sum = sum + dataGridView1.Cells[1].Value;
}
Console.WriteLine(sum);

//this part calculates average
foreach(DataGridViewRow DR in dataGridView1.Rows)
{
    rowCount += 1;
}
avg = sum / rowCount;
Console.WriteLine(avg);

//place average in null cell
foreach(DataGridViewRow DR in dataGridView1.Rows)
{
if(dataGridView1.Cells[1].Value == null)
   {
     dataGridView1.Cells[1].Value = avg;
                break;
}
}
0
Ranjit Powar10y ago
try
{
for (i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (j = 0; j < dataGridView1.Columns.Count; j++)
{
if(dataGridView1.Rows[i].Cells[j].Value!=null)
{
sum = sum + (Convert.ToInt32(dataGridView1.Rows[i].Cells[j].Value));
}
}
}
MessageBox.Show("sum"+sum);
}
0