Question

vb.net中DataGridView控件中，怎么删除选定的某一行，并删除数据库中对应的记录

求解详细代码，感激不尽

Answer 1

Dim myConn As Data.OleDb.OleDbConnection
myConn = New System.Data.OleDb.OleDbConnection()
myConn.ConnectionString = strCon
myConn.Open()
Dim sqldel As String = "delete from Table where AAA='"&datagridview1.CurrentRow.Cells(i).Value.ToString.Trim()&"'
Dim del As OleDbCommand = New OleDbCommand(sqldel, myConn)
del.ExecuteNonQuery()
myConn.Close
然后再重新帮顶下datatable显示一下就ok了

追问

你能解释一下吗，我有点看不懂，我想问这是vb.net版的吗

追答

是的，
myConn = New System.Data.OleDb.OleDbConnection()
myConn.ConnectionString = strCon
myConn.Open() ‘连接数据库
Dim sqldel As String = "delete from Table where AAA='"&datagridview1.CurrentRow.Cells(i).Value.ToString.Trim()&"' ’sql语句
Dim del As OleDbCommand = New OleDbCommand(sqldel, myConn)
del.ExecuteNonQuery() ‘执行sql语句
myConn.Close ’关闭数据库