从datagridview删除记录 [英] Deleting a record from the datagridview

问题描述

在VB2012中，我创建了一个以SQL2012作为后端的学生管理软件。以下代码用于在单击DELETE按钮时从datagridview中删除选定的记录：

In VB2012, I have a created a student management software with SQL2012 as the back-end. The below code is used for deleting a selected record from the datagridview when DELETE button is clicked:

 Private Sub Delete_Click(sender As Object, e As EventArgs) Handles Delete.Click
        Dim DelStudent As StudentDataSet1._masterRow
        DelStudent= CType(CType(StudentmasterBindingSource.Current, DataRowView).Row, StudentDataSet1.Student_masterRow)
        DelStudent.Delete()
        Me.Validate()
        Me.StudentmasterBindingSource.EndEdit()
        Me.Student_masterTableAdapter.Update(StudentDataSet1.Student_master)
End Sub

但是，除了被删除的行之外，第一行被删除。请帮助...

But instead of the selected row being deleted, the first row gets deleted. Please help...

推荐答案

下面的代码也是有帮助的

the code below is also helpful

 Private Sub btnRemoveItem_Click(sender As Object, e As EventArgs) Handles btnRemoveItem.Click
        If datagridviewname.SelectedRows.Count > 0 Then
            For i As Integer = datagridviewname.SelectedRows.Count - 1 To 0 Step -1
                datagridviewname.Rows.RemoveAt(datagridviewname.SelectedRows(i).Index)
            Next
        Else
            MessageBox.Show("Select Row to remove")
        End If
    End Sub

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