/// <summary>
        /// Calling Wrapper Stored Procedure's Parameters
        /// </summary>
        public void Example10()
        {
            // Create the connection
            SqlConnection conn =
                new SqlConnection("Server=localhost;" +
                                  "Database=ADONET;" +
                                  "Integrated Security=true;");

            conn.Open();

            // Create the stored procedure wrapper
            spAddMember sp = new spAddMember(conn);

            // Add the member variables
            sp.FirstName = "Greg";
            sp.LastName  = "Maddux";
            sp.Address   = "123 Main Street";
            sp.City      = "Atlanta";
            sp.State     = "GA";
            sp.Zip       = "30307";
            sp.Phone     = "404-555-1212";
            sp.Fax       = "404-555-1213";

            // Execute the stored procedure
            sp.Command.ExecuteNonQuery();

            // If the query worked, then get the key
            Int32 key;

            if (sp.RETURN_VALUE == 0)
            {
                key = sp.Key;
            }
        }
        /// <summary>
        /// Using Stored Procedure Wrapper
        /// </summary>
        public void Example9()
        {
            // Create the connection
            SqlConnection conn =
                new SqlConnection("Server=localhost;" +
                                  "Database=ADONET;" +
                                  "Integrated Security=true;");

            conn.Open();

            // Create the stored procedure wrapper
            spAddMember sp = new spAddMember(conn);

            // Call the procedure
            sp.Execute("Maddux",
                       "Greg",
                       "123 Main Street",
                       "Atlanta",
                       "GA",
                       "30307",
                       "404-555-1212",
                       "404-555-1213");

            // If the query worked, then get the key
            Int32 key;

            if (sp.RETURN_VALUE == 0)
            {
                key = sp.Key;
            }
        }