theproduct.aspx
来自「用VB实现」· ASPX 代码 · 共 80 行
ASPX
80 行
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
id="dsProducts"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_conn") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_conn") %>'
CommandText='<%# "SELECT * FROM Products" %>'
Debug="true" PageSize="10"
>
<EditOps>
<EditOpsTable Name="Products" />
<Parameter Name="ProductName" Type="VarWChar" />
<Parameter Name="UnitPrice" Type="Integer" />
<Parameter Name="ProductID" Type="Integer" IsPrimary="true" />
</EditOps>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>设定编辑字段</title>
</head>
<body>
<form runat="server">
<asp:DataGrid id="dgProducts"
runat="server"
AllowSorting="False"
AutoGenerateColumns="false"
CellPadding="3"
CellSpacing="0"
ShowFooter="false"
ShowHeader="true"
DataSource="<%# dsProducts.DefaultView %>"
PagerStyle-Mode="NextPrev"
AllowPaging="true"
AllowCustomPaging="true"
PageSize="<%# dsProducts.PageSize %>"
VirtualItemCount="<%# dsProducts.RecordCount %>"
OnPageIndexChanged="dsProducts.OnDataGridPageIndexChanged"
DataKeyField="ProductID"
onCancelCommand="dsProducts.OnDataGridCancel"
onEditCommand="dsProducts.OnDataGridEdit"
onUpdateCommand="dsProducts.OnDataGridUpdate"
onItemDataBound="dsProducts.OnDataGridItemDataBound"
>
<HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<FooterStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<Columns>
<asp:BoundColumn DataField="ProductID"
HeaderText="商品编号"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="ProductName"
HeaderText="商品名称"
ReadOnly="false"
Visible="True"/>
<asp:BoundColumn DataField="UnitPrice"
HeaderText="单价"
ReadOnly="false"
Visible="True"/>
<asp:EditCommandColumn
ButtonType="PushButton"
CancelText="取消"
EditText="编辑"
HeaderText="变更"
UpdateText="更新"
Visible="True"/>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?