?? morenews.aspx
字號:
?<%@ Page Language="C#" AutoEventWireup="true" CodeFile="moreNews.aspx.cs" Inherits="moreNews" %>
<%@ Register Src="mycontroler/head.ascx" TagName="head" TagPrefix="uc1" %>
<%@ Register Src="mycontroler/foot.ascx" TagName="foot" TagPrefix="uc2" %>
<!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 style="background-image: url(image/back.jpg)" scroll="yes">
<form id="form1" runat="server">
<div>
<table width=100% border="0" style="background-color: #999933;">
<tr>
<td style="background-image: url(image/head.png); width: 1051px; vertical-align: middle; height: 247px; text-align: center;"></td>
</tr>
<tr>
<td style="width: 1051px; height: 33px;">
<uc1:head ID="Head1" runat="server" />
</td>
</tr>
<tr>
<td height="536" style="width: 100%; text-align: center; vertical-align: top;">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:voteConnectionString2 %>"
DeleteCommand="DELETE FROM [newNRB] WHERE [id] = @id" InsertCommand="INSERT INTO [newNRB] ([biaoti], [shijian]) VALUES (@biaoti, @shijian)"
SelectCommand="SELECT [id], [biaoti], [shijian] FROM [newNRB] ORDER BY [shijian] DESC" UpdateCommand="UPDATE [newNRB] SET [biaoti] = @biaoti, [shijian] = @shijian WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="biaoti" Type="String" />
<asp:Parameter Name="shijian" Type="DateTime" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="biaoti" Type="String" />
<asp:Parameter Name="shijian" Type="DateTime" />
</InsertParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="SqlDataSource1" Width="100%" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
<Columns>
<asp:BoundField DataField="biaoti" HeaderText="標題" SortExpression="biaoti" >
<HeaderStyle HorizontalAlign="Center" />
<FooterStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="shijian" HeaderText="發表時間" SortExpression="shijian" >
<HeaderStyle HorizontalAlign="Center" />
<FooterStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:CommandField SelectText="查看" ShowSelectButton="True" />
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td style="width: 1051px; vertical-align: middle; text-align: center; height: 35px;">
<uc2:foot ID="Foot1" runat="server" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -