【jackyrong】asp.net 2.0常见问题技2

 一个detailview控件,用第一笔,上一笔,下一笔,最后一笔显示记录，还有可以有编辑,添加,删除等功能,还可以根据下拉列表显示页数的一个程序.作为备用之用,而且是无刷新的.
 
       

           
           
           

CellPadding="4" DataKeyNames="员工号码" DataSourceID="LimingStudio" ForeColor="#333333"                                     GridLines="None" Height="50px" Width="608px" nDataBound="DetailsView1_DataBound"                                     nItemDeleted="DetailsView1_ItemDeleted" nItemInserted="DetailsView1_ItemInserted"                                     nItemUpdated="DetailsView1_ItemUpdated" nPageIndexChanging="DetailsView1_PageIndexChanging">                                                                                                                                                                                                                                                                                                             SortExpression="员工号码">                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 男                                                     女                                                                                                                                                                                                                                             男                                                     女                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             HeaderText="出生日期：" HtmlEncode="False" SortExpression="出生日期">                                                                                                                                                                                                                                                                               已婚                                                     未婚                                                                                                                                                                                                                                             已婚                                                     未婚                                                                                                                                                                                                                                                                                                                                                                                                             HeaderText="到职日期：" HtmlEncode="False" SortExpression="到职日期">                                                                                                                                                                                                                                                                                                                                                                                                                                 HeaderText="加薪日期：" HtmlEncode="False" SortExpression="加薪日期">                                                                                                                                                                                                                                                                             DataTextField="部门" DataValueField="部门" SelectedValue=''>                                                                                                                                                                                                                                             DataTextField="部门" DataValueField="部门" SelectedValue=''>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Text="更新" BackColor="White">                                                                                                     Text="取消" BackColor="White">                                                                                                                                                                                             Text="插入" BackColor="White">                                                                                                     Text="取消" BackColor="White">                                                                                                                                                                                                                                         Text="编辑">                                                                                                     Text="添加">                                                                                                     nClientClick="return confirm('您确定要删除此笔数据纪录吗?');" Text="删除">                                                                                                                                                                                                                                                                                                                 Mode="NextPreviousFirstLast" NextPageImageUrl="~/Images/Next.gif" PreviousPageImageUrl="~/Images/Previous.gif" />                                                                                                                                 移至第                                                                                                         笔                                                     第一笔                                                     上一笔                                                     下一笔                                                     最后一笔                                                                                                                                                                                                                                                                                             DeleteCommand="DELETE FROM [章立民工作室] WHERE [员工号码] = @员工号码" InsertCommand="INSERT INTO [章立民工作室] ([身份证号码], [姓名], [性别], [地址], [邮政编码], [出生日期], [婚姻状况], [到职日期], [起薪], [目前薪资], [加薪日期], [部门]) VALUES (@身份证号码, @姓名, @性别, @地址, @邮政编码, @出生日期, @婚姻状况, @到职日期, @起薪, @目前薪资, @加薪日期, @部门)"                                     SelectCommand="SELECT * FROM [章立民工作室] " UpdateCommand="UPDATE [章立民工作室] SET [身份证号码] = @身份证号码, [姓名] = @姓名, [性别] = @性别, [地址] = @地址, [邮政编码] = @邮政编码, [出生日期] = @出生日期, [婚姻状况] = @婚姻状况, [到职日期] = @到职日期, [起薪] = @起薪, [目前薪资] = @目前薪资, [加薪日期] = @加薪日期, [部门] = @部门 WHERE [员工号码] = @员工号码">                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             SelectCommand="SELECT DISTINCT [部门] FROM [章立民工作室]">

       

   

 

protected void DetailsView1_DataBound(object sender, EventArgs e)
    {
        // 取得显示页数的那一列。
        DetailsViewRow pagerRow = this.DetailsView1.BottomPagerRow;

        // 取得"第一笔"、"上一笔"、"下一笔"与"最后一笔"的超级链接按钮。
        LinkButton lnkBtnFirst = (LinkButton)(pagerRow.Cells[0].FindControl("lnkBtnFirst"));
        LinkButton lnkBtnPrev = (LinkButton)(pagerRow.Cells[0].FindControl("lnkBtnPrev"));
        LinkButton lnkBtnNext = (LinkButton)(pagerRow.Cells[0].FindControl("lnkBtnNext"));
        LinkButton lnkBtnLast = (LinkButton)(pagerRow.Cells[0].FindControl("lnkBtnLast"));

        // 设定何时应该启用或停用"第一笔"、"上一笔"、"下一笔"与"最后一笔"的超级链接按钮。
        if (this.DetailsView1.PageIndex == 0)
        {
            lnkBtnFirst.Enabled = false;
            lnkBtnPrev.Enabled = false;
        }
        else if (this.DetailsView1.PageIndex == this.DetailsView1.PageCount - 1)
        {
            lnkBtnLast.Enabled = false;
            lnkBtnNext.Enabled = false;
        }
        else if (this.DetailsView1.PageCount <= 0)
        {
            lnkBtnFirst.Enabled = false;
            lnkBtnPrev.Enabled = false;
            lnkBtnNext.Enabled = false;
            lnkBtnLast.Enabled = false;
        }

<

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12639172/viewspace-332345/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12639172/viewspace-332345/