📄 delnewsinfo.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DelNewsInfo.aspx.cs" Inherits="NewsManage_DelNewsInfo" %>
<!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>
</div>
<table style="left: 3px; position: relative; top: 18px; width: 719px; height: 72px;">
<tr>
<td style="width: 235px; background-color: #507cd1">
新闻检索<asp:TextBox ID="TextBox2" runat="server" Style="left: 5px; position: relative;
top: 0px"></asp:TextBox></td>
<td style="width: 235px; background-color: #507cd1">
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
DataTextField="CLASSNAME" DataValueField="CLASSID" Style="position: relative" AppendDataBoundItems="True" >
<asp:ListItem Value="0">所有信息</asp:ListItem>
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:news_manageConnectionString2 %>"
SelectCommand="SELECT [CLASSID], [CLASSNAME] FROM [t_Class]"></asp:SqlDataSource>
</td>
<td style="width: 235px; background-color: #507cd1">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Style="position: relative"
Text="搜索" /></td>
</tr>
</table>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None" Height="157px"
Width="719px" OnRowDataBound="GridView1_RowDataBound1" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" AllowPaging="True" PageSize="5">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="NEWSID" HeaderText="编号" InsertVisible="False" ReadOnly="True"
SortExpression="NEWSID" />
<asp:BoundField DataField="NEWSTITLE" HeaderText="新闻标题" SortExpression="NEWSTITLE" />
<asp:BoundField DataField="CLASSID" HeaderText="新闻类别" SortExpression="CLASSID" />
<asp:BoundField DataField="NEWSDATE" HeaderText="发布时间" SortExpression="NEWSDATE" />
<asp:BoundField DataField="NEWSOURCE" HeaderText="来源" SortExpression="NEWSOURCE" />
<asp:BoundField DataField="HITS" HeaderText="点击量" SortExpression="HITS" />
<asp:CommandField HeaderText="修改" ShowEditButton="True" ButtonType="Image" CancelImageUrl="~/Image/cancel.png" DeleteImageUrl="~/Image/icon_del.gif" EditImageUrl="~/Image/edit.gif" UpdateImageUrl="~/Image/update.png" />
<asp:TemplateField HeaderText="删除" ShowHeader="False">
<ItemTemplate>
<asp:ImageButton ID="ImageButton1" runat="server" CausesValidation="False" CommandName="Delete"
ImageUrl="~/Image/icon_del.gif" OnClientClick="return confirm ('确定删除数据行？')" Text="删除" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:news_manageConnectionString6 %>" DeleteCommand="DELETE FROM [t_News] WHERE [NEWSID] = @original_NEWSID AND [NEWSTITLE] = @original_NEWSTITLE AND [CLASSID] = @original_CLASSID AND [NEWSDATE] = @original_NEWSDATE AND [NEWSOURCE] = @original_NEWSOURCE AND [HITS] = @original_HITS"
InsertCommand="INSERT INTO [t_News] ([NEWSTITLE], [CLASSID], [NEWSDATE], [NEWSOURCE], [HITS]) VALUES (@NEWSTITLE, @CLASSID, @NEWSDATE, @NEWSOURCE, @HITS)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [NEWSID], [NEWSTITLE], [CLASSID], [NEWSDATE], [NEWSOURCE], [HITS] FROM [t_News]"
UpdateCommand="UPDATE [t_News] SET [NEWSTITLE] = @NEWSTITLE, [CLASSID] = @CLASSID, [NEWSDATE] = @NEWSDATE, [NEWSOURCE] = @NEWSOURCE, [HITS] = @HITS WHERE [NEWSID] = @original_NEWSID AND [NEWSTITLE] = @original_NEWSTITLE AND [CLASSID] = @original_CLASSID AND [NEWSDATE] = @original_NEWSDATE AND [NEWSOURCE] = @original_NEWSOURCE AND [HITS] = @original_HITS">
<DeleteParameters>
<asp:Parameter Name="original_NEWSID" Type="Int32" />
<asp:Parameter Name="original_NEWSTITLE" Type="String" />
<asp:Parameter Name="original_CLASSID" Type="Int32" />
<asp:Parameter Name="original_NEWSDATE" Type="DateTime" />
<asp:Parameter Name="original_NEWSOURCE" Type="String" />
<asp:Parameter Name="original_HITS" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="NEWSTITLE" Type="String" />
<asp:Parameter Name="CLASSID" Type="Int32" />
<asp:Parameter Name="NEWSDATE" Type="DateTime" />
<asp:Parameter Name="NEWSOURCE" Type="String" />
<asp:Parameter Name="HITS" Type="Int32" />
<asp:Parameter Name="original_NEWSID" Type="Int32" />
<asp:Parameter Name="original_NEWSTITLE" Type="String" />
<asp:Parameter Name="original_CLASSID" Type="Int32" />
<asp:Parameter Name="original_NEWSDATE" Type="DateTime" />
<asp:Parameter Name="original_NEWSOURCE" Type="String" />
<asp:Parameter Name="original_HITS" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="NEWSTITLE" Type="String" />
<asp:Parameter Name="CLASSID" Type="Int32" />
<asp:Parameter Name="NEWSDATE" Type="DateTime" />
<asp:Parameter Name="NEWSOURCE" Type="String" />
<asp:Parameter Name="HITS" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<br />
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -