ADO.Net - Cannot get DataSet to Update into Database

OK,

Needless to say i'm quite frustrated with ADO.net compared to ADO or even good old DAO from my VB 6 days.  I am trying in vain to get changes i've made to a DataRow to populate back to the database  No matter what I do it doesnt work or I get errors about not having a properly formatted Update command.  Perhaps I really just don't understand how ADO.Net is supposed to work.  I thought you have this disconnected dataset that you make changes to in-memory and then when you call someDataSet.AcceptChanges(); it would populate all your changes back to the database for you, perhaps optionally passing just the source table you want to repopulate.  However, that does not seem to be the case.  I've seen all kinds of conflicting answers on EE as well as on PSC and other websites about how to best do this and whether to just use ADO instead of ADO.Net.

So, my first question:  Is ADO.Net a REPLACEMENT for ADO, or  IN ADDITION TO ADO?  Are there speed advantages to using ADO.net vs. ADO when you don't really care about disconnected datasets so much?  ADO.Net is such a radically different way of thinking i'm almost ready to take a performance hit and revert to ADO style recordsets b/c it makes sense and "works" correctly the way I intend every time.

My second question, my code is shown below for opening the database and then doing updates on one row inside it.  Please let me know what i'm doing wrong so that it doesnt work.
/*
        * Open a connection to the database
        */
        private void openDatabase()
        {
            this.dbConnect = new OleDbConnection();
            this.dbConnect.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
                @"Data source= .\main.mdb";
            try
            {
                //attempt to open the database
                //for now just leave this connection open
                this.dbConnect.Open();
            }
            catch (Exception ex)
            {
                string errmsg = "Error Message: " + ex.Message;
            }

        }

private void btnUpdateCompany_Click(object sender, EventArgs e)
        {
            //update all of the relevant information after verifying that they have all the proper
            //fields filled out
          //removed all the verify code for EE as it just takes up space and works fine

            OleDbDataAdapter daOurAdapter;
            DataSet dsResults;

            //do a search
            this.mstrSQL = "SELECT * FROM Customers WHERE CustomerID = " + this.CustomerID;

            this.openDatabase();
            try
            {
                //create the adapter with the SQL string and the ADO style connection (dbConnect is initialized in this.openDatabase() from above)
                daOurAdapter = new OleDbDataAdapter(this.mstrSQL, this.dbConnect);

                //make our dataset object an actual dataset
                dsResults = new DataSet();

                //now fill our dataset object with data (if any)
                daOurAdapter.Fill(dsResults, "Customers");

                //we now have a DataSet object that contains any results that have been returned by our query
                //create a DataTable object representing the table returned
                DataTable dtCustomers = dsResults.Tables["Customers"];

                //check to see if any data is actually contained in the results
                if (dtCustomers.Rows.Count > 0)
                {
                    DataRow drCustomerResults = dtCustomers.Rows[0];
                    drCustomerResults.BeginEdit();
                    //update all the data from the form inputs now
                    drCustomerResults["CompanyName"] = txtCompanyName.Text;
                    drCustomerResults["SpecialNotes"] = txtSpecialNotes.Text;
                    drCustomerResults["Username"] = txtUsername.Text;
                    drCustomerResults["Password"] = txtPassword.Text;
                    drCustomerResults["EmailAddress"] = txtEmailAddress.Text;
                    drCustomerResults["FirstName"] = txtFirstName.Text;
                    drCustomerResults["LastName"] = txtLastName.Text;
                    drCustomerResults["PhoneNumber"] = txtPhoneNumber.Text;
                    drCustomerResults["FaxNumber"] = txtFaxNumber.Text;
                    drCustomerResults["Country"] = txtCountry.Text;
                    drCustomerResults["BillingAddress"] = txtAddress.Text;
                    drCustomerResults["BillCity"] = txtCity.Text;
                    drCustomerResults["BillState"] = cboState.Text;
                    drCustomerResults["BillZipCode"] = txtZipCode.Text;
                    drCustomerResults["CreditCardType"] = cboCreditCard.Text;
                    drCustomerResults["CreditCardNumber"] = txtCreditCardNumber.Text;
                    drCustomerResults["ShipAddress"] = txtShipAddress.Text;
                    drCustomerResults["ShipCity"] = txtShipCity.Text;
                    drCustomerResults["ShipState"] = cboShipState.Text;
                    drCustomerResults["PreferredShipping"] = cboPreferredShipping.SelectedIndex;
                    drCustomerResults["ShippingNumber"] = txtShippingNumber.Text;
                    drCustomerResults["ShipZip"] = txtShipZipCode.Text;
                    drCustomerResults["ShipCountry"] = txtShipCountry.Text;
                    if (txtShipAddress.Enabled == false)
                        drCustomerResults["ShippingSame"] = 1;
                    else                    
                        drCustomerResults["ShippingSame"] = 0;                                        
                    //push all changes to the database
                    drCustomerResults.EndEdit();
                   // drCustomerResults.AcceptChanges();
                    DataSet dsChanges = dsResults.GetChanges();
                    if (dsChanges != null)
                    {
                        if (!dsChanges.HasErrors)
                        {
                            dsResults.Merge(dsChanges);
                            //very important to put the table name
//ERROR OCCURS HERE..  
                            daOurAdapter.Update(dsResults, "Customers");

                            dsResults.AcceptChanges();
                        }
                    }
                    //daOurAdapter.Update(dsChanges, "Customers");
//I"D PREFER TO BE ABLE TO JUST MAKE THE CALL BELOW AND HAVE IT ALL UPDATE..WHY DOESNT THIS WORK?
                    //dsResults.AcceptChanges();
                }
            }
            catch (Exception ex)
            {
                string strMsg = "Error Message = " + ex.Message;
            }

            this.closeDatabase();
            this.Close();
        }

I stuck in some comments about my issue in the code itself.  I really really hope that there is something stupid i'm overlooking to get ADO.Net to update the database without having to create temp Datasets to merge changes into or doing .insertCommand string type stuff to form the update SQL into the Adapter.  That all seems rather silly to me and I don't see the point, especially if I don't particularly need reusability on this form, there is no real reason to waste all the time writing re-usable SQL commands!

Thanks in advance,
Nathan