Gridview with paging

Question

1.00/5 (2 votes)

See more:

XML

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ProductGrid.aspx.cs" Inherits="ProductGrid" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

 <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <script type = "text/javascript">

     function MouseEvents(objRef, evt) {

         var checkbox = objRef.getElementsByTagName("input")[0];

         if (evt.type == "mouseover") {

             objRef.style.backgroundColor = "orange";

         }

         else {

             if (checkbox.checked) {

                 objRef.style.backgroundColor = "aqua";

             }

             else if (evt.type == "mouseout") {


                 if (objRef.rowIndex % 2 == 0) {

                     objRef.style.backgroundColor = "white";

                 }

                 else {

                     objRef.style.backgroundColor = "#E6E6E6";

                 }

             }

         }

     }

</script>
<%--<javascript added by Naresh></javascript>--%>

    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
    </asp:ToolkitScriptManager>
   <div class="contentHeader">
   <br />
   <br />
    <asp:Label ID="lbllistofprd" Text="List of Products" runat="server" ></asp:Label>
    <hr />
    </div>

   <table align="right"  >
   <%--Added default button--%>
   <tr>
   <td >
       <%--<a id="btn_addProductdetails_link"  href="/KB/answers/ProductItemsDetails.aspx"></a>--%>
       <asp:Button ID="btn_addProductDetails" runat="server" Text=" + Add Items " CssClass="button"
           Height="40px" Font-Bold="True"
           Enabled="False" Width="125px" OnClientClick="return displayFancybox('ProductItemsDetails.aspx');" /><%--</a>--%></td>
   <%--<td>
  <a id="various4" href="/KB/answers/ProductItemsDetails.aspx" >
       <asp:ImageButton ID="imgaddproductdetails" runat="server"
           ImageUrl="~/images/add.JPG"  ToolTip="Add Product Details" Width="25px"></asp:ImageButton ></a>
   </td>
   --%>
   <td>


        <asp:Button ID="btn_addNewProduct"
            runat="server" Text="+ Add New Product" CssClass="addButton"
            Font-Bold="True" Height="40px" OnClientClick="return displayFancybox('NewProduct.aspx');" /></td>
   <%--<td><a id="various" href="/KB/answers/NewProduct.aspx"><asp:ImageButton ID="Imgaddnewproduct" runat="server" ImageUrl="~/images/addproduct.jpg" ToolTip="Add New Product" Width="35px"></asp:ImageButton ></a>
    </td>--%>

    <td><asp:Button ID="btn_delProduct" runat="server" Text=" X Delete " CssClass="button"
            Font-Bold="True" Height="40px"
            Enabled="False" Width="100px" onclick="btn_delProduct_Click1"></asp:Button>
        <asp:ConfirmButtonExtender ID="btn_delProduct_ConfirmButtonExtender"
            runat="server" ConfirmText="are you sure to delete product" Enabled="True" TargetControlID="btn_delProduct">
        </asp:ConfirmButtonExtender>
       </td>
            <td><asp:Button ID="btnUpdate"
                    runat="server" Text="Edit" CssClass="button"
            Font-Bold="True" Height="40px" Width="100px"
                    Enabled="False" OnClientClick="return displayFancybox('NewProduct.aspx?U=');" ></asp:Button></td>
                      <%--<td><asp:ImageButton ID="imgdelete" runat="server" ImageUrl="~/images/delete.bmp" ToolTip="DELETE" Width="25px" /></td>--%>
    </tr>

   </table>

   <table style="height:100px;  width: 100%; padding:10px;">
       <tr ><td align="center">
     <asp:GridView ID="GVProduct" runat="server" AutoGenerateColumns="False" CssClass="datatable "
               GridLines ="None"  style="margin-right: 50px" CellPadding="4" CellSpacing="1"
               Font-Size="Small" BackColor="#E6E6E6" ForeColor="#0B3861"
               AllowPaging="True" PageSize ="15"
               Width="100%"
                 onrowcreated="GVProduct_RowCreated"
               onrowdatabound="GVProduct_RowDataBound" ondatabound="GVProduct_DataBound"
               onpageindexchanging="GVProduct_PageIndexChanging1"
               onselectedindexchanged="GVProduct_SelectedIndexChanged" >
            <%--   onselectedindexchanged="GVProduct_SelectedIndexChanged" >--%>

               <AlternatingRowStyle BackColor ="White" />
                 <%--<add By Naresh   onpageindexchanging="GVProduct_PageIndexChanging"></add>--%>
      <Columns>
       <asp:TemplateField ControlStyle-Width="15px" ItemStyle-HorizontalAlign="Center">
          <HeaderTemplate>Select</HeaderTemplate>
        <ItemTemplate>
        <asp:CheckBox ID="chkselect" runat="server"  AutoPostBack="true"
                OnCheckedChanged="chkselect_CheckedChanged" />
            <asp:MutuallyExclusiveCheckBoxExtender ID="chkselect_MutuallyExclusiveCheckBoxExtender"
                runat="server" Enabled="True"  Key="gridchk" TargetControlID="chkselect">

            </asp:MutuallyExclusiveCheckBoxExtender>
        </ItemTemplate>

<ControlStyle Width="15px"></ControlStyle>
        </asp:TemplateField>
            <asp:TemplateField HeaderText="Product Name" ItemStyle-HorizontalAlign="Left">
                <ItemTemplate>
                   <asp:Label ID="productname" Text='<%# Eval("product_name") %>' runat="server" CssClass="paddingItemDes"></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
         <asp:BoundField DataField="product_description"
                HeaderText="Product Description" SortExpression="roduct_description"
              ItemStyle-HorizontalAlign="Left" ItemStyle-CssClass="paddingItemDes" >

<ItemStyle HorizontalAlign="Left" CssClass="paddingItemDes"></ItemStyle>
          </asp:BoundField>

            <%--Added by Raju to enhance the richness of UI--%>
            <asp:TemplateField HeaderText="In Stock" ItemStyle-HorizontalAlign="Center">
                <ItemTemplate>
                    <asp:Label ID="instock" runat="server"
                        Text='<%# Eval("Stock") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Committed" ItemStyle-HorizontalAlign="Center">
                <ItemTemplate>
                    <asp:Label ID="committed" runat="server"
                        Text='<%# Eval("Commited") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="On Order" ItemStyle-HorizontalAlign="Center">
                <ItemTemplate>
                    <asp:Label ID="onorder" runat="server"
                        Text='<%# Eval("Inorder") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Wholesale" ItemStyle-HorizontalAlign="Center">
                <ItemTemplate>
                    <asp:Label ID="wholesale" runat="server"
                        Text='<%# Eval("wholesalePrice") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>


           </Columns>
         <%--<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#0078AE" ForeColor="White" HorizontalAlign="Right" CssClass ="margin5x " />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#0078AE" />
            <AlternatingRowStyle BackColor="White" />--%>
<%--
            <old one></old>--%>



            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#0078AE"  HorizontalAlign="Right" CssClass ="margin5x " />
            <PagerStyle BackColor="#0078AE"  HorizontalAlign="Right" CssClass="paddingItemDes"  Width ="100%" Height ="25px"  />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333"/>
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"/>
            <EditRowStyle BackColor="#0078AE" />
            <AlternatingRowStyle BackColor="White"/>
      <PagerTemplate>
        <asp:LinkButton ID="LinkButton1" runat="server" CommandName="Page" CommandArgument="First" CssClass="Linkbutton">First</asp:LinkButton>
        <asp:Label ID="pmore" runat="server" Text=""></asp:Label>
        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="Page" CommandArgument="Prev" CssClass="Linkbutton">Pre</asp:LinkButton>
        <asp:LinkButton ID="p0" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>
        <asp:LinkButton ID="p1" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>
        <asp:LinkButton ID="p2" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>
        <asp:Label ID="CurrentPage" runat="server" Text="Label"  ForeColor ="#EEE000" Font-Size ="Medium" ></asp:Label>
        <asp:LinkButton ID="p4" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>
        <asp:LinkButton ID="p5" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>
        <asp:LinkButton ID="p6" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>
        <asp:LinkButton ID="LinkButton3" runat="server" CommandName="Page" CommandArgument="Next" CssClass="Linkbutton">Next</asp:LinkButton>
        <asp:Label ID="nmore" runat="server" Text=""></asp:Label>
        <asp:LinkButton ID="LinkButton4" runat="server" CommandName="Page" CommandArgument="Last" CssClass="Linkbutton">Last</asp:LinkButton>
</PagerTemplate>

<%--<added by naresh></added>--%>

    </asp:GridView>
    </td> </tr>
    <asp:Label ID="lblresult" runat="server" Text=""></asp:Label>
    <asp:Literal runat="server" ID="Literal1" />
    </table>
   </asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Xml;


public partial class ProductGrid : System.Web.UI.Page
{
    static string PN;
    //ds is used Store Data And Bind to Grid
    static DataSet ds;
    // con is used for sqlConnection it get the Connection from connectionString class
    SqlConnection con = new SqlConnection(IMS.ConnectionString.getValue());

      protected void Page_Load(object sender, EventArgs e)
    {
        sessions.getsessions();
        btn_delProduct.Enabled=btn_addProductDetails.Enabled=btnUpdate.Enabled = false;
        //HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
        if (Page.IsPostBack == false)
        {
            getdata();
        }
    }
    
   public string getVal()
    {
        return PN;
    }
    public void getdata()
    {
        //da is fetch datafrom DataBase
        SqlDataAdapter da = new SqlDataAdapter("select * from product", con);
        ds = new DataSet();
        //it fill the dataset(ds)'s table with Product
        da.Fill(ds, "Product");
        //GVProduct.Dispose();
        GVProduct.DataSource = ds.Tables["Product"];
        GVProduct.DataBind();
    }

    public string getPName()
    {
        return IMSNiana.ProductName;
    }
    
    protected void GVProduct_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='#EEFF00'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle;");
        }
        if (e.Row.RowType == DataControlRowType.Pager)
        {
            GridViewRow gvr = e.Row;
            LinkButton lb = (LinkButton)gvr.Cells[0].FindControl("p0");
            lb.Command += new CommandEventHandler(lb_Command);
            lb = (LinkButton)gvr.Cells[0].FindControl("p1");
            lb.Command += new CommandEventHandler(lb_Command);
            lb = (LinkButton)gvr.Cells[0].FindControl("p2");
            lb.Command += new CommandEventHandler(lb_Command);
            lb = (LinkButton)gvr.Cells[0].FindControl("p4");
            lb.Command += new CommandEventHandler(lb_Command);
            lb = (LinkButton)gvr.Cells[0].FindControl("p5");
            lb.Command += new CommandEventHandler(lb_Command);
            lb = (LinkButton)gvr.Cells[0].FindControl("p6");
            lb.Command += new CommandEventHandler(lb_Command);
        }
    }
    protected void GVProduct_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "MouseEvents(this, event)");
            e.Row.Attributes.Add("onmouseout", "MouseEvents(this, event)");
                //    //<AddedControl By Naresh>
            
        }
    }
    protected void chkselect_CheckedChanged(object sender, EventArgs e)
    {
        foreach (GridViewRow gvr in GVProduct.Rows)
        {
            CheckBox chk = (CheckBox)gvr.FindControl("chkselect");
            if (chk.Checked == true)
            {
                btn_addProductDetails.Enabled = btn_delProduct.Enabled = btnUpdate.Enabled = true;
                Label pn = (Label)gvr.FindControl("productname");
                IMSNiana.ProductName = pn.Text;
               
                break;
            }
            else
            {
                btn_addProductDetails.Enabled = btn_delProduct.Enabled = btnUpdate.Enabled = false;
               
            }
        }
    }
 
    
    protected void GVProduct_DataBound(object sender, EventArgs e)
    {
        try  //by shruthi
        {
            GridViewRow gvrow = GVProduct.BottomPagerRow;
            Label lblcurrentpage = (Label)gvrow.Cells[0].FindControl("CurrentPage");
            lblcurrentpage.Text = Convert.ToString(GVProduct.PageIndex + 1);
            int[] page = new int[7];
            page[0] = GVProduct.PageIndex - 2;
            page[1] = GVProduct.PageIndex - 1;
            page[2] = GVProduct.PageIndex;
            page[3] = GVProduct.PageIndex + 1;
            page[4] = GVProduct.PageIndex + 2;
            page[5] = GVProduct.PageIndex + 3;
            page[6] = GVProduct.PageIndex + 4;
            for (int i = 0; i < 7; i++)
            {
                if (i != 3)
                {
                    if (page[i] < 1 || page[i] > GVProduct.PageCount)
                    {
                        LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("p" + Convert.ToString(i));
                        lnkbtn.Visible = false;
                    }
                    else
                    {
                        LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("p" + Convert.ToString(i));
                        lnkbtn.Text = Convert.ToString(page[i]);
                        lnkbtn.CommandName = "PageNo";
                        lnkbtn.CommandArgument = lnkbtn.Text;

                    }
                }
            }
            if (GVProduct.PageIndex == 0)
            {
                LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton1");
                lnkbtn.Visible = false;
                lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton2");
                lnkbtn.Visible = false;
            }
            if (GVProduct.PageIndex == GVProduct.PageCount - 1)
            {
                LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton3");
                lnkbtn.Visible = false;
                lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton4");
                lnkbtn.Visible = false;
            }
            if (GVProduct.PageIndex > GVProduct.PageCount - 5)
            {
                Label lbmore = (Label)gvrow.Cells[0].FindControl("nmore");
                lbmore.Visible = false;
            }
            if (GVProduct.PageIndex < 4)
            {
                Label lbmore = (Label)gvrow.Cells[0].FindControl("pmore");
                lbmore.Visible = false;
            }
        }
        catch
        {
        }
}
  public  void lb_Command(object sender, CommandEventArgs e)
   {
       GVProduct.PageIndex = Convert.ToInt32(e.CommandArgument) - 1;
       getdata();
    }

  protected void GVProduct_PageIndexChanging1(object sender, GridViewPageEventArgs e)
  {
      GVProduct.PageIndex = e.NewPageIndex;
      getdata();
  }
  protected void GVProduct_SelectedIndexChanged(object sender, EventArgs e)
  {
  }
  protected void btn_delProduct_Click1(object sender, EventArgs e)
  {
      SqlDataAdapter da = new SqlDataAdapter("select product_id from Product where product_name='" + IMSNiana.ProductName + "'", con);
      //ds is used store data fetched from Database
      DataSet ds = new DataSet();
      da.Fill(ds, "PN");
      string PId = ds.Tables["PN"].Rows[0][0].ToString();
      da = new SqlDataAdapter(" delete from ProductDetails where product_id='" + PId + "' delete from  Product where product_id='" + PId + "'", con);
      ds = new DataSet();
      da.Fill(ds, "Product");
      getdata();
      XmlDocument doc = new XmlDocument();
      string p = Server.MapPath("Charts\\line_settings.xml");
      doc.Load(p);
      XmlElement f = doc.DocumentElement;
      XmlElement graphs = (XmlElement)f.ChildNodes[64];
      XmlElement cd = (XmlElement)graphs.LastChild;
      cd.ParentNode.RemoveChild(cd);
      doc.Save(p);
  }
}

Posted 20-Jul-11 0:27am

SruthiGeejula

Updated 20-Jul-11 0:28am

Toniyo Jackson

v2

Add a Solution

Comments

Toniyo Jackson 20-Jul-11 6:29am

What is your problem?

[no name] 20-Jul-11 6:35am

is it a question or post???

SruthiGeejula 20-Jul-11 6:38am

i have errors in this..its not executing plz find it..

Herman<T>.Instance 20-Jul-11 7:02am

have you debugged your code?

R. Giskard Reventlov 20-Jul-11 7:06am

Oh yes, like we have nothing better to do than to debug your code.

SruthiGeejula 20-Jul-11 7:14am

Ok thanx for the reply..i Got d solution

Ashika s 20-Jul-11 7:21am

How you soleved?
wat was the error?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2011-07-21T13:52:00

Solution 1

Please when you ask for help, tell us the problem, tell us the error message and the line it happens. If you find the solution, post it here or delete your question. What you've done here is very rude.

Posted 21-Jul-11 13:52pm

Christian Graus

Gridview with paging

1 solution

Solution 1

Add your solution here

Preview 0

Gridview with paging

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us