Foreach loop on datatable on same column

Question

Hi, I want to add a row at a specific location. I have a table with following data

InvID	CatID	ItemCode	BatchNo	Price	Qty	Total
2	122	43	DFR-43	33$	3	99$
2	643	76	SGR-3	25$	2	50$
2	643	12	KLS-E3	45$	2	90$
2	177	65	EWQ-22	8$	1	8$
2	177	988	FDS-32	11$	7	77$
2	177	45	VFE-44	22$	4	88$
2	355	19	DRG-28	15$	3	45$
2	355	39	CSX-099	6$	2	12$
2	355	26	XDE-134	13$	8	104$
2	355	87	VVF-2002	56$	5	280$
2	355	59	BNM-344	34$	2	68$
2	165	374	SDE-3	20$	2	40$

I want to add a row after ending each catID for showing the sum of that Category.

likewise i want to add a row at second last postion as
Total : 509$

need urgent help...

Thanks

Sagar Malde · Answer

Hi Rameez, This might help List dc = new List (); dc.Add( new DataColumn { InvID = 2, CatID = 122, ItemCode = 43, BatchNo = "DFR-43" , Price = 33, Qty = 3, Total = 33 * 3 }); dc.Add( new DataColumn { InvID = 2, CatID = 643, ItemCode = 76, BatchNo = "SGR-3" , Price = 25, Qty = 2, Total = 25 * 2 }); dc.Add( new DataColumn { InvID = 2, CatID = 122, ItemCode = 12, BatchNo = "KLS-E3" , Price = 45, Qty = 2, Total = 45 * 2 }); dc.Add( new DataColumn { InvID = 2, CatID = 643, ItemCode = 65, BatchNo = "EWQ-22" , Price = 8, Qty = 1, Total = 8 * 1 }); dc.Add( new DataColumn { InvID = 2, CatID = 177, ItemCode = 988, BatchNo = "FDS-32" , Price = 11, Qty = 7, Total = 11 * 7 }); dc.Add( new DataColumn { InvID = 2, CatID = 177, ItemCode = 45, BatchNo = "VFE-44" , Price = 22, Qty = 4, Total = 22 * 4 }); dc.Add( new DataColumn { InvID = 2, CatID = 177, ItemCode = 19, BatchNo = "DRG-28" , Price = 15, Qty = 3, Total = 15 * 3 }); dc.Add( new DataColumn { InvID = 2, CatID = 355, ItemCode = 39, BatchNo = "CSX-099" , Price = 6, Qty = 2, Total = 6 * 2 }); dc.Add( new DataColumn { InvID = 2, CatID = 355, ItemCode = 26, BatchNo = "XDE-134" , Price = 13, Qty = 8, Total = 13 * 8 }); dc.Add( new DataColumn { InvID = 2, CatID = 355, ItemCode = 87, BatchNo = "VVF-2002" , Price = 56, Qty = 5, Total = 56 * 5 }); dc.Add( new DataColumn { InvID = 2, CatID = 355, ItemCode = 59, BatchNo = "BNM-344" , Price = 34, Qty = 2, Total = 34 * 2 }); dc.Add( new DataColumn { InvID = 2, CatID = 165, ItemCode = 374, BatchNo = "SDE-3" , Price = 20, Qty = 2, Total = 20 * 2 }); dc = dc.OrderBy(x => x.CatID).ToList(); My ajax "text/javascript" > $(document).ready(function () { $.ajax({ type: "POST" , url: "/Employee/BindDataTable" , data: {}, content: "application/json; charset=utf-8" , dataType: "json" , success: function (d) { console.log(d); if (d != null ) { if (d.data != null ) { var Html = '' ; var CatId = 0; var Total = 0; for (var i = 0; i if (d.data[i].CatID != CatId && i > 0) { Html += ' ' ; Html += ' ' ; Html += ' Total ' ; Html += ' ' ; Html += ' ' Html += ' ' + Total + ' ' Html += ' ' ; Html += ' ' ; Total = 0; } Html += ' ' ; Html += ' ' + d.data[i].InvID + ' ' ; Html += ' ' + d.data[i].CatID+ ' ' ; Html += ' ' + d.data[i].ItemCode+ ' ' ; Html += ' ' + d.data[i].BatchNo+ ' ' ; Html += ' ' + d.data[i].Price+ ' ' ; Html += ' ' + d.data[i].Qty+ ' ' ; Html += ' ' + d.data[i].Total + ' ' ; Html += ' ' ; CatId = d.data[i].CatID; Total = Total + parseInt(d.data[i].Total); if (i==d.data.length-1) { Html += ' ' ; Html += ' ' ; Html += ' Total ' ; Html += ' ' ; Html += ' ' Html += ' ' + Total + ' ' Html += ' ' ; Html += ' ' ; } } $( '#tbody' ).append(Html); } } }, error: function (xhr, textStatus, errorThrown) { } }); })

Laxmidhar Sahoo · Answer

I am sending a html table with adding row .You can modify table example "dataTable2" > Admin No/Staff ID: Name: Contact No: Types of People Involved: "checkbox" name= "checkbox[]" > "text" name= "id[]" id= "id" /> "text" name= "names[]" id= "names" > "text" name= "contacts[]" id= "contacts" /> "type" id= "dd" class = "selectpicker" data-style= "select-with-transition" title= "News Type" data-size= "7" onchange= "show()" > "" >Select a Type "casualties" class = "casualties-element" >Casualties "ncasualties" >Non-Casualties "witness" >Witness "button" value= "Add Row" onclick= "addRow()" /> "dataTable1" style= "cellpadding:20px;" > Admin No/Staff ID: Name: Contact No: Types of People Involved: No. of Casualties: "text" name= "injury" id= "injury" class = "injury span2" onClick= "show();" > var count = 0; function addRow() { alert( "test" ); var table1 = document.getElementById( 'dataTable1' ); var table = document.getElementById( 'dataTable2' ); var did = document.getElementById( 'id' ).value; var dname = document.getElementById( 'names' ).value; var dcontact = document.getElementById( 'contacts' ).value; var dddl = document.getElementById( 'dd' ); var ddlvalue = dddl.options[dddl.selectedIndex].value; if (ddlvalue == 'casualties' ) { count++; } document.getElementById( 'injury' ).value = count; var rowCount = table.rows.length; //var row = table.insertRow(rowCount); var row = table1.insertRow(1); var colCount = table.rows[1].cells.length; for ( var i = 0; i var newcell = row.insertCell(i); //newcell.innerHTML = table.rows[1].cells[i].innerHTML; //alert(newcell.childNodes); switch (i) { case 0: newcell.innerHTML = did; break ; case 1: newcell.innerHTML = dname; break ; case 2: newcell.innerHTML = dcontact; break ; case 3: newcell.innerHTML = ddlvalue; break ; } } }

Rameez Javed · Answer

@Laxmidhar Sahoo datatable in C# and i converted it into json string to append it to html table...

Rameez Javed · Answer

i want to get in c# InvID CatID ItemCode BatchNo Price Qty Total 2 122 43 DFR-43 33$ 3 99$ Total 99$ 2 643 76 SGR-3 25$ 2 50$ 2 643 12 KLS-E3 45$ 2 90$ Total 140$ 2 177 65 EWQ-22 8$ 1 8$ 2 177 988 FDS-32 11$ 7 77$ 2 177 45 VFE-44 22$ 4 88$ Total 93$ 2 355 19 DRG-28 15$ 3 45$ 2 355 39 CSX-099 6$ 2 12$ 2 355 26 XDE-134 13$ 8 104$ 2 355 59 BNM-344 34$ 2 68$ Total 509$ 2 165 374 SDE-3 20$ 2 40$ Total 40$

Laxmidhar Sahoo · Answer

I think Sagar Malde is correct .Try it

Laxmidhar Sahoo · Answer

it is simple for you define a html table in a mvc or asp.net page and the call ajax and send to the c# through jsonstring.You can easyly modify the table in client side

Thiyagarajan E · Answer

Hi, How you are appending the JSON string to html table?

Laxmidhar Sahoo · Answer

If in c# then define a datatable and the data table have to display in ui. If in client side I mean in js .Then only you have to use a js tool that you like

Laxmidhar Sahoo · Answer

whether the table in client side or server side again what is the tool used

Rameez Javed · Answer

on other hand we'll have to do it with json string... if its possible then we can do it here too.

Thiyagarajan E · Answer

Hi, I think it is difficult to do in a data table. Can we try this in javascript?

Rameez Javed · Answer

Its Asp.net Web Application, i want to make datatable like this and will convert it into json and append to html table.

Thiyagarajan E · Answer

Hi, you can try this using ASP .NET Grid view subtotal. https://www.aspsnippets.com/Articles/Display-SubTotal-and-Grand-Total-in-ASPNet-GridView.aspx Thanks..,

Thiyagarajan E · Answer

Hi, Is your application is ASP .NET or MVC?

Thiyagarajan E · Answer

Hi, Where do you need a loop in SQL or c#? And also share the result table to help you.

Sanwar Ranwa · Answer

Hello Rameez Please check these Links https://www.aspsnippets.com/Articles/Calculate-Sum-Total-of-DataTable-Columns-using-C-and-VBNet.aspx https://stackoverflow.com/questions/5601752/how-to-sum-columns-in-a-datatable