pls am creating an application that involve database with vb.net, but i the application did not insert the input field in the database. this is my code.
Private Sub btnOk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOk.Click

Dim myConnectionString As String

myConnectionString = "server=127.0.0.1;" _
& "uid=root;" _
& "pwd=;" _
& "database=data_book;"

Try
Dim conn As New MySql.Data.MySqlClient.MySqlConnection(myConnectionString)
conn.Open()
Catch ex As MySql.Data.MySqlClient.MySqlException
Select Case ex.Number
Case 0
MessageBox.Show("Cannot connect to server. Contact administrator"
Case 1045
MessageBox.Show("Invalid username/password, please try again"
End Select
End Try
Try
Dim cmd As New MySqlCommand(String.Format("INSERT INTO `data_book` (`id`, `first_name`, `middle_name`, `last_name`, `sex`, `mar_status`, `state`, `local_gov`, `home_add`, `office_add`, `phone_no`, `email`) " & _
"VALUES (NULL , '{0}', '{1}',`firName.text`, `midName.text`, `lstName.text`, `sex.text`, `marStar.text`,`stOrigin.text`, `lclGov.text`, `homeAdd.text`, `officeAdd.text`, `phNum.text`, `email.text` ); ", conn)
cmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox("Your Record Added Successfully!", MsgBoxStyle.Information, "Successful!"
End Try
cmd.CommandText = "INSERT INTO 'data_book' (first_name, middle_name, last_name, 'sex', mar_status, state, local_gov, home_add, office_add, phone_no, email) " & _
"VALUES (firName.text, midName.text, lstName.text, sex.text, marStar.text,""stOrigin.text"", ""lclGov.text"", ""homeAdd.text"", ""officeAdd.text"", ""phNum.text"", ""email.text"" ); "

End Sub

At has to throw an error somewhere. Definitely your INSERT STATEMENT is wrong
change
Catch ex As Exception
MsgBox("Your Record Added Successfully!", MsgBoxStyle.Information, "Successful!")
End Try

to

Catch ex As Exception
MsgBox(ex.Message)
End Try

post back the error