Issuing a Command that Updates a Row

Issue a command that updates a row.

1. Declare and initialize an AseConnection object:

   For C#:

   AseConnection conn = new AseConnection(
      c_connStr );

   For Visual Basic .NET:

   Dim conn As New AseConnection(c_connStr)

2. Open the connection:

   For C#:

   conn.Open();

   For Visual Basic .NET:

   conn.Open()

3. Add an AseCommand object to define and execute an update statement:

   For C#:

   AseCommand updateCmd = new AseCommand(
      "UPDATE publishers " +
      "SET pub_name = 'My Publisher' " +
      "WHERE pub_id='9901'",
      conn );

   For Visual Basic .NET:

   Dim updateCmd As New AseCommand( _
      "UPDATE publishers " + _
      "SET pub_name = 'My Publisher' " + _
      "WHERE pub_id='9901'", _
      conn )

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

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

   For C#:

   int recordsAffected = updateCmd.ExecuteNonQuery();

   For Visual Basic .NET:

   Dim recordsAffected As Integer =
      updateCmd.ExecuteNonQuery()

5. Display the results and bind them to the grid on the window:

   For C#:

   AseCommand selectCmd = new AseCommand(
      "SELECT * FROM publishers", conn );
   AseDataReader dr = selectCmd.ExecuteReader();
   dataGrid.DataSource = dr;

   For Visual Basic .NET:

   Dim selectCmd As New AseCommand(_
      "SELECT * FROM publishers", conn)
   Dim dr As AseDataReader = selectCmd.ExecuteReader()
   DataGrid.DataSource = dr

6. Close the AseDataReader and AseConnection objects:

   For C#:

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

   For Visual Basic .NET:

   dr.Close()
   conn.Close()