<div style="margin:auto">
current page: <asp:Label ID="lbCurrent" runat="server"></asp:Label>
<br />
Total pages: <asp:Label ID="lbTotal" runat="server"></asp:Label>
<asp:DataList ID="dlProduct" runat="server" OnItemCommand="dlProduct_ItemCommand">
<ItemTemplate>
<%#Eval("Pname") %>
<br />
<%#Eval("Pcolor") %>
<br />
<%#Eval("Pnewprice") %>
<br />
<%#Eval("Pcontent") %>
<br />
<asp:Button ID="btnDelectProduct" runat="server" Text="Delete"
CommandName="delete" CommandArgument='<%#Eval("Pid") %>' />
<br />
<br />
</ItemTemplate>
<SelectedItemTemplate>
<%#Eval("Pname") %>
<br />
<%#Eval("Pcolor") %>
<br />
<%#Eval("Pnewprice") %>
<br />
<%#Eval("Pcontent") %>
<br />
<asp:Button ID="btnDelectProduct" runat="server" Text="Delete"
CommandName="delete" CommandArgument='<%#Eval("Pid") %>' />
<br />
<img alt="." height="100" src="Image/M.jpg"/>
</SelectedItemTemplate>
</asp:DataList>
<br />
<asp:LinkButton ID="lbPrevious" runat="server"
OnCommand="IndexChange"
CommandArgument="previous"><</asp:LinkButton>
<asp:LinkButton ID="lbNext" runat="server"
OnCommand="IndexChange"
CommandArgument="next">></asp:LinkButton>
</div>
public partial class dlPage : System.Web.UI.Page
{
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["pageindex"] = "0";
BindData();
}
}
protected void PrepareData()
{
SqlConnection conn = ProjectDal.GetConnection();
conn.Open();
string sql = "select * from Tb_product";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
conn.Close();
}
protected void BindData()
{
PrepareData();
DataTable dt = ds.Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
DataView dv = dt.DefaultView;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dv;
pds.AllowPaging = true;
pds.PageSize = 3;
pds.CurrentPageIndex = int.Parse(ViewState["pageindex"].ToString());
if (!pds.IsFirstPage)
{
lbPrevious.Visible = true;
}
else
{
lbPrevious.Visible = false;
}
if (!pds.IsLastPage)
{
lbNext.Visible = true;
}
else
{
lbNext.Visible = false;
}
dlProduct.DataSource = pds;
dlProduct.DataBind();
lbCurrent.Text = (pds.CurrentPageIndex + 1).ToString();
lbTotal.Text = pds.PageCount.ToString();
}
}
protected void IndexChange(object sender, CommandEventArgs e)
{
string cmd = ((LinkButton)sender).CommandArgument.ToString();
int pageindex = int.Parse(ViewState["pageindex"].ToString());
if (cmd == "previous")
{
pageindex += -1;
}
else if (cmd == "next")
{
pageindex += 1;
}
ViewState["pageindex"] = pageindex;
BindData();
}
protected void dlProduct_ItemCommand(object sender, DataListCommandEventArgs e)
{
//Int64 pid = Convert.ToInt64(e);
//string sqlDeleteProduct = "delete from Tb_product where Pid=" + pid;
string cmd = e.CommandName;
Int64 pid = Convert.ToInt64(e.CommandArgument);
if (cmd == "delete")
{
this.ClientScript.RegisterStartupScript(GetType(),"","<script>alert('"+pid.ToString()+"')</script>");
}
}
}
}
分享到:
相关推荐
本资源实现Datalist的排序和分页,请大家多多赐教!
本人亲自打造 datalist分页详解 按钮控制
本文实例讲述了asp.net控件DataList分页用法。分享给大家供大家参考,具体如下: protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ViewState[Page] = 0; Bangding(); } } //绑定...
@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”Test(Datalist数字分页).aspx.cs” Inherits=”Test_Datalist数字分页_” %> <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” ...
@ Page Language=C# AutoEventWireup=true CodeFile=home.aspx.cs Inherits=home %> <body> <form id=form1 runat=server> <asp:DataList ID=monitorTypeList runat=server RepeatColumns=4 ...
DataView dataList = saBatteryHelper.GetSaBatteryList(condition, "PAGE", Int32.Parse(string.IsNullOrEmpty(Imagebutton2.ToolTip) ? "0" : Imagebutton2.ToolTip), this.dg_detail.PageSize, ref total_page, ...
dataList.push(page1); dataList.push(page2); dataList.push(page3); $(document).ready(function(){ var f=0; $("#dbRoWrap img").each(function(){//初始化第一页数据 $(this).attr("src",page1[f]); f=f+...
1.3.5 使用Page.IsPostBack属性 29 1.3.6 调试和跟踪ASP.NET页面 30 1.3.7 跟踪页面执行 33 1.4 安装ASP.NET Framework 35 1.5 小结 37 第2章 使用标准控件 38 2.1 显示信息 38 2.1.1 使用Label控件 38 2.1.2 使用...
buttons or Numerical pages or a Custom combination You click on the buttons the pager provides and your data control will automatically page through the data using SQL Paging ">可以针对GridView ...
而且结果可以根据title(书名),price(价格),page count(页数),author name(作者)等来排序。我们在分页和排序报表数据 里已经讨论过, GridView, DetailsView, 和FormView 都有内置的分页功能,仅仅只需要...
SQL分页控件源码 源码描述: 一个自制的分页控件 ... You click on the buttons the pager provides and your data control will automatically page through the data using SQL Paging. 欢迎感兴趣的朋友下载研究
四、Page 类的常用属性 五、Page 类的常用方法 六、Page 类的常用事件 教学目标: — 了解Web Form网页的构成; — 理解ASP.NET程序的处理过程; — 理解网页和控件的事件; — 掌握处理程序的编写方法...
DataPage dataPage = new DataPage(size, startRow, dataList); return dataPage; } }; } return defaultDataModel; } } 提示:关于PageListBaseBean更多的信息,可以参阅我在百度的blog(百度...
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.dlBind(); } } public void dlBind() { int curpage = Convert.ToInt32(labNowPage.Text); PagedDataSource ps = new ...
2、支持GridView、DataGrid、DataList等数据控件。 3、本分页已应用于数据量百万级的项目中。 4、使用简单,并包含多种样式布局 一、使用方法: 1、在.net2005 studio中,添加新控件,将下载到本地的jwork.dll加至...
private void Page_Load(object sender, System.EventArgs e) { this.AspNetPager1.PageSize=10; //设置每也显示的记录条数 if(!IsPostBack) //只在页面第一次加载时起作用 { SqlDBManager db = new ...
<asp:DataList ID="DataList1" runat="server" Height="30px" Width="413px"> NavigateUrl='<%# "~/articleshow.aspx?num=" + DataBinder.Eval(Container.DataItem,"num") %>' Text='<%# ...
<asp:DataList ID="DataList1" runat="server"> ("ID") %> </asp:DataList> <!--分页控件开始--> OnPageChanged="AspNetPager1_PageChanged" FirstPageText="首页 |" LastPageText="| 尾页" ...
10 datalist = get_data(baseurl, pagelist) #得到所有数据 11 dbpath = "zufang.db" 12 savedata_2_db(datalist, dbpath) #存⼊数据库 13 14 findpage = re.compile(r'data-totalpage="(\d*)" data-ur') #构建正则...
建立DataBind所有的DataBind都应该用DataBind() 函数来建立(注意如果你用的是C#,请注意大小写)数据绑定,是整个页面PAGE和所有控件的一个方法,也就是说,他可以被所有的控件使用,你建立数据绑定的时候,...