程序博客网 > 网络浏览器是一种

求实现datagrid 第一页，最后一页

来源：互联网发布：网络浏览器是一种编辑：程序博客网时间：2024/04/26 17:01

前台

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="goodgl.aspx.cs" Inherits="yonghugl" %>

<!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>
    <form id="form1" runat="server">
    <div>
        <asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">返回</asp:LinkButton>
        <asp:Image ID="Image1" runat="server" ImageUrl="~/Images/title.jpg" Height="143px" Width="100%" ImageAlign="Top"/>
   </div>
    <div>
    <table>
    <asp:DataGrid ID="dgNotice" runat="server" DataKeyField="GoodsId"
AllowPaging="true" PageSize="5" AutoGenerateColumns="false"
            OnPageIndexChanged="dgNotice_PageIndexChanged" Width="585px"
            ondeletecommand="dgNotice_DeleteCommand" >
            <Columns>
                <asp:BoundColumn DataField="GoodsId" HeaderText="商品ID">
                    <HeaderStyle BackColor="ActiveBorder" HorizontalAlign="center" />
                    <ItemStyle HorizontalAlign="center" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="GoodsTitle" HeaderText="商品名称" >
                    <HeaderStyle BackColor="Aqua" HorizontalAlign="Center"/>
                    <ItemStyle HorizontalAlign="center" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="Content" HeaderText="描述">
                    <HeaderStyle BackColor="ActiveBorder" HorizontalAlign="center" />
                    <ItemStyle HorizontalAlign="center" />
                </asp:BoundColumn>

                <asp:BoundColumn DataField="ContractMan" HeaderText="上传者">
                    <HeaderStyle BackColor="ActiveBorder" HorizontalAlign="center" />
                    <ItemStyle HorizontalAlign="center" />
                </asp:BoundColumn>
                <asp:TemplateColumn HeaderText="删除">
      <HeaderStyle HorizontalAlign="center" Width="40px" BackColor="ActiveBorder" />
      <ItemStyle HorizontalAlign="center" />
      <ItemTemplate >
<asp:LinkButton ID="sc" runat="server" CommandName="delete">
  <img src="../image/delete.gif" />
</asp:LinkButton>
      </ItemTemplate>
</asp:TemplateColumn>
            </Columns>
            <PagerStyle Mode="NumericPages" />
        </asp:DataGrid>
</table>
<table >

</table>
</div>
</form>
</body>
</html>

后台

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;

public partial class yonghugl : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        NoticeDataBind();
    }
    protected void NoticeDataBind()
    {
        string sql;
        sql = "select * from Goods ";
        DataTable dt = Class1.GetDsFromSql(sql).Tables[0];
        dgNotice.DataSource = dt;
        dgNotice.DataBind();
    }

    protected void dgNotice_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        dgNotice.CurrentPageIndex = e.NewPageIndex;
        NoticeDataBind();

    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Server.Transfer("guanli.aspx");

    }
    protected void dgNotice_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        string id = dgNotice.DataKeys[e.Item.ItemIndex].ToString();
        string sqlStr = "delete from Goods where ";
        sqlStr += "GoodsId='" + id.ToString() + "'";
        if (Class1.ExecuteSql(sqlStr))
        {
            NoticeDataBind();
        }
        else
        {

        }

}
}

网络浏览器是一种

网络浏览器是一种

原创粉丝点击

热门问题 老师的惩罚人脸识别我在镇武司摸鱼那些年重生之率土为王我在大康的咸鱼生活盘龙之生命进化天生仙种凡人之先天五行春回大明朝姑娘不必设防，我是瞎子 ping不稳定怎么办 lolping值过高怎么办斐济签证怎么办 esb赛澳递没有怎么办 skinstore丢件怎么办 network error怎么办自卑社交恐惧怎么办 png图片打不开怎么办二级网页打不开怎么办没有ghost界面怎么办桌面不见了怎么办自动柜员机吞钱怎么办自动柜员机吞卡怎么办 app打开慢怎么办 appstore连不上怎么办 appstore打不开怎么办视频没有进度条怎么办遇到歹徒怎么办安装ios10出错怎么办 beta版本过期怎么办 beta已过期怎么办 toner low怎么办 toner left怎么办 windows未能启动怎么办店铺流量低怎么办大额贷款还不上怎么办我想大额贷款怎么办局域网arp攻击怎么办担保公司不还钱怎么办绿本丢失怎么办担保人无力偿还怎么办找不到担保人怎么办 p2p倒闭资金怎么办珠宝贷大标怎么办 p2p穿透模式怎么办 winpcap加载失败怎么办安装winpcap后怎么办 ssl认证错误怎么办受到arp攻击怎么办网络控制器叹号怎么办电脑被监视怎么办