datalist paging

Datalist asp.net c# example

In SQL-Server

create table emp(empid int,empname varchar(50),empdesc varchar(500))


datalist.aspx.cs

<asp:DataList Width="43%" ID="DataList1" runat="server" onitemdatabound="DataList1_ItemDataBound">;
<ItemTemplate>
<table width="50%">
<tr bgcolor="silver">
<td width="50%">
<asp:Label ID="lbl_1" runat="server" Text="first"></asp:Label>
</td>
<td width="50%">
<asp:Label ID="lbl_2" runat="server" Text="second"></asp:Label>
</td>

</tr>
<tr bgcolor="lime">
<td width="100%" colspan="2">
<asp:TextBox ID="txt_1" TextMode="multiLine" runat="server"></asp:TextBox>
</td>

</tr>

</table>

</ItemTemplate>
</asp:DataList>
datalist.cs

SqlDataAdapter da;
DataTable dt= new DataTable();
int counter = 0;

in pageload event call this bind() method:

bind()
{
SqlConnection con = new SqlConnection("server=.;database=demo;integrated security=true;");
con.Open();
da = new SqlDataAdapter("select * from emp", con);
da.Fill(dt);
con.Close();
DataList1.DataSource = dt;
DataList1.DataBind();
}

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
Label lbl1 = (Label)e.Item.FindControl("lbl_1");
lbl1.Text = dt.Rows[counter][0].ToString();
Label lbl2 = (Label)e.Item.FindControl("lbl_2");
lbl2.Text = dt.Rows[counter][1].ToString();
TextBox txt = (TextBox)e.Item.FindControl("txt_1");
txt.Text = dt.Rows[counter][2].ToString();
counter++;
}
=============================
URL
=============================
http://aspalliance.com/157_Paging_in_DataList
http://www.c-sharpcorner.com/UploadFile/rizwan328/DataListCustomPaging01112009021450AM/DataListCustomPaging.aspx


http://www.aspdotnetcodes.com/DataList_Dynamic_Paging_PagedDataSource.aspx

======================================


PAGING IN DATALIST
==========================================
PLACE A DATALIST CONTROL AND INSIDE DATALIST PLACE TWO LABELS AS ITEM TEMPLATE
PLACE TWO LINK BUTTONS

DEFAULT.ASPX
==================

<asp:DataList ID="dlCountry" runat="server">

<ItemTemplate>
<table>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("customerid") %>'></asp:Label>

</td>
<td>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("CompanyName") %>'></asp:Label>

</td>
</tr>
</table>

</ItemTemplate>


</asp:DataList>
<asp:LinkButton ID="linkprev" runat="server" onclick="linkprev_Click">prev</asp:LinkButton>
<asp:LinkButton ID="lnknext" runat="server" onclick="lnknext_Click">next</asp:LinkButton>
</td>
</tr>
</table>
================================================

DEFAULT.ASPX.CS
===================================================
PagedDataSource pds = new PagedDataSource(); //GLOBAL DECLARATION
=====================
IN PAGE_LOAD
====================
if (!IsPostBack)
{
BindGrid();
}
=====================

public int CurrentPage
{

get
{
if (this.ViewState["CurrentPage"] == null)
return 0;
else
return Convert.ToInt16(this.ViewState["CurrentPage"].ToString());
}

set
{
this.ViewState["CurrentPage"] = value;
}

}
========
private void BindGrid()
{
string sql = "Select * from customers";
SqlDataAdapter da = new SqlDataAdapter(sql, "server=.;database=northwind;integrated security=true");
DataTable dt = new DataTable();
da.Fill(dt);
Cache["dt"] = dt;
pds.DataSource = dt.DefaultView;
pds.AllowPaging = true;
//pds.PageSize = Convert.ToInt16(ddlPageSize.SelectedValue);
pds.CurrentPageIndex = CurrentPage;
lnknext.Enabled = !pds.IsLastPage;
linkprev.Enabled = !pds.IsFirstPage;
//doPaging();
dlCountry.DataSource = pds;
dlCountry.DataBind();


}
private void BindGrid1()
{

DataTable dt1 = new DataTable();

dt1 = (DataTable)Cache["dt"];
pds.DataSource = dt1.DefaultView;
pds.AllowPaging = true;
//pds.PageSize = Convert.ToInt16(ddlPageSize.SelectedValue);
pds.CurrentPageIndex = CurrentPage;
lnknext.Enabled = !pds.IsLastPage;
linkprev.Enabled = !pds.IsFirstPage;
//doPaging();
dlCountry.DataSource = pds;
dlCountry.DataBind();


}
==================
protected void linkprev_Click(object sender, EventArgs e)
{
CurrentPage -= 1;

BindGrid1();
}
protected void lnknext_Click(object sender, EventArgs e)
{
CurrentPage += 1;
BindGrid1();
}
========================

URL

http://www.aspdotnetcodes.com/DataList_Dynamic_Paging_PagedDataSource.aspx

http://authors.aspalliance.com/aspxtreme/sys/web/ui/webcontrols/datalistclassitemdatabound.aspx(good one)
http://www.eggheadcafe.com/tutorials/aspnet/d89d1d96-03f1-4784-bbb2-a3db1af393f5/aspnet-datalist-and-data.aspx(good one)
=========================================================================