建立数据库 一张表leixing 一张表zhengwen
设置外键GID
打开VS建立ASP.NET应用程序项目
点击项目右键添加点击ADO.NET实体数据模型
建立Web窗体Index.aspx,在界面中显示数据
界面代码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="APP.Index" %>
<!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:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>服装</asp:ListItem>
<asp:ListItem>C#</asp:ListItem>
<asp:ListItem>Java</asp:ListItem>
<asp:ListItem>明星</asp:ListItem>
<asp:ListItem>游戏</asp:ListItem>
<asp:ListItem>生活</asp:ListItem>
</asp:DropDownList>
<asp:HyperLink NavigateUrl="~/Add.aspx" ID="HyperLink1" runat="server">写文章</asp:HyperLink><br />
<table border="1">
<tr>
<td>标题</td>
<td>作者</td>
<td>时间</td>
<td>正文</td>
<td>类别</td>
</tr>
<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand" >
<ItemTemplate>
<tr>
<td><%# Eval("title")%></td>
<td><%# Eval("author")%></td>
<td><%# Eval("stock")%></td>
<td><asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("cen")%>'><%# Eval("cen")%></asp:LinkButton></td>
<td><%# Eval("GID").ToString()%></td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>
</div>
</form>
</body>
</html>
绑定数据代码
添加页面 建立Web窗体 Add.aspx页面实行跳转
添加页面代码
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Add.aspx.cs" Inherits="APP.Add" %>
<!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:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<br />
作者:<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<br />
<br />
时间:<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
<br />
<br />
类型:<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>服装</asp:ListItem>
<asp:ListItem>C#</asp:ListItem>
<asp:ListItem>Java</asp:ListItem>
<asp:ListItem>明星</asp:ListItem>
<asp:ListItem>游戏</asp:ListItem>
<asp:ListItem>生活</asp:ListItem>
</asp:DropDownList>
<br />
<br />
正文:<asp:TextBox ID="TextBox4" runat="server" Height="49px" Width="156px"></asp:TextBox>
<br />
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="添加" />
</div>
</form>
</body>
</html>