Solved

update datatable when rows are deleted in the database

Posted on 2015-01-08
2
25 Views
Last Modified: 2016-06-23
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?
0
Comment
Question by:hotshottools
2 Comments
 
LVL 34

Accepted Solution

by:
Mike Eghtebas earned 500 total points
ID: 40538977
try:

YourDataSet.Reset()
YourTableAdapter.Fill(YourDataSet.table)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Regular expression help 2 34
JSON Deserialize issue 6 26
SSIS On fail action 5 37
How to repeat the data 4 13
Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question