删除datagridview中的选定行 [英] delete selected rows in datagridview

问题描述

您好



i想要从datagridview和表中删除所选行，



当我选择来自datagridview的多行并按删除然后它只删除

一行。



ex。

1 John

2 Raju

3 Vikey

4 Lisha

5米歇尔



如果我选择第1和第3条记录，那么我想从数据库中删除。



这里是我的代码。

< pre lang =vb> con.Open（）
对于 i = 1 DataGridView1.Rows.Count - 2
ss = 从评分中删除ID =& DataGridView1.SelectedRows（i）.Cells（ 0 ）。Value&
com = 新 OleDbCommand（ss，con）
com.ExecuteNonQuery（）

下一步
con.Close（）
MsgBox（ 数据已成功删除！）

解决方案

我认为这段代码可以帮到你。

 con.Open（）
 对于 i =  0    DGVFrom.SelectedRows.Count  -   1  
 ss =  从评分中删除ID =& DataGridView1.SelectedRows（i）.Cells（ 0 ）。Value&   
 com = 新 OleDbCommand（ss，con）
 com.ExecuteNonQuery（）
 
 下一步 
 con.Close（）
 MsgBox（ 数据已成功删除！）

你在循环中显示消息框，所以当它显示时，只有一个项目会被删除。

 如果（MessageBox.Show（ 是否要在关闭前删除数据此表单， ，MessageBoxButtons.YesNo，MessageBoxIcon.Question））= Windows .Forms.DialogResult.Yes 然后 ' 用户选择是。 
  Dim  connectionstring  As  字符串 =   Driver = MySQL ODBC 3.51 Driver; Server = localhost; port = 3306; uid = root; pwd = admin;数据库= elcott; 
  Dim  conn  As  新 OdbcConnection（connectionstring）
 conn.Open（）
  Dim  strsql 作为 字符串 
 strsql =  从userpass删除其中username ='& txUsername.Text&  ' 
  Dim  sqlcmd 作为 新 OdbcCommand 
 sqlcmd.CommandText = strsql 
 sqlcmd.Connection = conn 
 sqlcmd.ExecuteNonQuery（）
 DataGridView1.Show（）
 MessageBox.Show（ 信息已成功删除。）
 txUsername.Text =   
 txPassword.Text =   
 txLastName.Text =   
 txFirstName.Text =   
 txMI.Text =   
 conn.Close（）
  ElseIf  MsgBoxResult.No 然后 
 MessageBox.Show（ 你没有删除您的信息!!!）
 txUsername.Text =   
 txPassword.Text =   
 txLastName.Text =   
 txFirstName.Text =   
 txMI.Text =   
 结束 如果 

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.

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 !")

解决方案

hi,
I think this code may help you.

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 !")

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

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

这篇关于删除datagridview中的选定行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！