'This are my codes. I am trying to Insert data into my database(MS ACCESS).
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
con.Open()
Dim cmd As New OleDbCommand(strcon)
Dim strSQl As String = _
"INSERT into Tutor Values('" + _
tbemail.Text + "','" + _
tbpassword.Text + "','" + _
tbname.Text + "','" + _
rbgender.SelectedValue + "','" + _
tbcontactno.Text + "','" + _
tbaddress.Text + "','" + _
tbcountry.Text + "','" + _
tbDOB.Text + "','" + _
tbnric.Text + "','" + _
tbpostalcode.Text + "')"
cmd.CommandText = strSQl
cmd.ExecuteNonQuery()
Response.Redirect("confirmation.aspx")
End Sub
End Class
2006-07-04
09:03:15
·
2 answers
·
asked by
cherylgis
1
in
Programming & Design