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

Question

1.00/5 (1 vote)

See more:

hey i m trying to delete the row from the grid view but i m getting an error
Must be non-negative and less than the size of the collection. Parameter name: index

please help me out thanks in advance

C#

string Id = GridView1.DataKeys[e.RowIndex].Value.ToString();
           
            string s = "DELETE Product_Info where product_info.Id ="+Id+"";

            BindGridData();

Posted 9-Aug-12 10:22am

Abhimanyu vij

Updated 9-Aug-12 10:27am

Christian Amado

v2

Add a Solution

Comments

StianSandberg 9-Aug-12 16:25pm

Your code is vulnerable for sql injections
http://www.codeproject.com/Articles/425150/Beginners-guide-to-a-secure-way-of-storing-passwor#sqlinjections

The error is because e.RowIndex gives you a number which is larger than the number og datakeys. Or datakeys has no values. Try your debugger..

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

wizardzz · Answer 1 · 2012-08-09T11:30:00

Solution 2

'e.RowIndex' is likely trying to access an index that there is no data for. My guess would be it is '-1' Use debugger and check the value of e.RowIndex. Only attempt to execute this portion of code if it is valid.

Posted 9-Aug-12 11:30am

wizardzz

Updated 9-Aug-12 11:32am

v2

_Amy · Answer 2 · 2012-08-09T17:54:00

Solution 3

You can specify a specific cell in a GridView. In your code, you can just replace:

C#

GridView1.DataKeys[e.RowIndex].Values

with:

C#

GridView1.Rows[e.RowIndex].Cells[0].Text

--Amit

Posted 9-Aug-12 17:54pm

_Amy

Christian Amado · Answer 3 · 2012-08-09T10:30:00

Solution 1

C#

string Id = GridView1.Rows[e.RowIndex].Cells[your_current_colum_index].Text;
           
            string s = "DELETE Product_Info where product_info.Id ="+Id+"";
 
            BindGridData();

The error is not in e.RowIndex. If you breakpoint the first line you'll see what I talking about.

So, I think the error is in DataKey collection (is null). When you try to get the value from the element inside DataKey exception appears.

Hope it helps

Posted 9-Aug-12 10:30am

Christian Amado

Updated 10-Aug-12 0:57am

v2

Comments

Christian Amado 9-Aug-12 17:43pm

And the downvoted was for???

Philip Stuyck 9-Aug-12 17:56pm

Don't know looks correct to me +5 from me.

Christian Amado 9-Aug-12 17:57pm

Thanks. All post that I wrote has tested on my pc =)

AmitGajjar 9-Aug-12 23:37pm

Someone downvote you possibly because the error message says index out of range. so problem is with RowIndex and you have not mention anything like that. this can be the reason.

Christian Amado 10-Aug-12 6:58am

RowIndex isn't the problem here.

Abhimanyu vij 16-Aug-12 13:39pm

thanks sir