Click here to Skip to main content
15,922,574 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
In Asp.net

VB
<asp:GridView ID="grvMatGrp" runat="server" AutoGenerateColumns="false" Width="50%" AllowPaging="true" PageIndex="10" OnPageIndexChanging="grvMatGrp_PageIndexChanging"
                                                                                        OnRowDeleting="grvMatGrp_RowDeleting">


In C#
C#
protected void grvMatGrp_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        Matflag = 1; 
        grvMatGrp.PageIndex = e.NewPageIndex;
        GetMaterialList();
    }
    public void GetMaterialList()
    {
        try
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("Code");            
            dt.Columns.Add("CodeDesc");
            dt.Columns.Add("ShortCodeDesc");
            dt.Columns.Add("Type");

            DataTable dtTemp = new DataTable();
            dtTemp.Columns.Add("CodeTemp");
            dtTemp.Columns.Add("CodeDescTemp");
            dtTemp.Columns.Add("TypeTemp");
            DataTable DT = new DataTable();

            DataSet DS = new DataSet();
            DS = Session["lstSelected"] as DataSet;
            DT = DS.Tables[0];

            if (Matflag != 1)
                DT = DS.Tables[0];

            else
                DT = (DataTable)ViewState["CurrentTableData"];


            if (DT.Rows.Count > 0)
            {
                DT.Columns.Add("ShortCodeDesc");


                foreach (DataRow dr in DT.Rows)
                {
                    string str = string.Empty;
                    str = dr["CodeDesc"].ToString();
                    if (str.Length > 100)
                    {
                        str = str.Substring(0, 100) + " ...";
                    }
                    dr["ShortCodeDesc"] = str;
                }
            }

            if (grvMatGrp.Rows.Count == 0)
            {
                grvMatGrp.DataSource = DT;
                grvMatGrp.DataBind();
                Session["CurrentTableData"] = DT;
            }
            else
            {
                foreach (GridViewRow row in grvMatGrp.Rows)
                {
                    var Grv_Code = row.Cells[0].FindControl("grvlblMatGrpCode") as Label;
                    var Grv_CodeDesc = row.Cells[1].FindControl("grvlblMatGrp") as Label;
                    dt.Rows.Add(Grv_Code.Text, Grv_CodeDesc.Text);
                }
                for (int i = 0; i < DT.Rows.Count; i++)
                {
                    string NewRecord = DT.Rows[i]["Code"].ToString();
                    char Present_Flag = 'N';
                    int count = 0;

                    foreach (DataRow dtRow in dt.Rows)
                    {
                        if (NewRecord != dtRow["Code"].ToString())
                        {
                            Present_Flag = 'Y';
                        }
                        else
                        {
                            count = count + 1;
                            Present_Flag = 'N';
                        }
                    }

                    if (Present_Flag == 'Y' && count == 0)
                    {
                        DataRow NewRow = dtTemp.NewRow();
                        NewRow["CodeTemp"] = DT.Rows[i]["Code"].ToString();
                        NewRow["CodeDescTemp"] = DT.Rows[i]["CodeDesc"].ToString();
                        dtTemp.Rows.Add(NewRow);
                    }
                }
                if (dtTemp.Rows.Count != 0)
                {
                    for (int N = 0; N < dtTemp.Rows.Count; N++)
                    {
                        DataRow NewRow = dt.NewRow();
                        NewRow["Code"] = dtTemp.Rows[N]["CodeTemp"].ToString();
                        NewRow["CodeDesc"] = dtTemp.Rows[N]["CodeDescTemp"].ToString();
                        dt.Rows.Add(NewRow);
                    }
                }
                if (dt.Rows.Count > 0)
                {
                    if (dt.Columns.Contains("ShortCodeDesc") == false)
                    {
                        dt.Columns.Add("ShortCodeDesc"); 
                    }
                    
                    foreach (DataRow dr in dt.Rows)
                    {
                        string str = string.Empty;
                        str = dr["CodeDesc"].ToString();
                        if (str.Length > 100)
                        {
                            str = str.Substring(0, 100) + " ...";
                        }
                        dr["ShortCodeDesc"] = str;
                    }
                }

                if (dt.Rows.Count != 0)
                {
                    Session["CurrentTableData"] = dt;
                    
                    grvMatGrp.DataSource = dt;
                    grvMatGrp.DataBind();
                }
            }
            pnlMatCart.Visible = false;
            pnlMatGrp.Visible = true;
            ControlEnable();
            updPnl.Update();
        }
        catch (Exception ex)
        {

        }

    }



C#
void MaterialCart1_PostItems(EIPCommonControls_EIPCart.CartTypes CartType, DataSet ds)
   {

       if (CartType == EIPCommonControls_EIPCart.CartTypes.Material)
       {
           GetMaterialList();
       }
       if (CartType == EIPCommonControls_EIPCart.CartTypes.Job)
       {
           GetJobList();
       }
   }


And here in page load

C#
protected void Page_Load(object sender, EventArgs e)
   {
       try
       {

           Session["iuid"] = 523;
           Session["iCompanyCode"] = 1;
           Session["iDTCode"] = 2086;
           Session["iCompanyCode"] = Convert.ToInt32(Session["iCompanyCode"]);

           MaterialCart1.PostItems += new EIPCommonControls_EIPCart.lstPostItemDelegate(MaterialCart1_PostItems);

           //      ddlToDate.. = "9";

           //

           pnlAdd.Width = new Unit((Convert.ToInt32(EIPCluster.DDLWidth.Value.ToString()) + 230), UnitType.Pixel);
           if (!IsPostBack)
           {

               // Date = DateTime.Now.Year;
               pnlAdd_ModalPopupExtender.Hide();
            //   lblCurrentDate.Text = DateTime.Now.ToString("dd-MMM-yyyy");
               //((EIPMasterTemplate)(Master)).UID = Convert.ToInt32(Session["iUid"]);
               //((EIPMasterTemplate)(Master)).DTCode = Convert.ToInt32(Session["iDTCode"]);
               //((EIPMasterTemplate)(Master)).LoginDelgated = "N";
               //((EIPMasterTemplate)(Master)).DelgatedUid = 0;
               //((EIPMasterTemplate)(Master)).DOPTCode = "V";
               //((EIPMasterTemplate)(Master)).PageHeading = "SCM – Stock Movement Report (View)";

               EIPFilterWarehouse.Parameters = "intUID:" + Session["iUid"] + ",intDTCode:" + Session["iDTCode"] + ",chrDOPTCode:" + 'V' + ",chrAccessTag:" + 'Y';
               EIPClassList.Parameters = "intCompanyCode:" + Session["iCompanyCode"] + ",intUID:" + Session["iUid"];
               EIPCluster.UserId = Convert.ToInt32(Session["iUid"]);
               EIPCluster.CompanyCode = Session["iCompanyCode"].ToString();
               MaterialCart1.Visible = false;
               Date = DateTime.Now.Year;
               month = DateTime.Now.Month;


               ddlToDate.EndYear = Date + 1;
               ddlToDate.SelectedYear = Date.ToString();
               (ddlToDate.FindControl("ddlToDateMonths") as DropDownList).SelectedValue = (month-1).ToString();

               ddlFromDate.EndYear = Date + 1;
               ddlFromDate.SelectedYear = Date.ToString();
               (ddlFromDate.FindControl("ddlFromDateMonths") as DropDownList).SelectedValue = (month - 4).ToString();


               updpnlMatCart.Visible = false;
               Session["CurrentTableData"] = null;
               Session["CurrentTableDatajob"] = null;

           }
       }
       catch (Exception ex)
       {
           MsgBox.ShowError("EIP Error", ex.Message);
       }
   }
Posted
Updated 15-Apr-15 0:43am
v3
Comments
Not sure of the business logic. Might be due to the fact that you are binding different tables on page index changing. You should bind the exactly same table, which you have bound initially. But you have many conditions inside the bind method.

Hi,

A couple of points:
PageSize - where do you define this? I can't see it in your posted code.
PageIndex - you have defined this as an attribute in the GridView markup:
ASP.NET
<asp:GridView id="grvMatGrp" ... PageIndex="10" ... ></asp:GridView>

I would remove this from the mark up, and leave it to the code you have in PageIndexChanging() to take care of it for you.

I would also recommend that have a read at this article:
How To Implement Paging in GridView Control in ASP.NET[^]
... as this provides a better explanation of the available paging functionality than I can in this solution.

... hope it helps.
 
Share this answer
 
v3
Hi,

you grid is binding same on every pageindex. so try to get new data to bind the grid based on pageindex


Thanks
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900