我在从vb.net的datagridview中删除一行时遇到问题 [英] i have a problem in deleting a row from datagridview in vb.net

问题描述

大家好，
我在数据库中有一个表，并且在表单中有一个datagridview.gridview绑定到表上.我的表单上还有一个按钮，其名称为Delete.当我的网格视图显示表数据时，然后在网格视图中选择一行.然后单击按钮.我选择的行应从gridview以及db表中删除.我的代码在此处用于此工作:

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:

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

ID是我的表格列之一.
问题是此代码从网格视图中删除了我选择的行，但是此代码并未从db中的表中删除我选择的行.此代码从db中的表中删除了我选择的行的下一行.
我需要快速帮助.

感谢All in Advance.

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.

推荐答案

您好，
请点击以下链接.可能会对您有帮助.
http://www.eggheadcafe.com/community/aspnet/2/10045544/help-to-delete-rows-in-gridview.aspx [

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

根据我的情况
将您的代码放置在DataGridView中，以加载/获取数据
函数中可以命名吗
我喜欢这样
宣告功能

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()

在loadData()函数下，我正在DataGridView中获取数据.
无需使用
DataGridView2.Rows.Remove(行)
根据您的要求实现此目的

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

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 :)

这篇关于我在从vb.net的datagridview中删除一行时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！