Indsætte i mysql-database
Nogen, der kan se, hvad der er galt her:Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles OK.Click
Dim oConnection As Odbc.OdbcConnection = New Odbc.OdbcConnection(Application("ConnString"))
Dim strSQL As String = ""
strSQL = strSQL & "Insert into adgang ("
strSQL = strSQL & "BrugerInitaler, "
strSQL = strSQL & "Navn, "
strSQL = strSQL & "Adgangskode) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'" & Convert.ToString(Request("BrugerInitaler")) & "', "
strSQL = strSQL & "'" & Convert.ToString(Request("Navn")) & "', "
strSQL = strSQL & "'" & Convert.ToString(Request("Adgangskode")) & "') "
Dim cmd As New OdbcCommand(strSQL, oConnection)
oConnection.Open()
cmd.ExecuteNonQuery(strSQL)
oConnection.Close()
End Sub
Jeg får:
to many arguments to 'Overridable NotOverridable FunctionNonQuery
