在Gridview页脚中显示总价 [英] Displaying Total Price in Gridview footer

查看：75
本文介绍了在Gridview页脚中显示总价的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述


对于以下问题，我将不胜感激:
我有一个出售游戏等的网站，每个游戏的单独页面上都有一个添加到购物车"链接，单击可带您到"confirmamount.aspx"，询问他们要购买多少，键入一个数字，然后转到购物车在一个包含产品编号，产品名称，用户要求购买的数量，每单位价格，然后是总价"的gridview中，所有这些我都可以使用，但是我想在我的gridview的页脚中说出所有项目的总帐单价格，到目前为止，我的代码如下，但是页脚仍为空白.

CONFIRMAMOUNT.ASPX.CS

Hi,
I would appreciate some help for my below issue:
I have a site that sells games etc, each game has an add to cart link on its individual page, clicking that brings you to "confirmamount.aspx" which asks how many they wish to purchase, typing a figure then goes to a shopping cart with a gridview containing the product id, product name, quantity user requested to buy, price per unit, and then "total price", all of this i have working but i want in the footer of my gridview to say the totalbill for all items prices, so far i have below code but the footer just remains blank.

CONFIRMAMOUNT.ASPX.CS

public partial class ConfirmAmount : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            int ProductID = int.Parse(Request["id"].ToString());
            SqlCommand oCMD = new SqlCommand();
            SqlConnection oCON = new SqlConnection();
            oCON.ConnectionString = ConfigurationManager.ConnectionStrings["ProductsConnectionString"].ConnectionString;
            oCON.Open();
            oCMD.Connection = oCON;
            oCMD.CommandType = CommandType.StoredProcedure;
            oCMD.CommandText = "GetProductNameForID";
            oCMD.Parameters.Add(new SqlParameter("@ProdID", SqlDbType.Int));
            oCMD.Parameters["@ProdID"].Value = ProductID;
            SqlDataReader oRDR = oCMD.ExecuteReader();
            oRDR.Read();
            lblProduct.Text = oRDR.GetString(oRDR.GetOrdinal("title"));
            lblPrice.Text = oRDR.GetString(oRDR.GetOrdinal("price"));
            oCON.Close();
        }
        protected void cmdConfirm_Click(object sender, EventArgs e)
        {
            ((ArrayList)Session["aList"]).Add(new CustomerOrder(int.Parse(Request["id"]), lblProduct.Text, int.Parse(txtQuantity.Text), lblPrice.Text));
            Server.Transfer("ShoppingCart.aspx");
        }
        protected void cmdCancel_Click(object sender, EventArgs e)
        {
            cmdCancel.Attributes.Add("onClick", "javascript:history.back(); return false;");
        }
    }


CONFIRMAMOUNT.ASPX


CONFIRMAMOUNT.ASPX 

<%@ Page Title="" Language="C#" MasterPageFile="~/Main.master" AutoEventWireup="true" CodeFile="ConfirmAmount.aspx.cs" Inherits="ConfirmAmount" %>
    
    <asp:Content ID="Content1" ContentPlaceHolderID="body" Runat="Server">
         <div>
            <table>
                <tr>
                    <td style="width: 700px">
                        <h2 align="center">
                            style="color: #0441ff; font-family: 'Corbel';"&gt;Confirm purchase quantity:</h2>
                    </td>
                </tr>
                <tr>
                    <td>
                        Adding 
                        <asp:Label ID="lblProduct" runat="server" Text="Label">
                          to your cart at €
                        <asp:Label ID="lblPrice" runat="server" Text="Label">
                    </td>
                </tr>
                <tr>
                    <td>
                        Please enter your quantity: 
                        <asp:TextBox ID="txtQuantity" runat="server">
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:Button ID="cmdConfirm" runat="server" Text="Confirm" 

                            onclick="cmdConfirm_Click"/>
                        <asp:Button ID="cmdCancel" runat="server" Text="Cancel" 

                            onclick="cmdCancel_Click" onclientclick="javascript:history.back(); return false" />
                    </td>
                </tr>
            </table>
        </div>


CUSTOMER.CS


CUSTOMER.CS

using System;
    using System.Collections.Generic;
    //using System.Linq;
    using System.Web;
    
    /// <summary>
    /// Summary description for CustomerOrder
    /// </summary>
    public class CustomerOrder
    {
        private int iProductID;
        private string sProductName;
        private int iQuality;
        private string iPrice;
    
        public CustomerOrder(int PID, string PN, int Q, string Pri)
        {
            this.iProductID = PID;
            this.sProductName = PN;
            this.iQuality = Q;
            this.iPrice = Pri;
        }
    
        public int ProductID
        {
            get
            {
                return iProductID;
            }
            set
            {
                iProductID = value;
            }
        }
    
        public string Productname
        {
            get
            {
                return sProductName;
            }
            set
            {
                sProductName = value;
            }
        }
    
        public int Quantity
        {
            get
            {
                return iQuality;
            }
            set
            {
                iQuality = value;
            }
        }
    
        public string ProductPrice
        {
            get
            {
                return iPrice;
            }
            set
            {
                iPrice = value;
            }
        }
        //public CustomerOrder()
        //{
        //    //
        //    // TODO: Add constructor logic here
        //    //
        //}
    }


SHOPPINGCART.ASPX


SHOPPINGCART.ASPX

<%@ Page Title="" Language="C#" MasterPageFile="~/Main.master" AutoEventWireup="true" CodeFile="ShoppingCart.aspx.cs" Inherits="ShoppingCart" %>
    
    <asp:Content ID="Content1" ContentPlaceHolderID="body" Runat="Server">
        <div>
            <table>
                <tr>
                    <td style="width: 500px">
                        <h2 align="center">
                            style="color: #0441ff; font-family: 'Corbel';"&gt;Shopping Cart:</h2>
                    </td>
                </tr>
                <tr>
                    <td>
    &lt;asp:GridView ID="grdProducts" runat="server" AutoGenerateColumns="False" 
                            HorizontalAlign="Center" Width="550px" ShowFooter="True" BorderStyle="None" GridLines="None"&gt;
                            <columns>
                                <asp:BoundField DataField="ProductName" HeaderText="Product Name" 

                                    ItemStyle-HorizontalAlign="Center" >
                                    <itemstyle horizontalalign="Center"></itemstyle>
                                
                                <asp:BoundField DataField="ProductID" HeaderText="Product ID" 

                                    ItemStyle-HorizontalAlign="Center" >
                                    <itemstyle horizontalalign="Center"></itemstyle>
                                
                                &lt;asp:BoundField DataField="ProductPrice" HeaderText="Price" 
                                    ItemStyle-HorizontalAlign="Center" DataFormatString="€{0:d}" &gt;
                                    <itemstyle horizontalalign="Center"></itemstyle>
                                
                                &lt;asp:TemplateField HeaderText="Quantity"&gt;
                                    <itemtemplate>
                                        &lt;asp:Label ID="lblQuantity" runat="server" BorderColor="Black" Text='&lt;%# Eval("quantity")%&gt;'/&gt;
                                    </itemtemplate>
                                    <footertemplate>
                                        &lt;asp:Label ID="lblBuying" runat="server" BorderColor="Black" /&gt;
                                    </footertemplate>
                                    <footerstyle borderstyle="Solid" />
                                    <itemstyle horizontalalign="Center" />
                                
                                <asp:TemplateField HeaderText="Total Price" ItemStyle-HorizontalAlign="Center" FooterStyle-BorderStyle="Solid">
                                    <itemtemplate>
                                        <asp:Label ID="lblQuPrice" runat="server" BorderColor="Black" Text ='&lt;%# "€" + (Decimal.Parse(Eval("ProductPrice").ToString())*Decimal.Parse(Eval("Quantity").ToString())).ToString("N2") %&gt;'>
                                        
                                     </itemtemplate>
                                    <footertemplate>
                                        <asp:Label ID="lblBill" runat="server" BorderColor="Black" />
                                    </footertemplate>
                                    <footerstyle borderstyle="Solid"></footerstyle>
                                    <itemstyle horizontalalign="Center"></itemstyle>
                                
                            </columns>
                            <editrowstyle horizontalalign="Center" />
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" 

                                ForeColor="#003296" />
                            <footerstyle horizontalalign="Right" />
                        
                        <asp:SqlDataSource ID="ShopCartDataSource" runat="server" 

                            ConnectionString="<%$ ConnectionStrings:ProductsConnectionString %>" 

                            SelectCommand="SELECT [id], [title], [quantity], [price] FROM [productTable]">
                        
                    </td>
                </tr>
                <tr align="center">
                    <td>
                        <asp:Button ID="Button1" runat="server" Text="Buy Now"/>
                        <asp:Button ID="Button2" runat="server" Text="Continue Shopping" 

                            PostBackUrl="~/HomePage.aspx" />
                    </td>
                </tr>
            </table>
        </div>



SHOPPINGCART.ASPX.CS



SHOPPINGCART.ASPX.CS

using System;
using System.Collections.Generic;
//using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Collections;

public partial class ShoppingCart : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ArrayList aList;
        aList = (ArrayList)Session["aList"];
        grdProducts.DataSource = aList;
        grdProducts.DataBind();
    }

    decimal theBill = 0;
    decimal totalStock = 0;

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if(e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lblQuPrice = (Label)e.Row.FindControl("lblQuPrice");
            Label lblQuantity = (Label)e.Row.FindControl("lblQuantity");

            decimal price = Decimal.Parse(lblQuPrice.Text);
            decimal amountToBuy = Decimal.Parse(lblQuantity.Text);

            theBill += price;
            totalStock += amountToBuy;
        }
        if(e.Row.RowType == DataControlRowType.Footer)
        {
            Label lblBill = (Label)e.Row.FindControl("lblBill");
            Label lblBuying = (Label)e.Row.FindControl("lblBuying");

            lblBill.Text = theBill.ToString();
            lblBuying.Text = totalStock.ToString();
        }
    }
}

推荐答案

ConnectionStrings:ProductsConnectionString ％> " span> SelectCommand =" 从[productTable]中选择[id]，[title]，[quantity]，[price]" < /td > < /tr > < tr =" center" < td > < asp:Button ID =" runat 服务器" 文本 立即购买" > < asp:Button ID =" runat 服务器" 文本 继续购物" span> PostBackUrl =" 〜/HomePage.aspx" / > < /td > < /tr > < /table > < /div >
ConnectionStrings:ProductsConnectionString %>" SelectCommand="SELECT [id], [title], [quantity], [price] FROM [productTable]"> </td> </tr> <tr align="center"> <td> <asp:Button ID="Button1" runat="server" Text="Buy Now"/> <asp:Button ID="Button2" runat="server" Text="Continue Shopping" PostBackUrl="~/HomePage.aspx" /> </td> </tr> </table> </div>



SHOPPINGCART.ASPX.CS



SHOPPINGCART.ASPX.CS

using System;
using System.Collections.Generic;
//using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Collections;

public partial class ShoppingCart : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ArrayList aList;
        aList = (ArrayList)Session["aList"];
        grdProducts.DataSource = aList;
        grdProducts.DataBind();
    }

    decimal theBill = 0;
    decimal totalStock = 0;

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if(e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lblQuPrice = (Label)e.Row.FindControl("lblQuPrice");
            Label lblQuantity = (Label)e.Row.FindControl("lblQuantity");

            decimal price = Decimal.Parse(lblQuPrice.Text);
            decimal amountToBuy = Decimal.Parse(lblQuantity.Text);

            theBill += price;
            totalStock += amountToBuy;
        }
        if(e.Row.RowType == DataControlRowType.Footer)
        {
            Label lblBill = (Label)e.Row.FindControl("lblBill");
            Label lblBuying = (Label)e.Row.FindControl("lblBuying");

            lblBill.Text = theBill.ToString();
            lblBuying.Text = totalStock.ToString();
        }
    }
}


我怀疑是否有人会抛出整个代码转储.您应该始终共享与相关问题相关的代码段.

现在，请查看有关同一主题的MSDN文章，以了解其实现方式: MSDN:GridView ASP.NET 2.0的示例:在页脚中显示摘要数据 [ ^ ]
I doubt if anyone is going to go throw that whole code dump. You should always share the related code snippet to the issue related.

For now, have a look at this MSDN article on the same topic to see how it is implemented: MSDN: GridView Examples for ASP.NET 2.0: Displaying Summary Data in the Footer[^]


这篇关于在Gridview页脚中显示总价的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆