Hi,

I know that the book says that somehow I can update an Access database from a textbox but I cannot seem to figure how to do it. Point me in the right direction, please!

Also, is there some way that I can call a control on an .aspx page from an .aspx.vb page? Can not seem to figure this out either. Some small code example would be very helpful for either problem.

Thanks,

Tom

Hi,

I hope this example will help you. This is how you update your database(serverdatabase) using data entered in to a text box calles Text1.


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

   Dim strConnection As String = "Data Source=(LOCAL);" _
                               & "Initial Catalog=serverdatabase;" _
                               & "user id=sa;password=sa"

   Dim myConnection As New SqlConnection(strConnection)

   myConnection.Open()

   Dim cmdupdate As New SqlCommand("UPDATE table1 SET flield1='" & TextBox1.Text & "'", myConnection)

   cmdupdate.ExecuteNonQuery()

End Sub


If you need more information, please post
nalla

Thanks for your reply.

I am using an Access database and I think I must use a paramatized list to update. I don't know how to bind this. When I run the code no update occurs.

Tom

Hi TomTab,

Check these.
(1) Did you pass the sql to the CommandText property with parameter acceptors?
(2) Did you pass the parameter properly to the parameter array?

Please post the code if you need more help?


nalaka hewage