«

I would like to sum a column in my dataset and have it displayed at the
bottom of the datagrid in the footer. How do I do that?

Assuming your datagrid is bound to a dataset, you can do this:

if(e.Item.ItemType == ListItemType.Footer)
{
//sum every column
for(int i = 0; i < e.Items.Count - 1; i++)
e.Item.Cells[i].Text = ds.Tables[0].Compute("Sum([" +
e.Item.Cells[i].HeaderText + "])",String.Empty);

roughly

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"William Gower" <> wrote in message
news:...
>I would like to sum a column in my dataset and have it displayed at the
> bottom of the datagrid in the footer. How do I do that?
>
>

Alvin,
What will be the result if Sum encounters a NULL value? I am assuming IsNull
function is not used in the SQL that populates the dataset.

Thanks,
Prodip

"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
news:...
> Assuming your datagrid is bound to a dataset, you can do this:
>
> if(e.Item.ItemType == ListItemType.Footer)
> {
> //sum every column
> for(int i = 0; i < e.Items.Count - 1; i++)
> e.Item.Cells[i].Text = ds.Tables[0].Compute("Sum([" +
> e.Item.Cells[i].HeaderText + "])",String.Empty);
>
> roughly
>
> --
> Regards,
> Alvin Bruney
> [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
> Got tidbits? Get it here... http://tinyurl.com/27cok
> "William Gower" <> wrote in message
> news:...
> >I would like to sum a column in my dataset and have it displayed at the
> > bottom of the datagrid in the footer. How do I do that?
> >
> >
>
>

i'm not entirely sure but I believe it's gonna blow up like a weapon of mass
destruction. guard the code with a try catch block.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Prodip Saha" <> wrote in message
news:...
> Alvin,
> What will be the result if Sum encounters a NULL value? I am assuming
> IsNull
> function is not used in the SQL that populates the dataset.
>
> Thanks,
> Prodip
>
> "Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
> news:...
>> Assuming your datagrid is bound to a dataset, you can do this:
>>
>> if(e.Item.ItemType == ListItemType.Footer)
>> {
>> //sum every column
>> for(int i = 0; i < e.Items.Count - 1; i++)
>> e.Item.Cells[i].Text = ds.Tables[0].Compute("Sum([" +
>> e.Item.Cells[i].HeaderText + "])",String.Empty);
>>
>> roughly
>>
>> --
>> Regards,
>> Alvin Bruney
>> [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
>> Got tidbits? Get it here... http://tinyurl.com/27cok
>> "William Gower" <> wrote in message
>> news:...
>> >I would like to sum a column in my dataset and have it displayed at the
>> > bottom of the datagrid in the footer. How do I do that?
>> >
>> >
>>
>>
>
>

Thanks Alvin. I wish I could use IsNull function along with the Sum but it
is not allowed on Aggregate functions like Sum.

Prodip

"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
news:%...
> i'm not entirely sure but I believe it's gonna blow up like a weapon of
mass
> destruction. guard the code with a try catch block.
>
> --
> Regards,
> Alvin Bruney
> [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
> Got tidbits? Get it here... http://tinyurl.com/27cok
> "Prodip Saha" <> wrote in message
> news:...
> > Alvin,
> > What will be the result if Sum encounters a NULL value? I am assuming
> > IsNull
> > function is not used in the SQL that populates the dataset.
> >
> > Thanks,
> > Prodip
> >
> > "Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
> > news:...
> >> Assuming your datagrid is bound to a dataset, you can do this:
> >>
> >> if(e.Item.ItemType == ListItemType.Footer)
> >> {
> >> //sum every column
> >> for(int i = 0; i < e.Items.Count - 1; i++)
> >> e.Item.Cells[i].Text = ds.Tables[0].Compute("Sum([" +
> >> e.Item.Cells[i].HeaderText + "])",String.Empty);
> >>
> >> roughly
> >>
> >> --
> >> Regards,
> >> Alvin Bruney
> >> [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
> >> Got tidbits? Get it here... http://tinyurl.com/27cok
> >> "William Gower" <> wrote in message
> >> news:...
> >> >I would like to sum a column in my dataset and have it displayed at
the
> >> > bottom of the datagrid in the footer. How do I do that?
> >> >
> >> >
> >>
> >>
> >
> >
>
>

You can,
use ISNULL(expression, replacementvalue)
as part of the expression and it will make the appropriate replacement. you
can see the msdn docs for a working example

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Prodip Saha" <> wrote in message
news:...
> Thanks Alvin. I wish I could use IsNull function along with the Sum but it
> is not allowed on Aggregate functions like Sum.
>
> Prodip
>
> "Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
> news:%...
>> i'm not entirely sure but I believe it's gonna blow up like a weapon of
> mass
>> destruction. guard the code with a try catch block.
>>
>> --
>> Regards,
>> Alvin Bruney
>> [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
>> Got tidbits? Get it here... http://tinyurl.com/27cok
>> "Prodip Saha" <> wrote in message
>> news:...
>> > Alvin,
>> > What will be the result if Sum encounters a NULL value? I am assuming
>> > IsNull
>> > function is not used in the SQL that populates the dataset.
>> >
>> > Thanks,
>> > Prodip
>> >
>> > "Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message
>> > news:...
>> >> Assuming your datagrid is bound to a dataset, you can do this:
>> >>
>> >> if(e.Item.ItemType == ListItemType.Footer)
>> >> {
>> >> //sum every column
>> >> for(int i = 0; i < e.Items.Count - 1; i++)
>> >> e.Item.Cells[i].Text = ds.Tables[0].Compute("Sum([" +
>> >> e.Item.Cells[i].HeaderText + "])",String.Empty);
>> >>
>> >> roughly
>> >>
>> >> --
>> >> Regards,
>> >> Alvin Bruney
>> >> [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
>> >> Got tidbits? Get it here... http://tinyurl.com/27cok
>> >> "William Gower" <> wrote in message
>> >> news:...
>> >> >I would like to sum a column in my dataset and have it displayed at
> the
>> >> > bottom of the datagrid in the footer. How do I do that?
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>