Hi i wonder how can i delete my data using access as my database?
for example i want to delete
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & ConAccessDatabase & "';")
Dim cmd As OleDbCommand
cmd = New OleDb.OleDbCommand("delete * from [" & EBU2DB_LOB & "] where Brand ='" & Form_Month_End_Report.Combo_LOB_Brand.Text & "' & LOB ='" & Form_Month_End_Report.Combo_LOB_LOB.Text & "' & Months = '" & Form_Month_End_Report.Combo_LOB_Month.Text & "'", con)
Dim response As String = MsgBox("Do you want Delete ? ", MsgBoxStyle.YesNo, "Confirm")
If response = MsgBoxResult.Yes Then
If con.State = ConnectionState.Closed Then con.Open()
cmd.ExecuteNonQuery()
End If
this is my code.
but nothing seem to happen to my data..