<div>
<div class="content wysiwyg-content">
I fill a datatable from information from a database via a dataadapter. &nbsp;I have no issues in updating my database from changes in the datatable or updating the datatable from changes in the main database via my dataadapter.<br />
<br />
My problem is when I have a deleted row in the main database. &nbsp;I then call a dataadapter.fill and the rows are updated but the deleted row still exists in the datatable.<br />
<br />
Is there a quick way to do a .fill and have it delete the rows in the datatable that were deleted in the main database or at least mark them as deleted?
</div>
</div>


I fill a datatable from information from a database via a dataadapter.  I have no issues in updating my database from changes in the datatable or updating the datatable from changes in the main database via my dataadapter.

My problem is when I have a deleted row in the main database.  I then call a dataadapter.fill and the rows are updated but the deleted row still exists in the datatable.

Is there a quick way to do a .fill and have it delete the rows in the datatable that were deleted in the main database or at least mark them as deleted?

update datatable when rows are deleted in the database

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.