ASP.NET利用DataList实现从购物车添加商品

最新推荐文章于 2022-07-08 15:17:52 发布

似水の流年_2019

最新推荐文章于 2022-07-08 15:17:52 发布

阅读量2k

点赞数 5

分类专栏： Web前端文章标签： ASP.NET web 购物车 DataList Session

本文链接：https://blog.csdn.net/weixin_42978759/article/details/103442483

版权

Web前端专栏收录该内容

5 篇文章 0 订阅

订阅专栏

前言

VS中的DataList控件可以内嵌按钮，为创建库存列表提供了便利。

DataList内嵌按钮

最近在练习ASP.NET，创建一个购物网站时用到了会话(Session)，通过Session将用户购买的商品信息临时存储下来，实现从库存中挑选商品的功能。网页设计如下，左侧DataList列表为库存信息，右侧GridView表格为选中的信息，通过点击DataList列表中的SelectItem按钮将对应商品添加到GridView表格。

DataList表格可以将按钮内嵌，适合在库存数目比较大且库存实时变化的情况下使用。DataList中内嵌的按钮似乎只能通过DataList的事件属性ItemCommand来实现，通过该事件的DataListCommandEventArgs参数可以获得按钮对应的数据，代码如下。

        protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
            int nItemIndex = e.Item.ItemIndex;     //获取选中项
            this.DataList1.SelectedIndex = nItemIndex;

            BindToinventory();
          
            DataTable dt = (DataTable)DataList1.DataSource;     //从数据库中获取该项信息
            String strID = (dt.Rows[nItemIndex][0]).ToString();
            String strTitle = (dt.Rows[nItemIndex][1]).ToString();
            String strAuthorLastName = (dt.Rows[nItemIndex][2]).ToString();
            String strAuthorFirstName = (dt.Rows[nItemIndex][3]).ToString();
            String strTopic = (dt.Rows[nItemIndex][4]).ToString();
            String strPublisher = (dt.Rows[nItemIndex][5]).ToString();

            DataTable tableSelectedItems;
            tableSelectedItems = (DataTable)Session["tableSelectedItems"];   //从Session获取已添加表格

            DataRow dr = tableSelectedItems.NewRow();    //添加新行
            dr[0] = strID;
            dr[1] = strTitle;
            dr[2] = strAuthorLastName;
            dr[3] = strAuthorFirstName;
            dr[4] = strTopic;
            dr[5] = strPublisher;

            tableSelectedItems.Rows.Add(dr);

            Session["tableSelectedItems"] = tableSelectedItems;    //将新表格信息存入Session

            this.GridView1.DataSource = tableSelectedItems;    //刷新表格
            this.GridView1.DataBind();
        }

源码

aspx文件：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UseDataList.aspx.cs" Inherits="SessionState.UseDataList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .auto-style1 {
            z-index: 100;
            left: 26px;
            position: absolute;
            top: 56px;
            width: 458px;
            height: 788px;
            margin-right: 4px;
        }
        .auto-style2 {
            z-index: 1;
            left: 504px;
            top: 78px;
            position: absolute;
            height: 136px;
            width: 399px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    <asp:DataList ID="DataList1"
    runat="server" BackColor="White" BorderColor="#E7E7FF"
    BorderStyle="None" BorderWidth="1px" CellPadding="3"
    GridLines="Horizontal"
    OnItemCommand="DataList1_ItemCommand" Caption="Items in Inventory" CssClass="auto-style1" >
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<SelectedItemStyle BackColor="#738A9C"
      Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingItemStyle BackColor="#F7F7F7" />
<ItemStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
      <ItemTemplate>
      ID:
      <asp:Label ID="IDLabel"
      runat="server" Text='<%# Eval("ID") %>'></asp:Label><br />
      Title:
      <asp:Label ID="TitleLabel"
      runat="server" Text='<%# Eval("Title") %>'></asp:Label><br />
      AuthorLastName:
      <asp:Label ID="AuthorLastNameLabel"
      runat="server" Text='<%# Eval("AuthorLastName")
      %>'></asp:Label><br />
      AuthorFirstName:
      <asp:Label ID="AuthorFirstNameLabel"
      runat="server" Text='<%# Eval("AuthorFirstName")
      %>'></asp:Label><br />
      Topic:
      <asp:Label ID="TopicLabel" runat="server"
      Text='<%# Eval("Topic") %>'></asp:Label><br />
      Publisher:
      <asp:Label ID="PublisherLabel"
      runat="server"

      Text='<%# Eval("Publisher") %>'></asp:Label><br />
      <br />

    <asp:Button ID="SelectItem"

       runat="server" Text="Select Item" />

      &nbsp;
      </ItemTemplate>
         <HeaderStyle BackColor="#4A3C8C" Font-Bold="True"
            ForeColor="#F7F7F7" />
</asp:DataList>


        <br />
        <br />


    </div>
    <asp:GridView ID="GridView1" runat="server" CellPadding="4" 
        EnableModelValidation="True" ForeColor="#333333" GridLines="None" CssClass="auto-style2">
        <AlternatingRowStyle BackColor="White" />
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
    </asp:GridView>
    </form>
</body>
</html>

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;
using System.Data.Common;

namespace SessionState
{
    public partial class UseDataList : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DataTable dt = BindToinventory();
                DataTable tableSelectedItems =
                   this.CreateSelectedItemsTable(dt);
                Session["tableSelectedItems"] = tableSelectedItems;
            }
        }


        protected DataTable GetInventory()
        {
            string strConnection =
            @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="""+ AppDomain.CurrentDomain.BaseDirectory + @"App_Data\ASPNETStepByStep4.mdf"";Integrated Security=True";

            DbProviderFactory f =
               DbProviderFactories.GetFactory("System.Data.SqlClient");

            DataTable dt = new DataTable();
            using (DbConnection connection = f.CreateConnection())
            {         
                connection.ConnectionString = strConnection;

                connection.Open();

                DbCommand command = f.CreateCommand();
                command.CommandText = "Select * from DotNetReferences";
                command.Connection = connection;

                IDataReader reader = command.ExecuteReader();

                dt.Load(reader);
                reader.Close();
                connection.Close();
            }

            return dt;
        }

        protected DataTable BindToinventory()
        {
            DataTable dt;
            dt = this.GetInventory();
            this.DataList1.DataSource = dt;

            this.DataBind();
            return dt;
        }

        protected DataTable CreateSelectedItemsTable(DataTable tableSchema)
        {

            DataTable tableSelectedItemsData = new DataTable();

            foreach (DataColumn dc in tableSchema.Columns)
            {
                tableSelectedItemsData.Columns.Add(dc.ColumnName,
                      dc.DataType);
            }
            return tableSelectedItemsData;

        }



        protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
            int nItemIndex = e.Item.ItemIndex;
            this.DataList1.SelectedIndex = nItemIndex;

            BindToinventory();

            DataTable dt = (DataTable)DataList1.DataSource;
            String strID = (dt.Rows[nItemIndex][0]).ToString();
            String strTitle = (dt.Rows[nItemIndex][1]).ToString();
            String strAuthorLastName = (dt.Rows[nItemIndex][2]).ToString();
            String strAuthorFirstName = (dt.Rows[nItemIndex][3]).ToString();
            String strTopic = (dt.Rows[nItemIndex][4]).ToString();
            String strPublisher = (dt.Rows[nItemIndex][5]).ToString();

            DataTable tableSelectedItems;
            tableSelectedItems = (DataTable)Session["tableSelectedItems"];

            DataRow dr = tableSelectedItems.NewRow();
            dr[0] = strID;
            dr[1] = strTitle;
            dr[2] = strAuthorLastName;
            dr[3] = strAuthorFirstName;
            dr[4] = strTopic;
            dr[5] = strPublisher;

            tableSelectedItems.Rows.Add(dr);

            Session["tableSelectedItems"] = tableSelectedItems;

            this.GridView1.DataSource = tableSelectedItems;
            this.GridView1.DataBind();
        }

    }
}

似水の流年_2019

关注

5
点赞
踩
34

收藏

觉得还不错? 一键收藏
1
评论
ASP.NET利用DataList实现从购物车添加商品

目录前言新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入前言最近在练习ASP.NET，创建一个购物网站时用到...
复制链接

扫一扫