Solved

Paging in GridView

Posted on 2011-02-23
24
409 Views
Last Modified: 2012-05-11
When click on the second page of a gridview I get the following error;

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

error line;

Line 213:            string Assignid = ((Label)(GridView1.Rows[rowIndex].FindControl("lblAssignId"))).Text.ToString();

the error is generated from this line of markup

          <asp:TemplateField ShowHeader="False" meta:resourcekey="TemplateFieldResource5">
              <ItemTemplate>
                     <asp:LinkButton ID="lbA" runat="server" CausesValidation="False" CommandName="Ap"  CommandArgument='<%# Container.DisplayIndex %>' Text="Approve" meta:resourcekey="lbApproveResource1"></asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>


code-behind

  protected void ItemCommand(object sender, GridViewCommandEventArgs e)

    {
        int rowIndex = Convert.ToInt32(e.CommandArgument);

            string Assignid = ((Label)(GridView1.Rows[rowIndex].FindControl("lblAssignId"))).Text.ToString();
pls help me tofix the error.

thanks

ayha
0
Comment
Question by:ayha1999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 12
  • 12
24 Comments
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963160
int rowIndex = Convert.ToInt32(e.CommandArgument);

And what is the value of rowIndex ?
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34963243
rowIndex value is value of "Container.DisplayIndex":  from the following field

  <asp:LinkButton ID="lbA" runat="server" CausesValidation="False" CommandName="Ap"  CommandArgument='<%# Container.DisplayIndex %>' Text="Approve" meta:resourcekey="lbApproveResource1"></asp:LinkButton>
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963253
But what is the value 2, -37, 987657....
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
LVL 7

Author Comment

by:ayha1999
ID: 34963304
did I mentioned 2, -37, 987657.... anywhere in my question? only two rows there in my gridview. when click on the 2nd page the error occurs.
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963379
From your question
Index was out of range. Must be non-negative and less than the size of the collection.


I am asking you, now for the third time, what is the value of the index.  Believe me it should help in solving your problem.
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34963437
value of rowIndex is 2.
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963513
OK, how many rows do you have in your gridview?
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34963522
only two rows.
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963547
That is your problem.
The first row has an index of 0, the second has an index of 1.  
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34963602
yes. how can I fix it?
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963623
The obvious fix is
int rowIndex = Convert.ToInt32(e.CommandArgument) - 1;

but I don't know if you actually send a zero for the first row.  It all depends on what you use for the e.CommandArgument
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34963667
the purpose of the rowIndex is:

protected void ItemCommand(object sender, GridViewCommandEventArgs e)
{
  int rowIndex = Convert.ToInt32(e.CommandArgument);

            string RequestId = ((Label)(GridView1.Rows[rowIndex].FindControl("lblRequestId"))).Text;
            if (User.IsInRole("Admin"))
            {
                Response.Redirect("~/PassEntry.aspx?RequestId=" + RequestId.ToString());
            }
            else
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963719
I don't see your complete code, I don't know what it should be doing.

I have helped you find the error and told you why you get the error.  Exactly what you do is really up to your requirements.

IF the index is always 1 too many then just subtract 1.
If the index is usually correct then you need to check if the index is greater than the number of rows (or less than zero) and take appropriate action (leave the function / give a warning / ....)
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34963752
even , int rowIndex = Convert.ToInt32(e.CommandArgument) - 1; give me the same error.
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963772
What is the value of rowIndex when that gives the error ?
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34963832
rowIndex=1
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34963951
OK.
This is what you say
GridView1.Rows[1] gives you an 'Index out of range' error, and GridView1 has 2 rows at that point.

That makes me think that GridView1 isn't what you think it is.

Have some code like this AND CHECK THE VALUES

int rowIndex = Convert.ToInt32(e.CommandArgument) - 1;
int rowCount = GridView1.Rows.Count;
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34972708
rowIndex = 1
rowCount = 1
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34973436
rowCount = 1  means (as I told you earlier) that the only valid index is 0.  Hence the error.
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34973485
so what is the solution here? I think by changing the following lines it can be solved.

  int rowIndex = Convert.ToInt32(e.CommandArgument);

            string RequestId = ((Label)(GridView1.Rows[rowIndex].FindControl("lblRequestId"))).Text;

I want to retrive the value of lblRequestId Label in the item command. that's what I am doing here. is there any other way I can retrive the value?

but I have no idea how to do it.
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 34973555
I don't know where this e.CommandArgument comes from.
I also don't know if this function is being called multiple times, sometimes with the value you expect and then with an out of range value.

You should know these things AND, more importantly, what you need to do in those cases.


I **guess** you have always a value 1 more than the actual row index.
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34973763
e.CommandArugment comes from;

<asp:LinkButton ID="lbA" runat="server" CausesValidation="False" CommandName="Ap"  CommandArgument='<%# Container.DisplayIndex %>' Text="Approve" meta:resourcekey="lbApproveResource1"></asp:LinkButton>

I have linkbuttons in the gridvew1. when user click on any link button, I want to retrieve the value of the clicked row. (value of any cell(0) for example.) to find the clicked row I use the above e.CommandArugment.

is there any other way to get the value? I think that will solve the paging problem.

thanks
0
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 250 total points
ID: 34973819
If this value is always 1 too high then just subtract 1:
int rowIndex = Convert.ToInt32(e.CommandArgument) - 1;

You should be able to check the values yourself, I don't know where the value being passed into the function is generated or where it comes from should it be hard coded somewhere.
0
 
LVL 7

Author Comment

by:ayha1999
ID: 34974116
without deducting it the problem is solved.

 if (e.CommandName == "CreateWo")
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument);
            string RequestId = ((Label)(GridView1.Rows[rowIndex].FindControl("lblRequestId"))).Text;
        }
        else if (e.CommandName == "Approve")  <----- only 'else' was here. I changed to 'else if'
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument);
           // int rowCount = GridView1.Rows.Count;

thank u very much for your time and support
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question