i have a problem in deleting a row from datagridview in vb.net

Question

0.00/5 (No votes)

See more:

Hello All,
I have a table in database.and a datagridview in my form.gridview bindes to the table.also my form has a button that its name is Delete.when my grid view shows the tables data and then i choose a row in grid view.and then click the button.the row which i choose should be deleted from gridview and also from table in db.my code is here for this job:

VB

Private Sub ButtonX4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX4.Click
        For Each rows As DataGridViewRow In DataGridView2.SelectedRows
            DataGridView2.Rows.Remove(rows)
            Dim command As SqlCommand
            Dim delete As String
            delete = "DELETE FROM [leitnertable] Where (ID) = " & DataGridView2.CurrentRow.Cells(0).Value & ""
            command = New SqlCommand(delete, con)
            If command.Connection.State = ConnectionState.Closed Then command.Connection.Open()
            command.ExecuteNonQuery()
        Next
    End Sub

ID is one of my table columns.
The problem is that this code delete the row which i choose, from grid view but this code dose not delete the row i choose, from table in my db.ths code delete the next row of the row i choose,from table in db.
I need a quick help.

Thanks to All in Advance.

Posted 28-Jun-11 18:34pm

nafiseh.s

Updated 29-Jun-11 18:23pm

Ramalinga Koushik

v3

Add a Solution

3 solutions

Solution 1

Hello,
Please follow the below link. it may help you.
http://www.eggheadcafe.com/community/aspnet/2/10045544/help-to-delete-rows-in-gridview.aspx[^]

thanks
sanjeev

Posted 28-Jun-11 18:40pm

SanjeevSingh

Solution 2

As per me
Place your Code what you have Written to load/Fetch the Data in DataGridView
inside a Function May you name it
I Did like this
Declared a Function

Public Sub RecordDelete()
        Dim id As Integer = DataGridView1.SelectedCells.Item(0).Value()
        Dim cmd As New SqlCommand("Delete From Tst_Bank where ID='" & id & "'", myCon.con())
        cmd.ExecuteNonQuery()
        loadData()
    End Sub

And on Delete Button Click

RecordDelete()

Under loadData() Function I am Getting the Data inside the DataGridView.
No need to Use
DataGridView2.Rows.Remove(rows)
Implement this as per your Requirement

Posted 28-Jun-11 20:14pm

Karwa_Vivek

Updated 28-Jun-11 20:16pm

v2

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)

nirav raval · Accepted Answer · 2011-06-29T18:18:00

VB

Private Sub ButtonX4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX4.Click
        For Each rows As DataGridViewRow In DataGridView2.SelectedRows
            
            Dim command As SqlCommand
            Dim delete As String
            delete = "DELETE FROM [leitnertable] Where (ID) = " & DataGridView2.CurrentRow.Cells(0).Value & ""
            command = New SqlCommand(delete, con)
            If command.Connection.State = ConnectionState.Closed Then command.Connection.Open()
            command.ExecuteNonQuery()
            command.Connection.Close()
'Just first remove from the database and then reload the datagrid or remove it manually... as you like
            DataGridView2.Rows.Remove(rows)
        Next
    End Sub

hope this help :)