Re: I must be tarded.. please help

[vacantplanet1]

Ok how would add a row and update the db with the following code? The company table has three fields: An autoincrementing primary key, companyName, and otherOffices. I'm sure seeing how it's done will help permeate the notion in my brain.

Try
conn.Open()
Label1.Text = "Connection Opened Successfully"
Dim myCommand As New MySqlCommand()
Dim myAdapter As New MySqlDataAdapter()
Dim myData As New DataTable()
Dim SQL As String
SQL = "select * from company"
myCommand.Connection = conn
myCommand.CommandText = SQL
myAdapter.SelectCommand = myCommand
myAdapter.Fill(myData)

dim companyName as string = "Whatever INC."
dim otherOffices as Boolean = false

conn.Close()
Catch myerror As MySqlException
Label1.Text = "Error Connecting to Database: " & myerror.Message
Finally
conn.Dispose()
End Try