📄 diarylist.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DiaryList.aspx.cs" Inherits="DiaryList" %>
<!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>
<link href="css/css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<br />
<asp:Panel ID="Panel1" runat="server" Height="324px" align="center" Width="614px">
<asp:GridView ID="GridView1" runat="server" Width="578px" AllowPaging="True" AutoGenerateColumns="False" BorderColor="Silver" DataKeyNames="ID" DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound" PageSize="9">
<PagerSettings FirstPageText="第一页" LastPageText="最后一页" Mode="NextPreviousFirstLast"
NextPageText="下一页" PageButtonCount="9" PreviousPageText="上一页" />
<Columns>
<asp:BoundField DataField="Diary_Title" HeaderText="日记标题" SortExpression="Diary_Title" />
<asp:TemplateField HeaderText="日记内容" >
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Diary_Content") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<a href="#" onclick="window.open('<%# "Diary_Details.aspx?ID="+Eval("ID") %>','_blank','left=210,top=120,width=400,height=200')">查看详细内容 </a>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Diary_Date" DataFormatString="{0:d}" HeaderText="日期" SortExpression="Diary_Date" />
<asp:TemplateField HeaderText="心情" SortExpression="Mood">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Mood") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "Images/"+Eval("Mood")+".gif" %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" ShowHeader="True" />
</Columns>
<RowStyle HorizontalAlign="Center" VerticalAlign="Middle" />
<PagerStyle BackColor="#C0FFFF" HorizontalAlign="Center" VerticalAlign="Middle" />
<HeaderStyle BackColor="#C0FFFF" Font-Size="12px" HorizontalAlign="Center" VerticalAlign="Middle" />
<AlternatingRowStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:GridView>
</asp:Panel>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:conString %>"
SelectCommand="SELECT * FROM [Diary] WHERE ([Employee] = @Employee) ORDER BY [Diary_Date] DESC" DeleteCommand="DELETE FROM [Diary] WHERE [ID] = @ID" InsertCommand="INSERT INTO [Diary] ([Employee], [Diary_Title], [Diary_Content], [Diary_Date], [Mood]) VALUES (@Employee, @Diary_Title, @Diary_Content, @Diary_Date, @Mood)" UpdateCommand="UPDATE [Diary] SET [Employee] = @Employee, [Diary_Title] = @Diary_Title, [Diary_Content] = @Diary_Content, [Diary_Date] = @Diary_Date, [Mood] = @Mood WHERE [ID] = @ID">
<SelectParameters>
<asp:SessionParameter Name="Employee" SessionField="Name" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Employee" Type="String" />
<asp:Parameter Name="Diary_Title" Type="String" />
<asp:Parameter Name="Diary_Content" Type="String" />
<asp:Parameter Name="Diary_Date" Type="DateTime" />
<asp:Parameter Name="Mood" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Employee" Type="String" />
<asp:Parameter Name="Diary_Title" Type="String" />
<asp:Parameter Name="Diary_Content" Type="String" />
<asp:Parameter Name="Diary_Date" Type="DateTime" />
<asp:Parameter Name="Mood" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -