12. april 2008 - 19:07Der er
15 kommentarer og 1 løsning
Indsæt data i mysql db med vb.net
Hey,
Jeg forsøger at smide data ind i en MySQL database ved hjælp af en textbox. Når jeg klikker på min submit knap, skal den kører funktionen: SubmitBtn_Click. Den ser således ud:
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim conn As New MySql.Data.MySqlClient.MySqlConnection Dim myConnectionString as String
conn.Close() Catch ex As MySql.Data.MySqlClient.MySqlException End Try End Sub
Men jeg får en fejl, på linie 20(conn.CommandText), når jeg forsøger at kører siden:
Line 18: conn.Open() Line 19: Line 20: conn.CommandText = "Insert Into Test (" _ Line 21: & "test1, test2 ) values (" _ Line 22: & "'" & Replace(txtLastName.Text, "'", "''") _
Er der nogen der kan gennemskue, hvor jeg laver fejlen og hvordan jer retter den?
Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30456: 'CommandText' is not a member of 'MySql.Data.MySqlClient.MySqlConnection'.
Connection must be valid and open Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Connection must be valid and open
Source Error:
Line 28: Line 29: Line 30: com.ExecuteNonQuery() Line 31: Catch ex As MySql.Data.MySqlClient.MySqlException Line 32: End Try
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.