gridview_rowDeleting() will be deleted two times

Question

0.00/5 (No votes)

See more:

Hi,
When i delete the record using gridview_rowDeleting() it will be deleted two time.
when it deletes first time, it will deleted value properly.
Why it will come second time for the same record deletion. here i am getting error. Index range must be out of driven
see code

Protected Sub grdDeptEmp_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles grdDeptEmp.RowDeleting
        'Dim EmpNo As Integer = Convert.ToInt32(grdDeptEmp.DataKeys(e.RowIndex).Values(0).ToString())
        Dim EmpNo As Integer = CInt(grdDeptEmp.DataKeys(e.RowIndex).Value)
        'Dim lblEmpNo As Label = DirectCast(grdDeptEmp.Rows(e.RowIndex).FindControl("lblEmpNo"), Label)
        If EmpNo.ToString IsNot Nothing Then
            Conn.Open()
            StrQry = ""
            StrQry = "delete from OtherDeptEmp where emp_number='" & EmpNo & "'"
            Cmd.Connection = Conn
            Cmd.CommandText = StrQry
            'Cmd.ExecuteNonQuery()
            Conn.Close()
        End If
        FillGrid()
    End Sub

what is the problem over here..?

Posted 11-Jul-11 22:46pm

gani7787

Updated 11-Jul-11 22:49pm

Prerak Patel

v2

Add a Solution

Comments

gani7787 12-Jul-11 5:08am

I will fire two times. in the second time the EmpNo is field getting error. because i deleted the record. again it will read the same record when coming inside.

gani7787 12-Jul-11 5:18am

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

2 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)

nilesh ubhe · Answer 1 · 2011-07-11T23:55:00

Solution 1

call the<b> databind() </b>function in the fillgrid() method after every successfull operation

Posted 11-Jul-11 23:55pm

nilesh ubhe

v2

Al Moje · Answer 2 · 2011-07-12T00:28:00

Hi,

I think you should handle this in RowCommand event.
You may try this:

 Protected Sub grdDeptEmp_RowCommand(ByVal sender As Object, _
   ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles grdDeptEmp.RowCommand
   If e.CommandName = "DeleteCmd" Then
      Dim rowNo As Integer = Integer.Parse(e.CommandArgument)
      Dim EmpNo As String = grdResult.DataKeys(rowNo).Item("emp_number").ToString.Trim
      Conn.Open()
      StrQry = ""
      StrQry = "delete from OtherDeptEmp where emp_number='" & EmpNo & "'"
      Cmd.Connection = Conn
      Cmd.CommandText = StrQry
      'Cmd.ExecuteNonQuery()
      Conn.Close()
   End If
   FillGrid()
End Sub

In your client code Grid example:

<asp:ButtonField CommandName="DeleteCmd" Text="Delete"/>

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Regards,

Algem