delete selected rows in datagridview

Question

0.00/5 (No votes)

See more:

hi there

i want to delete selected rows from datagridview and table,

when i select multiple rows from datagridview and press delete then it delete only
one row.

ex.
1 John
2 Raju
3 Vikey
4 Lisha
5 Michel

if i select 1st and 3rd record then i want delete both from database.

here my code.

VB

con.Open()
            For i = 1 To DataGridView1.Rows.Count - 2
                ss = "Delete from Grading where ID=" &                 DataGridView1.SelectedRows(i).Cells(0).Value & ""
                com = New OleDbCommand(ss, con)
                com.ExecuteNonQuery()
                
            Next
            con.Close()
MsgBox("Data Deleted Successfully !")

Posted 3-Jan-13 16:16pm

Bhatt Aniruddh

Updated 3-Jan-13 16:32pm

v2

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)

Rahul K Singh · Answer 1 · 2013-01-03T16:55:00

Solution 3

hi,
I think this code may help you.

VB

con.Open()
            For i = 0 To DGVFrom.SelectedRows.Count - 1
                ss = "Delete from Grading where ID=" &                 DataGridView1.SelectedRows(i).Cells(0).Value & ""
                com = New OleDbCommand(ss, con)
                com.ExecuteNonQuery()

            Next
            con.Close()
MsgBox("Data Deleted Successfully !")

Posted 3-Jan-13 16:55pm

Rahul K Singh

Comments

[no name] 3-Jan-13 23:27pm

thank, it works.

Rahul K Singh 4-Jan-13 0:19am

Mark Solution if it worked. It will help others also. :)

Christian Graus · Answer 2 · 2013-01-03T16:22:00

Solution 1

You show the message box inside your loop, so when it shows, only one item will have deleted.

Posted 3-Jan-13 16:22pm

Christian Graus

Comments

[no name] 3-Jan-13 22:32pm

i solve it now..

saito najumi · Answer 3 · 2013-01-22T21:00:00

VB

If (MessageBox.Show("Do you want to delete data before closing this form", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) = Windows.Forms.DialogResult.Yes Then   ' User chose Yes.
            Dim connectionstring As String = "Driver=MySQL ODBC 3.51 Driver;Server=localhost;port=3306;uid=root;pwd=admin;Database=elcott;"
            Dim conn As New OdbcConnection(connectionstring)
            conn.Open()
            Dim strsql As String
            strsql = "Delete from userpass where username ='" & txUsername.Text & "'"
            Dim sqlcmd As New OdbcCommand
            sqlcmd.CommandText = strsql
            sqlcmd.Connection = conn
            sqlcmd.ExecuteNonQuery()
            DataGridView1.Show()
            MessageBox.Show("Information Successfully Deleted.")
            txUsername.Text = ""
            txPassword.Text = ""
            txLastName.Text = ""
            txFirstName.Text = ""
            txMI.Text = ""
            conn.Close()
        ElseIf MsgBoxResult.No Then
            MessageBox.Show("You did not Deleted your Information!!!")
            txUsername.Text = ""
            txPassword.Text = ""
            txLastName.Text = ""
            txFirstName.Text = ""
            txMI.Text = ""
        End If