麻烦各位给我看看下面这段代码!
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim strAccConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\data.mdb"
Dim objConn As New OleDbConnection(strAccConn)
Dim objComm As New OleDbCommand("delete from myfriend where name=magerate", objConn)
Try
objConn.Open()
objComm.ExecuteNonQuery()
Catch myException As Exception
MessageBox.Show(myException.ToString())
End Try
End Sub
返回的错误如下:
System.Data.OleDb.OleDbException: 至少一个参数没有被指定值。
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at database1.Form1.Button3_Click(Object sender, EventArgs e) in H:\Visual Studio_net Projects\vb\database1\Form1.vb:line 148