首先看數據庫的代碼：

-- 創建數據庫 create database musicdb use musicdb -- 創建表 -- 用戶表 create table [user]( uid int primary key identity(1,1), name varchar(20) not null, pwd varchar(20) not null, [desc] varchar(50) ) create table music( mid int primary key identity(101,1), musicName varchar(50) not null, singer varchar(20) not null, --歌手 album varchar(20) not null, --專輯 timer varchar(20), --時長 position varchar(100), --位置 ) select * from music select * from [user]

然後vs2019 創建AspNet Web項目，添加Default.aspx

有一定基礎的同學，應該知道，AspNet 分兩部分，一部分是前台界面，另一部分是後台代碼，Aspnet使用了CodeBehind 代碼後置的技術

Default.aspx 前台設計界面：

<div class="row"> <h3 class="text-center" style="color: orange">音樂庫 管理</h3> </div> <div class="row"> <asp:GridView ID="GridView1" runat="server" CssClass="table table-hover table-striped" AutoGenerateColumns="False" OnRowCommand="GridView1_RowCommand" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" DataKeyNames="mid" OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit"> <Columns> <asp:BoundField DataField="mid" HeaderText="序号" /> <asp:BoundField DataField="musicName" HeaderText="歌曲名" /> <asp:BoundField DataField="singer" HeaderText="歌手" /> <asp:BoundField DataField="album" HeaderText="專輯" /> <asp:BoundField DataField="timer" HeaderText="時長" /> <asp:BoundField DataField="position" HeaderText="存儲位置" /> <asp:TemplateField HeaderText="操作" ShowHeader="False"> <EditItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="更新"></asp:LinkButton> <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="取消"></asp:LinkButton> </EditItemTemplate> <ItemTemplate> <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Edit" Text="修改"></asp:LinkButton> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete" Text="删除"></asp:LinkButton> <a href="/add.aspx">插入</a> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </div>

Default.aspx.cs 後台代碼

public partial class _Default : Page { public string name = ""; protected void Page_Load(object sender, EventArgs e) // 首次加載 { if (!IsPostBack) { if (Session["userName"]==null) { Response.Redirect("~/login.aspx"); } else { name = Session["userName"].ToString(); LoadMusic(); } } } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string id = GridView1.Rows[e.RowIndex].Cells[0].Text; string sql = $"delete from music where mid='{id}'"; if (DBHelper.Update(sql)) { LoadMusic(); } else { Response.Write("<script>alert('删除失敗！')</script>"); } } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { //string mid = e.CommandArgument.ToString(); name = Session["userName"].ToString(); GridView1.EditIndex = e.NewEditIndex; LoadMusic(); } private void LoadMusic() { this.GridView1.DataSource = DBHelper.Select("select * from music"); this.GridView1.DataBind(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string id = this.GridView1.DataKeys[e.RowIndex].Value.ToString(); string name = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text; string signer= ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text; string album= ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text; string timer= ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text; string p= ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text; string sql = $"update music set musicName='{name}',singer='{signer}',album='{album}',timer='{timer}',position='{p}' where mid='{id}'"; if (DBHelper.Update(sql)) { Response.Write("<script>alert('修改成功！')</script>"); LoadMusic(); } } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { name = Session["userName"].ToString(); GridView1.EditIndex = -1; LoadMusic(); } }

效果圖

以上就是首頁完成的顯示的功能，篇幅有限，需要源碼的朋友私聊我噢

千山萬水總是情，打賞一元也是情

和老段一起終身學習，我們一起做自己的CEO！

更多精彩资讯请关注tft每日頭條，我们将持续为您更新最新资讯!