62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GridView1" runat="server" DataSourceID="runningDataSource1"
Width="800px" EmptyDataText="没有可显示的数据..."
AllowPaging="True" AutoGenerateColumns="False" CellPadding="4"
ForeColor="#333333" GridLines="None" >
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Title" HeaderText="任务名称" ReadOnly="True"
SortExpression="Title" />
<asp:BoundField DataField="neirong" HeaderText="任务内容" ReadOnly="True"
SortExpression="neirong" />
<asp:BoundField DataField="tbegin" HeaderText="开始时间" ReadOnly="True"
SortExpression="tbegin" />
<asp:BoundField DataField="beizhu" HeaderText="备注" ReadOnly="False"
SortExpression="beizhu" />
<asp:CheckBoxField DataField="finflag" HeaderText="完成" ReadOnly="False"
SortExpression="finflag" />
<asp:CommandField ButtonType="Button" EditText="操作" HeaderText="结束任务"
ShowEditButton="True" ShowHeader="True" UpdateText="结束" />
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#999999" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<asp:SqlDataSource ID="runningDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:gscConnectionString %>"
SelectCommand="SELECT [tID], [countable], [Title], [neirong], [tbegin], [tend], [beizhu], [finflag], [Maker] FROM [task_log] WHERE ([Maker] = @Maker)"
UpdateCommand="Update [task_log] set [beizhu] = @beizhu, [finflag] = @finflag, [tend]=@tend WHERE ([tID] = @tID)">
<SelectParameters>
<asp:SessionParameter Name="Maker" SessionField="UserName" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="tID" Type="Int32" />
<asp:Parameter Name="beizhu" Type="String" />
<asp:Parameter Name="finflag" Type="Boolean" />
<asp:Parameter Name="tend" Type="DateTime" />
</UpdateParameters>
</asp:SqlDataSource>