Issuing a Command that Inserts a Row

Issue a command that inserts 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 Insert statement:

   For C#:

   AseCommand insertCmd = new AseCommand(
      "INSERT INTO publishers " +
      " ( pub_id, pub_name, city, state) " +
      " VALUES( @pub_id, @pub_name, @city, @state )", 
      conn);

   For Visual Basic .NET:

   Dim insertCmd As new AseCommand( _
      "INSERT INTO publishers " + _
      " ( pub_id, pub_name, city, state) " + _
      " VALUES (@pub_id, @pub_name, @city, @state )",  _
      conn )

4. Set the parameters for the AseCommand object:

   The following code defines parameters for the dept_id and dept_name columns, respectively.

   For C#:

   AseParameter parm = new AseParameter("@pub_id", AseDbType.Char, 4);
   insertCmd.Parameters.Add( parm );
   parm = new AseParameter("@pub_name", AseDbType.VarChar, 40);
   insertCmd.Parameters.Add( parm );
   parm = new AseParameter("@city", AseDbType.VarChar, 20);
   insertCmd.Parameters.Add( parm );
   parm = new AseParameter("@state", AseDbType.Char, 2);
   insertCmd.Parameters.Add( parm );

   For Visual Basic .NET:

   Dim parm As New AseParameter("@pub_id", AseDbType.Char, 4)
   insertCmd.Parameters.Add(parm)
   parm = New AseParameter("@pub_name", AseDbType.VarChar, 40)
   insertCmd.Parameters.Add(parm)
   parm = New AseParameter("@city", AseDbType.VarChar, 20)
   insertCmd.Parameters.Add(parm)
   parm = New AseParameter("@state", AseDbType.Char, 2)
   insertCmd.Parameters.Add(parm)

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

   For C#:

   int recordsAffected = 0;
   insertCmd.Parameters[0].Value = "9901";
   insertCmd.Parameters[1].Value = "New Publisher";
   insertCmd.Parameters[2].Value = "Concord";
   insertCmd.Parameters[3].Value = "MA";
   recordsAffected = insertCmd.ExecuteNonQuery();
   insertCmd.Parameters[0].Value = "9902";
   insertCmd.Parameters[1].Value = "My Publisher";
   insertCmd.Parameters[2].Value = "Dublin";
   insertCmd.Parameters[3].Value = "CA";
   recordsAffected = insertCmd.ExecuteNonQuery();

   For Visual Basic .NET:

   Dim recordsAffected As Integer
   insertCmd.Parameters(0).Value = "9901"
   insertCmd.Parameters(1).Value = "New Publisher"
   insertCmd.Parameters(2).Value = "Concord"
   insertCmd.Parameters(3).Value = "MA"
   recordsAffected = insertCmd.ExecuteNonQuery()
   insertCmd.Parameters(0).Value = "9902"
   insertCmd.Parameters(1).Value = "My Publisher"
   insertCmd.Parameters(2).Value = "Dublin"
   insertCmd.Parameters(3).Value = "CA"
   recordsAffected = insertCmd.ExecuteNonQuery()

   Note: You can use an Insert, Update, or Delete statement with the ExecuteNonQuery method.
6. 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

7. Close the AseDataReader and AseConnection objects:

   For C#:

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

   For Visual Basic .NET:

   dr.Close()
   conn.Close()