æ¹æ³æå¤ç§ã
å¯ä»¥dataAdapter.Fillå°æ°æ®è¡¨åºè¯¥ï¼è®¾ç½®å 个commandï¼åéè¿dataAdapter.Updateå°±å¯ä»¥æ´æ°æ°æ®äºãä¸è¿è¡¨è¦æä¸ä¸ªå
³é®çkeyå§ã
å¦å¤ä¸ç§ç´è§ä¸ç¹ï¼
ä¹éè¦è¡¨æ个å
³é®keyæå°±æ¯å
³é®å段ã
ä½ datagridview.reomveAt(index)åæ¶æ§è¡sqlcommand("delete * From table where keyFild='" & key & "'")å°±å¯ä»¥ã
åèä¸ä¸ªå®ä¾ï¼å¦ä¸ï¼
Private Sub bitDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bitDelete.Click
Dim oraConn As New OracleConnection()
oraConn.ConnectionString = " data source=æ°æ®åºåå;user id=è´¦å·;password=å¯ç "
oraConn.Open()
Dim id As String = DataGridView1.CurrentRow.Cells(0).Value.ToString().Trim()
Dim queryString = "delete from t where id ='" & idå· & "'"
Dim adapter As OracleDataAdapter = New OracleDataAdapter(queryString,oraConn)
Dim mark As DataSet = New DataSet
adapter.Fill(mark, "Mark")
MessageBox.Show("å é¤æ°æ®æå!")
Dim adapter As OracleDataAdapter = New OracleDataAdapter("select * from t ORDER BY id", oraConn)
Dim score As DataSet = New DataSet()
adapter.Fill(score , "Score ")
DataGridView1.DataSource = score
DataGridView1.DataMember = score .Tables(0).ToString
oraConn.Close()
End Sub
温馨提示:答案为网友推荐,仅供参考