connection between vb.net and mysql

[applemynt]

i have a problem here...i've already created a registration form using vb.net and i used mysql as the database...but i dont know how the input/data from the registration form can be send to the database...is there anyone know the code???

[YottaHertz]

Umm... first off you need to D/L and install the MyOLEDB driver from the MySQL site - I think....
Then the code you would use would look something like this....

Dim fdCon As  New OleDb.OleDbConnection("Provider=MySQLProv;Data Source=DATABASE;User Id=YOURSQLUSERNAME;Password=YOURSQLPASSWORD;")
Dim fdCom As New OleDb.OleDbCommand("", fdCon)

fdCom.Connection.Open()

Dim fdRead As OleDb.OleDbDataReader = fdCom.ExecuteReader(CommandBehavior.CloseConnection)

fdCom.CommandText = "INSERT INTO TABLENAME (FIELDNAME1, FIELDNAME2) VALUES ('" & ImaVar1 & "', '" & ImaVar2 & "')"
fdCom.ExecuteNonQuery()

fdCon.Close()

I'm not sure how you would go about fetching input fields values from the form but I assume you would the the input field name as the variable name....