Calculate total in C# then output to a table

Question

Calculate total in C# then output to a table

Kris Ellison 25

I Screenshot (289)

I am trying to sum the subtotal and total columns but not sure how to. I've tried accessing the quantity and price to perform the calculation but haven't been able to work it out. Below is a snippet of my C# and my table I am trying to output it to. Any advice would be greatly appreciated.

Print.aspx.cs

String.IsNullOrEmpty(Request.Form["txtQuantity1"]))
            {
                lblQuantity1.Text = Request.Form["txtQuantity1"];
            {
         
if (!String.IsNullOrEmpty(Request.Form["txtPrice1"]))
            {
                lblPrice1.Text = Request.Form["txtPrice1"];

Print.aspx
             <tr>
                 <td><asp:Label ID="lblItem1" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblPrice1" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblQuantity1" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="Total1" runat="server" Text="--"></asp:Label></td>
             </tr>

Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff

2023-04-25T09:29:52.0333333+00:00

Hi @Kris Ellison,

The code you provided is not very complete, you'd better provide more detailed information so that we can help you better.

Kris Ellison 25

Invoice.aspx
 <form method="post" runat="server" action="Print.aspx" target="_blank">
       <fieldset>
           <asp:Label ID="lblCustomerName" runat="server" Text="Full Name Of Customer" AssociatedControlID="lblCustomerName"></asp:Label>
           <asp:TextBox ID="txtCustomerName" runat="server" MaxLength="50" ></asp:TextBox>
           <asp:RequiredFieldValidator ID="rfvFullName" runat="server" ControlToValidate="txtCustomerName" ErrorMessage="Full Name Required" Text="*"></asp:RequiredFieldValidator>
           <br/>
<!--Drop down list Item 1-->
           <asp:Label ID="lblItem1" runat="server" Text="Item Name"></asp:Label>
           <asp:DropDownList ID="Item1" runat="server">
               <asp:ListItem Value="--">Choose item 1</asp:ListItem>
               <asp:ListItem ID="lillyPilly" value="Lilly Pilly">Lilly Pilly</asp:ListItem>
               <asp:ListItem ID="snowGum" value="Snow Gum">Snow Gum</asp:ListItem>
               <asp:ListItem ID="goldenWattle" value="Golden Wattle">Golden Wattle</asp:ListItem>
               <asp:ListItem ID="rustyGum" value="Rusty Gum">Rusty Gum</asp:ListItem>
               <asp:ListItem ID="roseBoronia" value="Rose Boronia">Rose Boronia</asp:ListItem>
               <asp:ListItem ID="canberraBells" value="Canberra Bells">Canberra Bells</asp:ListItem>
               <asp:ListItem ID="silverPrincessGum" value="Silver Princess Gum">Silver Princess Gum </asp:ListItem>
               <asp:ListItem ID="kangarooPaw" value="Kangaroo Paw">Kangaroo Paw</asp:ListItem>
           </asp:DropDownList>
           <asp:Label ID="lblPrice1" runat="server" Text="Price"></asp:Label>
           <asp:TextBox ID="txtPrice1" runat="server"></asp:TextBox>
           <asp:RangeValidator ID="rvPrice1" runat="server" ControlToValidate="txtPrice1" ErrorMessage="Price must be between 1.00 and 1000.00" Text="*"
               type="Currency" MinimumValue="1" MaximumValue="1000.00"></asp:RangeValidator>
            <asp:Label ID="lblQuantity1" runat="server" Text="Quantity"></asp:Label>
           <asp:TextBox ID="txtQuantity1" runat="server"></asp:TextBox>
           <asp:RangeValidator ID="rvQuantity1" runat="server" ControlToValidate="txtQuantity1" ErrorMessage="Quantity must be between 0 and 100" Text="*"
               type="Integer" MinimumValue="0" MaximumValue="100"></asp:RangeValidator>
           <br/>

Print.aspx(table)
<table>
             <tr>
                 <th>Item:</th>
                 <th>Unit Price:</th>
                 <th>Quantity:</th>
                 <th>Subtotal:</th>
             </tr>
             <tr>
                 <td><asp:Label ID="lblItem1" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblPrice1" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblQuantity1" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="Total1" runat="server" Text="--"></asp:Label></td>
             </tr>
             <tr>
                 <td><asp:Label ID="lblItem2" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblPrice2" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblQuantity2" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="Total2" runat="server" Text="--"></asp:Label></td>
             </tr>
             <tr>
                 <td><asp:Label ID="lblItem3" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblPrice3" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="lblQuantity3" runat="server" Text="--"></asp:Label></td>
                 <td><asp:Label ID="Total3" runat="server" Text="--"></asp:Label></td>
             </tr>
             <tr>
                 <td>Total:</td>
                 <td></td>
                 <td></td>
                 <td><asp:Label ID="Total" runat="server" Text="--"></asp:Label></td>
             </tr>
         </table>

Print.aspx.cs
public partial class Print : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(Request.Form["txtCustomerName"]))
            {
                lblCustomerName.Text = Request.Form["txtCustomerName"];
            }
            {
                date.Text = System.DateTime.Now.ToString();
            }
            if (!String.IsNullOrEmpty(Request.Form["Item1"]))
            {
                lblItem1.Text = Request.Form["Item1"];

            }
            if (!String.IsNullOrEmpty(Request.Form["Item2"]))
            { 
                lblItem2.Text = Request.Form["Item2"];
            }
            if (!String.IsNullOrEmpty(Request.Form["Item3"]))
            {
                lblItem3.Text = Request.Form["Item3"];
            }
            if (!String.IsNullOrEmpty(Request.Form["txtPrice1"]))
            {
                lblPrice1.Text = Request.Form["txtPrice1"];
            }
            if (!String.IsNullOrEmpty(Request.Form["txtQuantity1"]))
            {
                lblQuantity1.Text = Request.Form["txtQuantity1"];
            }
            if (!String.IsNullOrEmpty(Request.Form["txtPrice2"]))
            {
                lblPrice2.Text = Request.Form["txtPrice2"];
            }
            if (!String.IsNullOrEmpty(Request.Form["txtQuantity2"]))
            {
                lblQuantity2.Text = Request.Form["txtQuantity2"];
            }
            if (!String.IsNullOrEmpty(Request.Form["txtPrice3"]))
            {
                lblPrice3.Text = Request.Form["txtPrice3"];
            }
            if (!String.IsNullOrEmpty(Request.Form["txtQuantity3"]))
            {
                lblQuantity3.Text = Request.Form["txtQuantity3"];
            }
            

        }
    }

Accepted answer

0 additional answers

Your answer

Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff

2023-04-25T09:29:52.0333333+00:00

Hi @Kris Ellison,

The code you provided is not very complete, you'd better provide more detailed information so that we can help you better.

Answer 1

Lan Huang-MSFT 30,186 Microsoft External Staff

Hi @Kris Ellison,

The value of the label can be obtained directly for calculation.

Place the following code at the end of Page_Load in Print.aspx.cs.

 int total1 = Convert.ToInt32(lblQuantity1.Text.ToString()) + Convert.ToInt32(lblPrice1.Text.ToString());
                Total1.Text = total1.ToString();
                int total2 = Convert.ToInt32(lblQuantity2.Text.ToString()) + Convert.ToInt32(lblPrice2.Text.ToString());
                Total2.Text = total2.ToString();
                int total3 = Convert.ToInt32(lblQuantity3.Text.ToString()) + Convert.ToInt32(lblPrice3.Text.ToString());
                Total3.Text = total3.ToString();
                Total.Text = (total1 + total2 + total3).ToString();

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Kris Ellison 25 Reputation points

2023-04-27T10:26:58.63+00:00

How would I go about if only 1 item was selected? Would it have to be a series of if else statements?

Lan Huang-MSFT 30,186 Microsoft External Staff

Hi @Kris Ellison,

When the data becomes large, you can try to use gridview to reduce the burden. The number of items selected each time is uncertain, so you need to use if else.

One of my thoughts is that you set the default value of TextBox to 0, so that you don't need to judge whether Request.Form is empty.

<asp:TextBox ID="txtPrice1" Text="0" runat="server"></asp:TextBox>

 <asp:GridView ID="GridView1" runat="server" CssClass="Grid" AutoGenerateColumns="false">
    <Columns>
         <asp:BoundField DataField="Item" HeaderText="Item:" ItemStyle-Width="120" />
        <asp:BoundField DataField="Price" HeaderText="Unit Price" ItemStyle-Width="120" />
        <asp:BoundField DataField="Quantity" HeaderText="Quantity" ItemStyle-Width="120" />
         <asp:BoundField DataField="Subtotal" HeaderText="Subtotal" ItemStyle-Width="120" />
    </Columns>
</asp:GridView>

protected void Page_Load(object sender, EventArgs e)
        {              
            if (!this.IsPostBack)
            {
                int total1 = 0;
                int total2 = 0;
                DataTable dt = new DataTable();
                dt.Columns.AddRange(new DataColumn[4] { new DataColumn("Item"), new DataColumn("Price"), new DataColumn("Quantity"),new DataColumn("Subtotal") });
                total1 = Convert.ToInt32(Request.Form["txtPrice1"].ToString()) + Convert.ToInt32(Request.Form["txtQuantity1"].ToString());            
                dt.Rows.Add(Request.Form["Item1"], Request.Form["txtPrice1"], Request.Form["txtQuantity1"], total1);            
                total2 = Convert.ToInt32(Request.Form["txtPrice2"].ToString()) + Convert.ToInt32(Request.Form["txtQuantity2"].ToString());
                dt.Rows.Add(Request.Form["Item2"], Request.Form["txtPrice2"], Request.Form["txtQuantity2"], total2);        
                dt.Rows.Add("Total:", "--", "--", total1+total2);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }         
        }

Share via

Calculate total in C# then output to a table

0 additional answers

Your answer