getting sub-total after every five rows

Question

ItemName	Category	1st floor	2nd floor	total
Bedsheet
	wash	1	4	?
	fresh	3	5	?
	alter	8	6	?
	condemn	7	5	?
sub-total		?	?
pillow cover	wash	8	4	?
	fresh	2	3	?
	alter	8	8	?
	condemn	3	4	?
sub-total		?	?
so on

 This is a MSVS 2005 WINDOWS FORM APPLICATION. In this windows form application, I have datagridview and a show button, on clicking the show button data gets uploaded in the datagridview and this is the dynamic data from sql 2005 table which I am getting through a datatable I have created. Now my problem is how to calculate and get sub-total and Total figures in the above dynamic datagridview. please reply as soon as possible.

Answer 1

this is the provider settings or sqlconnection settings for ms excel once we complete this every this is common like sqlcommand,dataset,dataadapter

sqlconnection con= new sqlconnectio(provider=Microsoft.Jet.OLEDB.4.0;Data Source='Your Filename';Extended Properties=Excel 8.0;)

,but select statement is sytanx is some differ like this way

ample Select sql

sqlcommand cmd  = new sqlcommand("select * from [Sheet1$] where condition",con);

if it satisfies you accept this answer by clicking thumb up symbol

 

Answer 2

Hi chiranjeevi,

This is a simple application i did of your requirements.Run the attachments.


Thanks


If it helps you plz mark the answer as Accepted answer

Answer 3

Also look at the articles in this web site about Excel.