deleting problem from gridview

Question

0.00/5 (No votes)

See more:

hi, when i am deleting the row from gridview then getting errors-Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index i have a code-

C#

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string autoID = GridView1.DataKeys[e.RowIndex].Value.ToString();
        SqlConnection con = ConnectionClass.GetConnection();
        SqlCommand cmd=new SqlCommand("delete from information where id='"+ Convert.ToInt32(autoID) + "'", con);
        cmd.ExecuteNonQuery();
        con.Close();
        ShowData();
    }

Plz give me a solution

Posted 13-Jul-12 2:23am

mahendra bindwari

Updated 13-Jul-12 2:25am

Prasad_Kulkarni

v2

Add a Solution

4 solutions

Solution 1

GridView Delete, with Confirmation[^]

Insert, Update, Delete with Gridview....simple way[^]
Updating, Deleting records using GridView control[^]
GridView Row Edit, Delete and Update[^]
Insert Update Edit Delete Rows Record In GridView[^]

Posted 13-Jul-12 2:26am

Prasad_Kulkarni

Comments

Manas Bhardwaj 16-Jul-12 5:56am

5ed!

Prasad_Kulkarni 16-Jul-12 8:28am

Thank you Manas!

Solution 4

I think you have multiple datakeys defined for this gridview

DataKeyName="autoID,anotherColumn"

If this is your case then try specifying the index of the key in your code like below

C#

GridView1.DataKeys[e.RowIndex].Value[0].ToString();

Posted 13-Jul-12 3:37am

Shemeer NS

Solution 3

Hi,

i thing the error is from the DataKeys collection.
if you can get autoID as one of the gridview columns then simply you can use like this..

C#

//here 0 may be replaced with the column index of the autoID inside gridview.
string autoID = e.Row.Cells[0].Text;
 SqlConnection con = ConnectionClass.GetConnection();
 SqlCommand cmd=new SqlCommand("delete from information where id='"+ Convert.ToInt32(autoID) + "'", con);
 cmd.ExecuteNonQuery();

hope it helps..

Posted 13-Jul-12 2:29am

Karthik Harve

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)

AshishChaudha · Accepted Answer · 2012-07-13T02:28:00

Solution 2

Integer value need not ''

SQL

SqlCommand cmd=new SqlCommand("delete from information where id="+ Convert.ToInt32(autoID) + "", con);

Have you checked the value of autoID

Please check the value of autoID by using DEBUGGER.

Thanks
Ashish

Posted 13-Jul-12 2:28am

AshishChaudha

Comments

[no name] 13-Jul-12 8:30am

my 5+

AshishChaudha 13-Jul-12 8:31am

Thanks Mits

Shemeer NS 13-Jul-12 9:43am

5'ed for good guidance...

AshishChaudha 13-Jul-12 9:59am

thanx

Manas Bhardwaj 16-Jul-12 5:56am

5!

AshishChaudha 16-Jul-12 7:14am

Thanks Manas