📄 输入与删除.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="输入与删除.aspx.vb" Inherits="Default2" %>
<!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"
DataSourceID="SqlDataSource1" Width="648px">
<Columns>
<asp:TemplateField HeaderText="编号" InsertVisible="False" SortExpression="编号">
<EditItemTemplate>
<asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("编号") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox6"
ErrorMessage="此项不能为空！"></asp:RequiredFieldValidator>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("编号") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="花名" SortExpression="花名">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("花名") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("花名") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="科" SortExpression="科">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("科") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("科") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="属" SortExpression="属">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("属") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("属") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="花语" SortExpression="花语">
<EditItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("花语") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# Bind("花语") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="图片" SortExpression="图片">
<EditItemTemplate>
<asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("图片") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label6" runat="server" Text='<%# Bind("图片") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="选择" ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Select"
Text="选择"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="删除" ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Delete"
Text="删除"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<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="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"
Text="编辑"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:NorthwindChConnectionString %>" DeleteCommand="DELETE FROM [花] WHERE [编号] = @original_编号 AND [花名] = @original_花名 AND [科] = @original_科 AND [属] = @original_属 AND [花语] = @original_花语 AND [图片] = @original_图片"
InsertCommand="INSERT INTO [花] ([花名], [科], [属], [花语], [图片]) VALUES (@花名, @科, @属, @花语, @图片)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [花]"
UpdateCommand="UPDATE [花] SET [花名] = @花名, [科] = @科, [属] = @属, [花语] = @花语, [图片] = @图片 WHERE [编号] = @original_编号 AND [花名] = @original_花名 AND [科] = @original_科 AND [属] = @original_属 AND [花语] = @original_花语 AND [图片] = @original_图片">
<DeleteParameters>
<asp:Parameter Name="original_编号" Type="Int32" />
<asp:Parameter Name="original_花名" Type="String" />
<asp:Parameter Name="original_科" Type="String" />
<asp:Parameter Name="original_属" Type="String" />
<asp:Parameter Name="original_花语" Type="String" />
<asp:Parameter Name="original_图片" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="花名" Type="String" />
<asp:Parameter Name="科" Type="String" />
<asp:Parameter Name="属" Type="String" />
<asp:Parameter Name="花语" Type="String" />
<asp:Parameter Name="图片" Type="String" />
<asp:Parameter Name="original_编号" Type="Int32" />
<asp:Parameter Name="original_花名" Type="String" />
<asp:Parameter Name="original_科" Type="String" />
<asp:Parameter Name="original_属" Type="String" />
<asp:Parameter Name="original_花语" Type="String" />
<asp:Parameter Name="original_图片" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="花名" Type="String" />
<asp:Parameter Name="科" Type="String" />
<asp:Parameter Name="属" Type="String" />
<asp:Parameter Name="花语" Type="String" />
<asp:Parameter Name="图片" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<br />
<br />
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -