<%@ Page Language="
C#" AutoEventWireup="true" CodeBehind="datasource2.aspx.cs" Inherits="WebApplication3.datasource2" %>
<!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>
<h2>商品信息管理</h2>
<asp:Label ID="lblProduct"
runat="
server" Text="选择商品："></asp:Label>
<asp:DropDownList ID="ddlProducts"
runat="
server" AutoPostBack="True" DataTextField="Name" DataValueField="ProductId"
OnSelectedIndexChanged="ddlProducts_SelectedIndexChanged">
</asp:DropDownList>
<br /><br />
<asp:Label ID="lblCategory"
runat="
server" Text="分类："></asp:Label>
<asp:DropDownList ID="ddlCategories"
runat="
server" DataTextField="Name" DataValueField="CategoryId"></asp:DropDownList>
<br /><br />
<asp:Label ID="lblListPrice"
runat="
server" Text="价格："></asp:Label>
<asp:TextBox ID="txtListPrice"
runat="
server"></asp:TextBox>
<br /><br />
<asp:Label ID="lblUnitCost"
runat="
server" Text="单价："></asp:Label>
<asp:TextBox ID="txtUnitCost"
runat="
server"></asp:TextBox>
<br /><br />
<asp:Label ID="lblSupplier"
runat="
server" Text="供应商："></asp:Label>
<asp:DropDownList ID="ddlSuppliers"
runat="
server" DataTextField="Name" DataValueField="SuppId"></asp:DropDownList>
<br /><br />
<asp:Label ID="lblName"
runat="
server" Text="商品名称："></asp:Label>
<asp:TextBox ID="txtName"
runat="
server"></asp:TextBox>
<br /><br />
<asp:Label ID="lblDescn"
runat="
server" Text="商品简介："></asp:Label>
<asp:TextBox ID="txtDescn"
runat="
server" TextMode="MultiLine"></asp:TextBox>
<br /><br />
<asp:Label ID="lblImage"
runat="
server" Text="图片："></asp:Label>
<asp:FileUpload ID="fuImage"
runat="
server" />
<br /><br />
<asp:Label ID="lblQty"
runat="
server" Text="数量："></asp:Label>
<asp:TextBox ID="txtQty"
runat="
server"></asp:TextBox>
<br /><br />
<asp:Label ID="lblDataSource"
runat="
server" Text="利用数据源控件："></asp:Label>
<asp:
Button ID="btnAdd"
runat="
server" Text="添加商品" OnClick="btnAdd_Click" />
<asp:
Button ID="btnUpdate"
runat="
server" Text="修改商品" OnClick="btnUpdate_Click" />
<asp:
Button ID="btnDelete"
runat="
server" Text="删除商品" OnClick="btnDelete_Click" />
<!-- 数据源控件 -->
<asp:SqlDataSource ID="sqlDSProducts"
runat="
server"
ConnectionString="<%$ ConnectionStrings:YourConnectionString %>"
SelectCommand="SELECT * FROM [Product]"
InsertCommand="INSERT INTO [Product] ([CategoryId], [ListPrice], [UnitCost], [SuppId], [Name], [Descn], [Image], [Qty]) VALUES (@CategoryId, @ListPrice, @UnitCost, @SuppId, @Name, @Descn, @Image, @Qty)"
UpdateCommand="UPDATE [Product] SET [CategoryId] = @CategoryId, [ListPrice] = @ListPrice, [UnitCost] = @UnitCost, [SuppId] = @SuppId, [Name] = @Name, [Descn] = @Descn, [Image] = @Image, [Qty] = @Qty WHERE [ProductId] = @ProductId"
DeleteCommand="DELETE FROM [Product] WHERE [ProductId] = @ProductId">
<InsertParameters>
<asp:ControlParameter Name="CategoryId" ControlID="ddlCategories" PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter Name="ListPrice" ControlID="txtListPrice" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter Name="UnitCost" ControlID="txtUnitCost" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter Name="SuppId" ControlID="ddlSuppliers" PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter Name="Name" ControlID="txtName" PropertyName="Text" Type="String" />
<asp:ControlParameter Name="Descn" ControlID="txtDescn" PropertyName="Text" Type="String" />
<asp:ControlParameter Name="Image" ControlID="fuImage" PropertyName="FileName" Type="String" />
<asp:ControlParameter Name="Qty" ControlID="txtQty" PropertyName="Text" Type="Int32" />
</InsertParameters>
<UpdateParameters>
<asp:ControlParameter Name="ProductId" ControlID="ddlProducts" PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter Name="CategoryId" ControlID="ddlCategories" PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter Name="ListPrice" ControlID="txtListPrice" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter Name="UnitCost" ControlID="txtUnitCost" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter Name="SuppId" ControlID="ddlSuppliers" PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter Name="Name" ControlID="txtName" PropertyName="Text" Type="String" />
<asp:ControlParameter Name="Descn" ControlID="txtDescn" PropertyName="Text" Type="String" />
<asp:ControlParameter Name="Image" ControlID="fuImage" PropertyName="FileName" Type="String" />
<asp:ControlParameter Name="Qty" ControlID="txtQty" PropertyName="Text" Type="Int32" />
</UpdateParameters>
<DeleteParameters>
<asp:ControlParameter Name="ProductId" ControlID="ddlProducts" PropertyName="SelectedValue" Type="Int32" />
</DeleteParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="sqlDSCategories"
runat="
server"
ConnectionString="<%$ ConnectionStrings:YourConnectionString %>"
SelectCommand="SELECT [CategoryId], [Name] FROM [Category]">
</asp:SqlDataSource>
<asp:SqlDataSource ID="sqlDSSuppliers"
runat="
server"
ConnectionString="<%$ ConnectionStrings:YourConnectionString %>"
SelectCommand="SELECT [SuppId], [Name] FROM [Supplier]">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
请对上述内容进行重写，并给出相应的cs代码。服务器为LAPTOP-8S143JCT，数据库为test5
本文详细介绍了在ASP.NET中使用runat属性时的注意事项，包括如何正确地使用<%=str%>输出变量，以及如何将HTML元素转换为服务器控件。文章还解释了不同上下文中runat属性的行为差异。
扫一扫
1544
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
