更新日期行是个模板行txt文本框,点编辑之后获取显示当前时间(不用动态刷新),再点击后面的更新之后能保存到access库,新手请大家多多指教!
代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="shishi.aspx.cs" Inherits="WebSite1_shishi" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<br> .style1<br> {<br> width: 100%;<br> }<br> .style2<br> {<br> width: 567px;<br> }<br>
</div>
<table class="style1">
<tr>
<td class="style2">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="shijianID" DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="shijianID" HeaderText="shijianID"
InsertVisible="False" ReadOnly="True" SortExpression="shijianID" />
<asp:BoundField DataField="更新日期" HeaderText="更新日期" SortExpression="更新日期" />
<asp:BoundField DataField="名字" HeaderText="名字" SortExpression="名字" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/WebSite1/App_Data/xuesheng.mdb"
DeleteCommand="DELETE FROM [shijian] WHERE [shijianID] = ?"
InsertCommand="INSERT INTO [shijian] ([shijianID], [更新日期], [名字]) VALUES (?, ?, ?)"
SelectCommand="SELECT * FROM [shijian]"
UpdateCommand="UPDATE [shijian] SET [更新日期] =? , [名字] = ? WHERE [shijianID] = ?">
<DeleteParameters>
<asp:Parameter Name="shijianID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="shijianID" Type="Int32" />
<asp:Parameter Name="更新日期" Type="DateTime" />
<asp:Parameter Name="名字" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="更新日期" Type="DateTime" />
<asp:Parameter Name="名字" Type="String" />
<asp:Parameter Name="shijianID" Type="Int32" />
</UpdateParameters>
</asp:AccessDataSource>
</td>
<td>
</td>
</tr>
<tr>
<td class="style2">
</td>
<td>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"
DataKeyNames="shijianID" DataSourceID="AccessDataSource1" Height="50px"
Width="125px" >
<Fields>
<asp:BoundField DataField="shijianID" HeaderText="shijianID"
InsertVisible="False" ReadOnly="True" SortExpression="shijianID" />
<asp:TemplateField HeaderText="更新日期" SortExpression="更新日期">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("更新日期") %>'>
></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("更新日期") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("更新日期") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="名字" HeaderText="名字" SortExpression="名字" />
<asp:TemplateField 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>
</Fields>
</asp:DetailsView>
</td>
</tr>
</table>
</form>