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.

alan kumar · Answer

There are lots of if & for-loops that we have to apply to get this result, GetDistintColumnsRowValues is a method that I have called to get distinct rows and columns on server-side. dt_temp,dt_temp1,dt_temp2 are my datatables. if (dt_temp.Rows.Count > 0) { System.Data.DataTable dt_temp1 = GetDistintColumnsRowValues(dt_report, "dept_code"); System.Data.DataTable dt_temp2 = GetDistintColumnsRowValues(dt_report, "sub_loc_code"); if (dt_temp1.Rows.Count > 0 && dt_temp2.Rows.Count > 0) { for (int i = 0; i { if (dt.Rows.Count > 0) { row = dt.NewRow(); row["Item Name"] = "Sub_total"; for (int n = 0; n { int total = 0; string colname = dt_temp1.Rows[n]["dept_name"].ToString(); ; string dept_name = dt_temp1.Rows[n]["dept_code"].ToString(); sub_item_code = dt_temp.Rows[i - 1]["item_code"].ToString(); dt_sub_total.DefaultView.RowFilter = "item_code = '" + sub_item_code + "' and dept_code = '" + dept_name + "'"; dt_sub_filter = dt_sub_total.DefaultView.ToTable(); if (dt_sub_filter.Rows.Count > 0) { row[colname] = dt_sub_filter.Rows[0]["total"].ToString(); } } dt.Rows.Add(row); if (i == dt_temp.Rows.Count) { break; } } row = dt.NewRow(); row["Item Name"] = dt_temp.Rows[i]["item_desc"].ToString(); dt.Rows.Add(row); item_code = dt_temp.Rows[i]["item_code"].ToString(); for (int k = 0; k { row = dt.NewRow(); row["Category"] = dt_temp2.Rows[k]["loc_desc"].ToString(); for (int j = 0; j { dept_code = dt_temp1.Rows[j]["dept_code"].ToString(); sub_loc_code = dt_temp2.Rows[k]["sub_loc_code"].ToString(); dt_report.DefaultView.RowFilter = "item_code = '" + item_code + "' and dept_code = '" + dept_code + "' and sub_loc_code = '" + sub_loc_code + "'"; dt_filter = dt_report.DefaultView.ToTable(); if (dt_filter.Rows.Count > 0) { string columnname = dt_temp1.Rows[j]["dept_name"].ToString(); if (dt.Columns.Contains(columnname)) { row[columnname] = dt_filter.Rows[0]["curr_qty"].ToString(); } else { dt.Columns.Add(columnname); row[columnname] = dt_filter.Rows[0]["curr_qty"].ToString(); } } if (j == dt_temp1.Rows.Count - 1) { dt_main_total.DefaultView.RowFilter = "item_code = '" + item_code + "' and sub_loc_code = '" + sub_loc_code + "'"; dt_main_filter = dt_main_total.DefaultView.ToTable(); if (dt_main_filter.Rows.Count > 0) { if (dt.Columns.Contains("Total1")) { row["Total1"] = dt_main_filter.Rows[0]["tot"].ToString(); } else { dt.Columns.Add("Total1"); row["Total1"] = dt_main_filter.Rows[0]["tot"].ToString(); } } } } dt.Rows.Add(row); } } } }

Nihal Ahmed · Answer

please share the solution. i am having this problem... how u have done...

alan kumar · Answer

got the answer myself

getting sub-total after every five rows

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)