DataSet Rows Being Deleted, But After The Update , The Sql Database Is Not Updated. The Delete Rows Still In The Database.

 Stepping thru the code with the debugger shows the dataset rows being deleted.

 

After executing the code, and getting to the page presentation. Then I stop the debug and start the

page creation process again ( Page_Load ).    The database still has the original deleted dataset rows.

Adding rows works, then updating works fine, but deleting rows, does not seem to work.

 

The dataset is configured to send the DataSet updates to the database. Use the standard wizard to create the dataSet.

 

 


cDependChildTA.Fill(cDependChildDs._ClientDependentChild, UserId);

        rowCountDb = cDependChildDs._ClientDependentChild.Count;
      

        for (row = 0; row < rowCountDb; row++)
        {

           dr_dependentChild = cDependChildDs._ClientDependentChild.Rows[0];
           dr_dependentChild.Delete();
          
          
//cDependChildDs._ClientDependentChild.Rows.RemoveAt(0);
          
//cDependChildDs._ClientDependentChild.Rows.Remove(0);
            /* update the Client Process Table Adapter*/
          // cDependChildTA.Update(cDependChildDs._ClientDependentChild);
      //     cDependChildTA.Update(cDependChildDs._ClientDependentChild);


        }

        /* zero rows in the DataSet at this point */

        /* update the Child  Table Adapter */
       cDependChildTA.Update(cDependChildDs._ClientDependentChild);