thanks roy, this is an example of the SQL version i tried to use :
Try
' ensure first and last name input
If (txtLastName.Text <> "" AndAlso txtFirstName.Text <> "") Then
' create the SQL query to insert a row
dbQuccAdapter1.InsertCommand.CommandText = _
"INSERT INTO addresses(firstName, " & _
"lastName) " & _
"VALUES('" & txtFirstName.Text & "' , " & _
"'" & txtLastName.Text & "' )"
' send query
dbQuccAdapter1.InsertCommand. _
ExecuteNonQuery()
Catch exception As System.Data.OleDb.OleDbException
Console.WriteLine(exception.StackTrace)
txtStatus.Text &= exception.ToString
End Try
i get an error... usually on executing :
ExecuteNonQuery()
don't know what the problem is ..but the book i used to do this had a different way connecting to the database and making the adapter and dataset i tried it's way but it didn't work but on the example from the books cd there was an oledbcommand tool for the insert, select, delete, and update queries????
About the MySQl isn't that a database that works on the internet for web projects? because mine is a windows based project..
thanks again