Foreach loop on datatable on same column

Rameez Javed

7y3.2k.NET

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

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo7y ago
I think Sagar Malde is correct .Try it
0
Sagar Malde7y ago
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 < d.data.length; 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) {

            }
        });
    })
+1
Laxmidhar Sahoo7y ago
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();">
+1
Laxmidhar Sahoo7y ago
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
0
Thiyagarajan E7y ago
Hi,

How you are appending the JSON string to html table?
0
Rameez Javed7y ago
@Laxmidhar Sahoo
datatable in C# and i converted it into json string to append it to html table...
+1
Laxmidhar Sahoo7y ago
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
0
Laxmidhar Sahoo7y ago
whether the table in client side or server side again what is the tool used
0
Rameez Javed7y ago
on other hand we'll have to do it with json string... if its possible then we can do it here too.
0
Thiyagarajan E7y ago
Hi,

I think it is difficult to do in a data table. Can we try this in javascript?
0
Rameez Javed7y ago
Its Asp.net Web Application, i want to make datatable like this and will convert it into json and append to html table.
0
Thiyagarajan E7y ago
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..,
0
Thiyagarajan E7y ago
Hi,

Is your application is ASP .NET or MVC?
0

Rameez Javed7y ago

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$

Thiyagarajan E7y ago
Hi,

Where do you need a loop in SQL or c#? And also share the result table to help you.
0
Sanwar Ranwa7y ago
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
0