asp.net 4.5 练习~test9-8

最新推荐文章于 2024-09-17 08:07:57 发布

虾米大王

最新推荐文章于 2024-09-17 08:07:57 发布

阅读量166

点赞数

分类专栏： asp.net c# 文章标签： c#

本文链接：https://blog.csdn.net/modern358/article/details/114639246

版权

c# 同时被 2 个专栏收录

284 篇文章 0 订阅

订阅专栏

asp.net

258 篇文章 2 订阅

订阅专栏

webform1.aspx

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DataList ID="DataList1" runat="server" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" ForeColor="Black" GridLines="Both" RepeatColumns="3" OnSelectedIndexChanged="DataList1_SelectedIndexChanged">
            <FooterStyle BackColor="#CCCCCC" />
            <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
            <ItemStyle BackColor="White" />
            <SelectedItemStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
            <ItemTemplate>
                商品名称：<asp:Label ID="Label1" runat="server" Text='<%# Eval("sp_name") %>'></asp:Label>
                <asp:LinkButton ID="LinkButton1" runat="server" CommandName="select" Text="选择"></asp:LinkButton>
            </ItemTemplate>
            <SelectedItemTemplate>
                商品名称：<asp:Label ID="Label2" runat="server" Text='<%# Eval("sp_name") %>'></asp:Label><br />
                商品价格：<asp:Label ID="Label3" runat="server" Text='<%# Eval("sp_price") %>'></asp:Label><br />
                商品单位：<asp:Label ID="Label4" runat="server" Text='<%# Eval("sp_type") %>'></asp:Label><br />
            </SelectedItemTemplate>
        </asp:DataList>
    </div>
    </form>
</body>
</html>

webform1.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;

namespace test9_8
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //数据库连接字符串
            string connectionString = @"Data Source=LAPTOP-AQKEN65V\SQLEXPRESS08;Initial Catalog=db_CoffeeManagement;User ID=sa;Password=123456;";
            SqlConnection myCon = new SqlConnection(connectionString);
            myCon.Open();
 
            //查询sql
            string selectSql = "select * from tb_shangPin";
            SqlDataAdapter adapter = new SqlDataAdapter(selectSql, myCon);
            System.Data.DataSet myDs = new System.Data.DataSet();
            adapter.Fill(myDs);
 
            //绑定数据
            DataList1.DataSource = myDs;
            DataList1.DataBind();
        }

        protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            
        }
    }
}

sql

CREATE DATABASE db_CoffeeManagement;
USE db_CoffeeManagement;
GO;

CREATE TABLE tb_shangPin(
sp_id int identity(1,1) not null primary key,
sp_name nvarchar(50) not null,
sp_price money,
sp_type nchar(10)
);