protected void Page_Load(object sender, EventArgs e)
{
dtNewsCategory = taNewsCategory.SelectNewsCategoryNameByNewsCategoryId(5);
if (dtNewsCategory.Rows.Count > 0)
{
int page = 10;
dtNews = taNews.SelectNewsbyNewsCategoryId(5);
if (dtNews.Rows.Count > 0)
{
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = dtNews.DefaultView;
objPds.AllowPaging = true;
objPds.PageSize = page;
objPds.CurrentPageIndex = CurrentPage;
Repeater1.DataSource = objPds;
Repeater1.DataBind();
}
else
{
Repeater1.Visible = false;
}
}
else
{
Repeater1.Visible = false;
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton btnDel = (LinkButton)e.Row.FindControl("delbutton");
btnDel.Attributes.Add("OnClick", "return confirm('Are you sure to delete this record?');");
Label lblNewsCategoryId = (Label)e.Row.FindControl("lblNewsCategoryId");
dtNewsCategory = taNewsCategory.SelectNewsCategoryNameByNewsCategoryId(Convert.ToInt32(lblNewsCategoryId.Text));
if (dtNewsCategory.Rows.Count > 0)
lblNewsCategoryId.Text = dtNewsCategory[0].NewsCategoryTitle.ToString();
}
}
private void ItemsGet()
{
if (Request.QueryString["NewsCategoryId"] != null)
{
int NewsCategoryId = Convert.ToInt32(Request.QueryString["NewsCategoryId"]);
dtNewsCategory = taNewsCategory.SelectNewsCategoryNameByNewsCategoryId(NewsCategoryId);
if (dtNewsCategory.Rows.Count > 0)
{
int page = 10;
lblCategoryName.Text = dtNewsCategory[0].NewsCategoryTitle.ToString();
dtNews = taNews.SelectNewsbyNewsCategoryId(NewsCategoryId);
if (dtNews.Rows.Count > 0)
{
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = dtNews.DefaultView;
objPds.AllowPaging = true;
objPds.PageSize = page;
objPds.CurrentPageIndex = CurrentPage;
//objPds.CurrentPageIndex = CurrentPage - 1;
int count = objPds.PageCount;
lblCurrentPage.Text = "Page " + (CurrentPage + 1).ToString() + " of "
+ objPds.PageCount.ToString();
//Disable Prev or Next buttons if necessary
//Button1.Visible = !objPds.IsFirstPage;
//Button2.Visible = !objPds.IsLastPage;
if (objPds.IsFirstPage)
Button1.Visible = false;
else
Button1.Visible = true;
if (objPds.IsLastPage)
Button2.Visible = false;
else
Button2.Visible = true;
Repeater1.DataSource = objPds;
Repeater1.DataBind();
}
else
{
Repeater1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
}
}
else
{
Repeater1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
}
}
else
{
Repeater1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
}
}