code is well-optimized and must be used. Please also let me know why
it is better.

=======[ CODE 1 ]===========================================
       public Int32 InsertNewRecord(string myQuery)
       {
           objModCon.OpenConnection();
           SqlCommand cmdInsert = new SqlCommand(myQuery,
objModCon.myCN);
           try
           {
               Int32 RecordsAffected = cmdInsert.ExecuteNonQuery();
               return RecordsAffected;
           }
           catch (Exception ex)
           {
               MessageBox.Show("Routine: ModReUsable-
InsertNewRecord(" + myQuery + ") " + ex.ToString(), "Error:",
MessageBoxButtons.OK, MessageBoxIcon.Error);
               return 0;
           }
           finally
           {
               cmdInsert.Dispose();
               objModCon.CloseConnection();
           }
       }
========[ CODE 2 ]==================================================
public static OleDbDataAdapter CreateCustomerAdapter(
   OleDbConnection connection)
{
   OleDbDataAdapter adapter = new OleDbDataAdapter();
   OleDbCommand command;

   // Create the SelectCommand.
   command = new OleDbCommand("SELECT CustomerID FROM Customers " +
       "WHERE Country = ? AND City = ?", connection);

   command.Parameters.Add("Country", OleDbType.VarChar, 15);
   command.Parameters.Add("City", OleDbType.VarChar, 15);

   adapter.SelectCommand = command;

   // Create the InsertCommand.
   command = new OleDbCommand(
       "INSERT INTO Customers (CustomerID, CompanyName) " +
       "VALUES (?, ?)", connection);

   command.Parameters.Add(
       "CustomerID", OleDbType.Char, 5, "CustomerID");
   command.Parameters.Add(
       "CompanyName", OleDbType.VarChar, 40, "CompanyName");

   adapter.InsertCommand = command;
   return adapter;
}
=====================================================================================================