📄 default5.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="FENLEI1" HeaderText="FENLEI1" SortExpression="FENLEI1" />
<asp:BoundField DataField="FENLEI2" HeaderText="FENLEI2" SortExpression="FENLEI2" />
<asp:BoundField DataField="MINGCHENG" HeaderText="MINGCHENG" SortExpression="MINGCHENG" />
</Columns>
</asp:GridView>
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="全部更新" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="全部编辑" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:test %>"
DeleteCommand="DELETE FROM [FLASH] WHERE [ID] = ?" InsertCommand="INSERT INTO [FLASH] ([ID], [FENLEI1], [FENLEI2], [MINGCHENG]) VALUES (?, ?, ?, ?)"
ProviderName="<%$ ConnectionStrings:test.ProviderName %>" SelectCommand="SELECT [ID], [FENLEI1], [FENLEI2], [MINGCHENG] FROM [FLASH]"
UpdateCommand="UPDATE [FLASH] SET [FENLEI1] = ?, [FENLEI2] = ?, [MINGCHENG] = ? WHERE [ID] = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="FENLEI1" Type="String" />
<asp:Parameter Name="FENLEI2" Type="String" />
<asp:Parameter Name="MINGCHENG" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="FENLEI1" Type="String" />
<asp:Parameter Name="FENLEI2" Type="String" />
<asp:Parameter Name="MINGCHENG" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<br />
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -