Ok, what am I doing wring here. This compiles and runs, but the changes are not sent to SQL.
DSCustomer is a typed dataset. The DataSet Visualize shows the new row.

/*****************************************************
 * Get the customer dataset 
******************************************************/

string sSelectCommand = "select * from Customers where CustomerKey = 1";

SqlDataAdapter oDataAdapter = new SqlDataAdapter(sSelectCommand, oConnection);
DSCustomer oDataSet = new DSCustomer();
oDataAdapter.Fill(oDataSet, "DSCustomer");

/*****************************************************
 * Or Create an empty customer dataset
******************************************************/
//DSCustomer oDataSet = new DSCustomer();

// Add a blank row
oDataSet.Tables[0].Rows.Add();


// Get a reference to the table
DataTable oTable = oDataSet.Tables[0];

// Get the number of rows
int iRowCount = oTable.Rows.Count - 1; 

// Get a reference to the last row
DataRow oRow = oTable.Rows[iRowCount];

// Edit the column values
oRow["CustomerName"] = "Someone Else";
oRow["CreditLimit"] = 15;

// Save the changes
oDataSet.AcceptChanges();