in my asp.net+vb+access database web. i have a page with three text boxes coy,coyrmk,rmkdt i want to update the same through web page. i ued the foloiwng code
Protected Sub add_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles add.Click
Dim con As New OleDbConnection
con.ConnectionString = ConfigurationManager.ConnectionStrings("baijuepConnectionString").ConnectionString
con.Open()
Dim qstr As String
qstr = "update auth set coy=@coy,coyrmk=@coyrmk where coy=@coy"
Dim oledbcom As New OleDbCommand(qstr, con)
oledbcom.Parameters.Add(New OleDbParameter("@coy", OleDbType.VarChar).Value = Label5.Text)
oledbcom.Parameters.Add(New OleDbParameter("@coyrmk", OleDbType.VarChar).Value = rmk.Text)
oledbcom.Parameters.Add(New OleDbParameter("@rmkdt", OleDbType.Date).Value = rmkdt.Text)
oledbcom.ExecuteNonQuery()
Page.ClientScript.RegisterStartupScript(Me.GetType, "Forms", "<script> alert('Data Updated successfully ..........')</script>")
End Sub