How do I Update DataSet with update sql, then Udate the database in C sharp
<p>How do I Update DataSet with update sql, then Udate the database in C sharp. I have so code it does something but does not actually update the database. I feel I am really close to figuring this out, but I am missing something or I am not doing something right. my code is below if someone can see what it is I am not doing please let me know, I have been looking at this for the past 7 hours and can't figure it out.</p>

<pre><code>            {   DataSet oDS = new DataSet();
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=StaffAs.accdb;");
        conn.Open();

        // Create the DataTable "SAssign" in the Dataset and the OrdersDataAdapter
       // UPDATE StaffAssignment SET StaffID = 4 WHERE (StaffID = 2)
        OleDbDataAdapter oOrdersDataAdapter = new  OleDbDataAdapter(new OleDbCommand("SELECT *     FROM StaffAssignment", conn));
        OleDbCommandBuilder oOrdersCmdBuilder = new  OleDbCommandBuilder(oOrdersDataAdapter);
        oOrdersDataAdapter.FillSchema(oDS, SchemaType.Source);
oOrdersDataAdapter.UpdateCommand = new OleDbCommand(String.Format("UPDATE StaffAssignment SET StaffID = 4 WHERE (StaffID = 2)"));
        DataTable pTable = oDS.Tables["Table"];
        pTable.TableName = "UpdateStaffA";

        oOrdersDataAdapter.Fill(pTable);

        try
        {
            oOrdersDataAdapter.Update(pTable);

        }
        catch (OleDbException e)
        { //Allows for update without violating interigty constainst
            return;
        }
        conn.Close();
</code></pre>

<p>}</p>
