.net – loop all gridview rows on button click when paging enabled

gridviewnet

I have paging enabled in my gridview…

I need this in button click event

gridview total row count
loop through all the rows in foreach

but it's only working for the current gridview page…help

protected void Button5_Click(object sender, EventArgs e)
{
    int[] no = new int[GridView2.Rows.Count];
    int i = 0;

    foreach (GridViewRow row in GridView2.Rows)
    {            
        Label l = (Label)row.FindControl("Label2");
        if (l.Text == "Unpaid")
        {
            int productID = Convert.ToInt32(GridView2.DataKeys[row.RowIndex].Value);
            no[i] = productID;
            i++;
         }
     }
}

Best Answer

to achieve you have to disable paging before loop. rebind the grid & perform loop . Then enable paging & bind the grid again.

       protected void Button5_Click(object sender, EventArgs e)       
 { 
GridView2.AllowPaging = false;
 // do your databind here 
GridView2.databind(); 
int[] no = new int[GridView2.Rows.Count];      
          int i = 0;        
    foreach (GridViewRow row in GridView2.Rows)      
      {                             
   Label l = (Label)row.FindControl("Label2");
                    if (l.Text == "Unpaid")        
            {                    
    int productID = Convert.ToInt32(GridView2.DataKeys[row.RowIndex].Value);                        no[i] = productID;                        i++;                    }                }  


              )



GridView2.AllowPaging = true;
        // do your databind here again
        GridView2.databind();

Related Solutions

C# – Retrieving all GridViewRow objects from a GridView control with paging enabled

Yes because your gridview UI is only aware of the current page. Get the datasource and determine the row count from there...

        int count = ((DataTable)MyGridView.DataSource).Rows.Count;

//or

        int count = ((ICollection<SomeRecord>)MyGridView.DataSource).Count;

C# – Count total rows of gridview with pagination

if you're using sqldatasource or objectdatasource You need to use the ReturnValue of the ObjectDataSourceStatusEventArgs or SqlDataSourceStatusEventArgs while handling the datasource's Selected event.

If you are using sqldatasource, you can count the total rows using the 'Selected' event which gets fired after the select operation has been completed.

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
  int rowCount = e.AffectedRows;
}

If you're using object data source, it's important to note that the Selected event on the ODS gets called twice, once returning the data set, and again to call the method you specified in the SelectCountMethod property. Simply test to see if the return is an Int32 in the event.

protected void ObjectDataSource1_Selected(object sender, ObjectDataSourceStatusEventArgs e)
{
    if (e.ReturnValue.GetType() == typeof(System.Int32))
        int rowCount = (Int32)e.ReturnValue;
}

You can find a working example at: http://www.webswapp.com/codesamples/aspnet20/dropdownlist_gridview/default.aspx

if your GridView is being filled by a DataSet or DataTable:

int rowCount=((DataTable)Customer).Rows.Count;

If you are binding the list or array of objects then you can do the following:

int rowCount = ((Customer[])gv.DataSource).Count;

Best Answer

Related Solutions

C# – Retrieving all GridViewRow objects from a GridView control with paging enabled

C# – Count total rows of gridview with pagination

Related Topic