To issue a statement that inserts a row

1. Declare and initialize an SAConnection object.

   SAConnection conn = new SAConnection( c_connStr ); conn.Open();

2. Open the connection.

   conn.Open();

3. Add an SACommand object to define and execute an INSERT statement.

   You can use an INSERT, UPDATE, or DELETE statement with the ExecuteNonQuery method.

   SACommand insertCmd = new SACommand( "INSERT INTO Departments( DepartmentID, DepartmentName ) VALUES( ?, ? )", conn );

   If you are calling a stored procedure, you must specify the parameters for the stored procedure.

   For more information, see Using stored procedures and SAParameter class.

4. Set the parameters for the SACommand object.

   The following code defines parameters for the DepartmentID and DepartmentName columns respectively.

   SAParameter parm = new SAParameter(); parm.SADbType = SADbType.Integer; insertCmd.Parameters.Add( parm ); parm = new SAParameter(); parm.SADbType = SADbType.Char; insertCmd.Parameters.Add( parm );

5. Insert the new values and call the ExecuteNonQuery method to apply the changes to the database.

   insertCmd.Parameters[0].Value = 600; insertCmd.Parameters[1].Value = "Eastern Sales"; int recordsAffected = insertCmd.ExecuteNonQuery(); insertCmd.Parameters[0].Value = 700; insertCmd.Parameters[1].Value = "Western Sales"; recordsAffected = insertCmd.ExecuteNonQuery();

6. Display the results and bind them to the grid on the screen.

   SACommand selectCmd = new SACommand( "SELECT * FROM Departments", conn ); SADataReader dr = selectCmd.ExecuteReader(); System.Windows.Forms.DataGrid dataGrid; dataGrid = new System.Windows.Forms.DataGrid(); dataGrid.Location = new Point(10, 10); dataGrid.Size = new Size(275, 200); dataGrid.CaptionText = "iAnywhere SACommand Example"; this.Controls.Add(dataGrid); dataGrid.DataSource = dr; dataGrid.Show();

7. Close the SADataReader and SAConnection objects.

   dr.Close(); conn.Close();

To issue a statement that updates a row

1. Declare and initialize an SAConnection object.

   SAConnection conn = new SAConnection( c_connStr );

2. Open the connection.

   conn.Open();

3. Add an SACommand object to define and execute an UPDATE statement.

   You can use an INSERT, UPDATE, or DELETE statement with the ExecuteNonQuery method.

   SACommand updateCmd = new SACommand( "UPDATE Departments SET DepartmentName = 'Engineering' WHERE DepartmentID=100", conn );

   If you are calling a stored procedure, you must specify the parameters for the stored procedure.

   For more information, see Using stored procedures and SAParameter class.

4. Call the ExecuteNonQuery method to apply the changes to the database.

   int recordsAffected = updateCmd.ExecuteNonQuery();

5. Display the results and bind them to the grid on the screen.

   SACommand selectCmd = new SACommand( "SELECT * FROM Departments", conn ); SADataReader dr = selectCmd.ExecuteReader(); dataGrid.DataSource = dr;

6. Close the SADataReader and SAConnection objects.

   dr.Close(); conn.Close();

To issue a statement that deletes a row

1. Declare and initialize an SAConnection object.

   SAConnection conn = new SAConnection( c_connStr );

2. Open the connection.

   conn.Open();

3. Create an SACommand object to define and execute a DELETE statement.

   You can use an INSERT, UPDATE, or DELETE statement with the ExecuteNonQuery method.

   SACommand deleteCmd = new SACommand( "DELETE FROM Departments WHERE ( DepartmentID > 500 )", conn );

   If you are calling a stored procedure, you must specify the parameters for the stored procedure.

   For more information, see Using stored procedures and SAParameter class.

4. Call the ExecuteNonQuery method to apply the changes to the database.

   int recordsAffected = deleteCmd.ExecuteNonQuery();

5. Close the SAConnection object.

   conn.Close();