Welcome :Guest

Congratulations!!!

Top 5 Contributors of the Month
Melody Anderson

 Home >> Forum >> C# >> Post New Question Subscribe to Forum
Author: Gowthammanju
Posted Date: June 11, 2011     Points: 20

for displaying grand total

use sql query as

`select sum(acamount)as total from table name `

where acamount is the total field name to which u have to sum

Thanks & Regards,
GowthamManju
Chennai

Mark if the answer is true
Author: Sasi Prabhu
Posted Date: June 11, 2011     Points: 20

try:

Use the Aggrigate Functions

sum(fieldname)

eg.

select count(salary) from tablename

Thanks & Regards,
Sasi Prabhu.
Author: Gowthammanju
Posted Date: June 11, 2011     Points: 20

Your question for displaying its not so clear

Thanks & Regards,
GowthamManju
Chennai

Mark if the answer is true
Author: Sasi Prabhu
Posted Date: June 11, 2011     Points: 20

Hi Catherine,

What u want to display in letter format?

Thanks & Regards,
Sasi Prabhu.
Author: Ravi Ranjan Kumar
Posted Date: June 11, 2011     Points: 20

yeah! you need to use Aggregate function to display sum of all values.
Take a Syntax

`Select aggregate_function([All|Distinct] Expression) from table_Name `

as
`select sum(columnname) from tablename`

Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com
Author: Ravi Ranjan Kumar
Posted Date: June 11, 2011     Points: 20

Hey! if your are looking for convert Numbers to Words format then the given article might be useful for you
http://www.dotnetspider.com/resources/27482-Number-Words.aspx

Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com
Author: shiv chandra
Posted Date: June 14, 2011     Points: 20

`Select SUM(FieldName ) FROM <TableName> `

If you want to select other column along with above query you need to add group by cluase as SUM is aggregate function.

Please Change parameter highlighted in red color with proper FieldName and tablename.

Regards
-------
Shiva

Regards
Shiva