TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jorge L Fernandez
NA
412
150.6k
The TableDataAdapter.Update() method does not applies the changes to the database
May 17 2007 5:52 AM
Hi developers: I have defined a Typed DataSet by adding a new item (.xsd) to my project. Then I added a TableAdapter with a simple Fill method that retuns a set of data from a simple SELECT query. The Wizard generates successfully the INSERT, UPDATE and DELETE methods but when the dataset is modified at runtime and the TableAdapter.Update() method is invoked nothing happens. I using a BindingSource and a BindingNavigator in order to get an "MS-Access Appearance" while surfing through the data. All bindigs are set correctly and I have check (by debuging) that the RowState Property of the modified rows is set to "DataRowState.Modified". Another thing, when calling the AcceptChanges() method the dataset replaces the new values for the olds values corresponding to the modified rows. WHY ??? Please any suggestion will be appreciated. Thanks in advanced. Jorge Luis.
Reply
Answers (
1
)
Article-Object Query Language for Distributed Cache
Excel file to Gridview to Database