how to delete row from gridview using datatable

Question

2.33/5 (2 votes)

See more:

i have link button name "delete" in gridview:
when i click on any row delete button that row delete from gridview

and i use datatable to bind gridview

i dont knw how to do it ...

Posted 9-Nov-13 8:04am

priyanshbhaliya

Add a Solution

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)

ridoy · Answer 1 · 2013-11-09T09:10:00

Solution 2

I think you need something like this one:

ASP.Net GridView - Delete Row with Confirmation[^]

Posted 9-Nov-13 9:10am

ridoy

Comments

anurag19289 9-Nov-13 15:15pm

nice..thank you

ridoy 9-Nov-13 15:26pm

Thank you.

priyanshbhaliya 9-Nov-13 22:57pm

i try this but i dont work.... in my case

ridoy 10-Nov-13 1:53am

So share your code here, or find the error and tell about that.

priyanshbhaliya 10-Nov-13 8:04am

this is my code:
gridview:
<asp:GridView ID="gvSavedetails" runat="server" >
<columns>
<asp:TemplateField>
<itemtemplate>
<asp:LinkButton ID="lnkDelete" CausesValidation="false" CommandArgument='<%#Eval("cust_id") %>' CommandName="Del" runat="server" OnClientClick="return confirm('Are you sure you want to delete this Customer?');">
<img src="Image/delete.jpg" alt="delete" />

on rowcommand event:
Protected Sub gvSavedetails_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles gvSavedetails.RowCommand

If e.CommandName = "Del" Then

Dim dt As DataTable = TryCast(ViewState("add"), DataTable)
Dim dr As DataRow
For Each dr In dt.Rows
If (dr("cust_id").ToString = e.CommandArgument) Then
dr.Delete()
End If
dt.AcceptChanges()
Next

gvSavedetails.DataSource = dt
gvSavedetails.DataBind()
ViewState("add") = dt
End If

End Sub

error come on foreach loop:
"Collection was modified; enumeration operation might not execute."

ridoy 10-Nov-13 9:25am

glad to see you find the solution.

priyanshbhaliya · Answer 2 · 2013-11-10T02:16:00

Solution 3

i just change foreach to for loop and its done...

VB

If e.CommandName = "Del" Then

    Dim dt As DataTable = TryCast(ViewState("add"), DataTable)

    For i As Integer = 0 To dt.Rows.Count - 1
        If (e.CommandArgument = dt.Rows(i)("cust_id").ToString) Then
            dt.Rows.Remove(dt.Rows(i))
        End If
    Next
    gvSavedetails.DataSource = dt
    gvSavedetails.DataBind()
    ViewState("add") = dt
End If

thnks to all commentates ...for helping..

Posted 10-Nov-13 2:16am

priyanshbhaliya

Comments

CHill60 10-Nov-13 8:32am

It's important that you understand the original problem so just to wrap this up for you, the reason you got the error on your first attempt was because the collection of rows referred by the For Each was altered by removing an item from the collection. The way that "gap" would be treated cannot then be guaranteed - hence the message.
Similarly in your new approach ... if you have an item with index 3 and delete it, is the next item now at index 3 or still at index 4?
Depending on the language/compiler etc you might get different results - and they can sometimes be very difficult to debug!
I usually get around this problem by starting my loop at the END of the collection and moving towards the start - that way the index of the "next" item will always be assured. I.e. I would use For i As Integer = dt.Rows.Count - 1 to 0 Step -1

priyanshbhaliya 10-Nov-13 8:46am

thnks

NorouziFar · Answer 3 · 2013-11-09T09:05:00

Solution 1

use this link:
how-to-delete-a-row-on-gridview-on-button-click-and-generate-javacript-validatio

Posted 9-Nov-13 9:05am

NorouziFar