This section describes a simple routine that sends a simple SQL statement to the database.
You can try this routine by placing a command button named Command2 on a form, and pasting the routine into its Click event. Run the program and click the button to connect, display a message in the database server messages window, and then disconnect.
Private Sub cmdUpdate_Click( _ ByVal eventSender As System.Object, _ ByVal eventArgs As System.EventArgs) _ Handles cmdUpdate.Click ' Declare variables Dim myConn As New ADODB.Connection Dim myCommand As New ADODB.Command Dim cAffected As Integer On Error GoTo HandleError ' Establish the connection myConn.Provider = "SAOLEDB" myConn.ConnectionString = _ "Data Source=SQL Anywhere 11 Demo" myConn.Open() 'Execute a command myCommand.CommandText = _ "UPDATE Customers SET GivenName='Liz' WHERE ID=102" myCommand.ActiveConnection = myConn myCommand.Execute(cAffected) MsgBox(CStr(cAffected) & " rows affected.", MsgBoxStyle.Information) myConn.Close() Exit Sub HandleError: MsgBox(ErrorToString(Err.Number)) Exit Sub End Sub
After establishing a connection, the example code creates a Command object, sets its CommandText property to an update statement, and sets its ActiveConnection property to the current connection. It then executes the update statement and displays the number of rows affected by the update in a window.
In this example, the update is sent to the database and committed as soon as it is executed.
For information about using transactions within ADO, see Using transactions.
You can also perform updates through a cursor.
For more information, see Updating data through a cursor.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|