We help IT Professionals succeed at work.

gridview paging not displaying second page.

Mehram
Mehram asked
on
Hi,
I am using below mentioned code to display data into gridview. it is showing data of first page excellent. When I clicked on 2 page or any other page the gridview disappear to the web page and webpage blank.
Please help me where I am doing wrong/

 <asp:GridView ID="Invoicing" runat="server" AutoGenerateColumns="False"
        HeaderStyle-Font-Size="Medium" HeaderStyle-Font-Italic="true" CellPadding="1"
        ForeColor="#333333" GridLines="None" Width="908px"
        AllowPaging="True" PageSize="12" AllowSorting="True" EnableSortingAndPagingCallbacks="True"
        OnPageIndexChanging="Invoicing_PageIndexChanging" >       
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />


 public partial class InvPage : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            loadGrid();
        }
        SqlConnection con;
        SqlCommand cmd;
        DataSet ds;
        SqlDataAdapter da;
                   
        private void loadGrid()
        {
             string values = "Select sno=Row_number() Over (Order by InvNo,Date), Date, InvNo, Amt=Sum(Amt), CoCom=Sum(Isnull(CoCom,0)), MkCom=Sum(Isnull(MkCom,0)), NPV=Sum(NetPurchasedValue), FreeStock from tempp Where FreeStock='0' Group by Date, InvNo, FreeStock Order by InvNo,Date";
               
            using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["DLICCBPL"].ConnectionString))
            {
                cmd = new SqlCommand(values,con);
                con.Open();                
                ds = new DataSet();
                da = new SqlDataAdapter(cmd);
                da.Fill(ds,"bb");
                Invoicing.DataSource = ds;
                Invoicing.DataMember = "bb";                
                Invoicing.DataBind();

               
                con.Close();
               
            }
        }

        protected void Invoicing_PageIndexChanging(Object sender, GridViewPageEventArgs e)
        {
            Invoicing.PageIndex = e.NewPageIndex;
            Invoicing.DataBind();
            //((GridView)sender).PageIndex = e.NewPageIndex;

           
        }
       

    }
Comment
Watch Question

View Solution Only

Mehram

Author

Commented:
<PagerSettings FirstPageText="First" LastPageText="Last"
            Mode="NumericFirstLast" />
Developer User Interface
CERTIFIED EXPERT
Commented:
By any chance you have disabled the Viewstate of the page?

How many records does the query return?

Please try this code.

protected void Invoicing_PageIndexChanging(Object sender, GridViewPageEventArgs e)
        {
            Invoicing.PageIndex = e.NewPageIndex;
            loadGrid();
            
        }

Open in new window

Mehram

Author

Commented:
Sir, I am asking another question related to gridview to show data on label click to load data accordingly into the gridview. please keep online to assist me.