Hi.. here am bind database images in grid view.. I set pagesize as 5.. If the images in grid exceeds 5 means the paging property not working properly.. Can anyone help me??
<asp:GridView ID="gvImages" runat="server" AllowPaging="True"
AutoGenerateColumns="False" CssClass="Gridview" HeaderStyle-BackColor="#446182"
HeaderStyle-ForeColor="white" OnPageIndexChanging="gvImages_PageIndexChanging"
OnRowCommand="gvImages_RowCommand" OnSelectedIndexChanged="gvImages_SelectedIndexChanged"
PageSize="4" Width="100">
<columns> <asp:TemplateField HeaderText="Image">
<itemtemplate>
<asp:Image ID="Image1" runat="server" BorderColor="#446182" BorderWidth="2" Height="150px"
ImageUrl='<%# "~/Image.aspx?id="+Eval("id") %>' Width="150px" />
<asp:HiddenField ID="hf1" runat="server" Value='<%# Eval("id") %>' />
<asp:TemplateField HeaderText="Remove">
<itemtemplate>
<asp:Button ID="BtnRemove" runat="server" BackColor="#446182" BorderColor="#446182"
CommandName="Remove" CssClass="txt" Text="Remove" />
<pagersettings firstpagetext="First" lastpagetext="Last" mode="NumericFirstLast">
PageButtonCount="4" />
<pagerstyle backcolor="#446182" font-bold="true" forecolor="White">
<HeaderStyle BackColor="#446182" ForeColor="White" />
.cs
protected void gvImages_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
lbldel.Text = "";
if (e.CommandName == "Remove")
{
GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer ;
// (or) //
// GridViewRow row = (GridViewRow)((Control)e.CommandSource).Parent.Parent;
index = row.RowIndex;
HiddenField id1 = (HiddenField)gvImages.Rows[index].FindControl("hf1");
if (dbo.deleterecords("image", "id='" + id1.Value + "'") == true)
{
bindgrid();
lbldel.Text = "Image Deleted";
}
}
}
catch (Exception ex)
{
Exception E = ex;
}
}
protected void gvImages_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
gvImages.PageIndex = e.NewPageIndex;
bindgrid();
}
catch (Exception ex)
{
}
}
public void bindgrid()
{
try
{
DataTable dt = dbo.GetRecordsWithQuery("Select '' as Sno,id,image,'Remove' as [Remove] from image");
gvImages.DataSource = dt;
gvImages.DataBind();
}
catch (Exception ex)
{
Exception E = ex;
}
}