Can i use footer in DataGridView for viewing a total amount

Hi friends,

 

   I am trying to designing a billing software program. I can add customer details, purchase details in my project. But in sales detail, i don't know how to add more than one product under the same Bill-NO and how to get the Grand-total of the total-price column using DataGridView(with C#.net).

 

 Thanks

 

Example:

 

 

Bill-NO: SM0012

Product_ID	Product_Name	Price	Quantity	Total
001	A	55.50	2	111
002	B	62.75	1	62.75
			Grand_Total:	173.75