|
<asp:LinkButtonID="lbtnPrevious"runat="server"Text= "Previous"OnClick="lbtnPrevious_onClick"></asp:LinkButton>
<asp:LinkButtonID="lbtnNext" runat="server" Text="Next"OnClick="lbtnNext_onClick"></asp:LinkButton>
Now in the code behind
declare the
" ViewState["currentPage"] = 0;
" in page load event.
Then do as I did in the BindDataList()
method.
|
|
ViewState["currentPage"] = 0;
protected void BindDataList()
{
DataTable dt = newDataTable();
dt
= null // assign the datatable with what you want to assign.
PagedDataSource page = newPagedDataSource();
page.AllowPaging
= true;
page.DataSource = dt.DefaultView;
page.PageSize
= 6;
page.CurrentPageIndex =Convert.ToInt32(ViewState["currentPage"]);
dlLogoImages.DataSource
= page;
dlLogoImages.DataBind();
lbtnNext.Enabled
= !page.IsLastPage; // Disable the next button if the page is the last page.
lbtnPrevious.Enabled = !page.IsFirstPage; // Disable the Previuos button if the page is the first page.
}
protectedvoid lbtnPrevious_onClick(object sender, EventArgs e)
{
int currentPage = Convert.ToInt32(ViewState["currentPage"]);
currentPage -= 1;
ViewState["currentPage"] = currentPage;
BindDataList();
}
protectedvoid lbtnNext_onClick(object sender, EventArgs e)
{
int currentPage = Convert.ToInt32(ViewState["currentPage"]);
currentPage += 1;
ViewState["currentPage"] = currentPage;
BindDataList();
}
Now paging is done in DataList.
protectedvoid lbtnPrevious_onClick(object sender, EventArgs e)
{
int currentPage = Convert.ToInt32(ViewState["currentPage"]);
currentPage -= 1;
ViewState["currentPage"] = currentPage;
BindDataList();
}
protectedvoid lbtnNext_onClick(object sender, EventArgs e)
{
int currentPage = Convert.ToInt32(ViewState["currentPage"]);
currentPage += 1;
ViewState["currentPage"] = currentPage;
BindDataList();
}
|
|
private void MainProcess()
{
string[] nameList = GetNames();
foreach(string name in nameList)
{
//do the processing here.
}
}
private string[] GetNames()
{
List<string> names = new
List<string>();
for (int i = 0; i < 10; i++)
{ names.Add("Name:" + i);
}
return names.ToArray();
}
|
|
The following code shows the way Yield implements the same
thing.
private void MainProcess()
{
foreach(string name in GetNames())
{
//do the processing here.
}
}
private IEnumerable GetNames()
{
for (int i = 0; i < 10; i++)
{ yield return "Name:" + i;
}
}
|
CREATE PROCEDURE SPR_YourProcedureName
AS
--Write Your query here
GO
EXEC SPR_YourProcedureName;
GO
DROP PROCEDURE SPR_YourProcedureName;
GO
a) System hold on Proceduresb) User outlined hold on proceduresc) Extended hold on Procedures
