All You Need to Know about ADO.NET: Part 2/2
page 17 of 27
by Devarticles.com
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 90390/ 175

Handling Updates
Unless the data used by the application is read only, we typically perform some modifications to the data or add to the data before sending it back to the data source or to another process or application. In windows Forms, the data binding architecture takes care of sending changes in the data bound controls to the DataSet. But, when the controls are not data bound, we have to send the changes in the records to the DataSet manually. Each record in a DataSet is represented by a DataRow object. The DataRows collection can be used for updating DataSet. If we update, add or delete existing rows, we will be updating the DataSet.

You can manipulate the collection directly to delete records. However, if you want to send changes to the database or to another process, the DataSet has to maintain change information for deleted rows. Data tables therefore provide special methods for deleting records so this information can be retained. If the DataSet includes constraints, you can temporarily turn constraints off before making any updates, and then turn them back on afterwards.

View Entire Article

User Comments

Title: disconnected architecture   
Name: kinjalpadashala
Date: 2012-02-14 3:19:39 AM
Comment:
p/z help me how to select the data in grid and bind of textbox.
Title: thank you   
Name: kartik
Date: 2011-03-24 1:04:35 AM
Comment:
is it posibile to insert the record enter at the 1st row of database every time?
Title: Ado.net Connected Architecture   
Name: Vidhya Patel, India(mota)
Date: 2011-03-08 11:27:53 PM
Comment:
I use this content in my Presentation....it's very useful for me....... so thanks a lot
Title: ado.net   
Name: Manimegalai
Date: 2010-09-15 3:31:43 AM
Comment:
That is great collection
thank u;;;;;;;;;;;;;;
Title: Thanks   
Name: Amin Anwar
Date: 2009-05-14 5:19:09 AM
Comment:
That isgr8 collection;;;
thanks
Title: Ado.net   
Name: Saurabh Shrivastava
Date: 2007-02-20 11:46:46 AM
Comment:
Brilliant Work,It could be more useful by giving some code in it.
Title: Thank you   
Name: Jayalakshmi baskaran
Date: 2006-05-30 5:39:23 AM
Comment:
I want to create the sqldataAdapter and the Dataset in Code
Can you please help it out
Title: Ado.Net   
Name: Rohan Ragoo
Date: 2006-01-09 12:37:59 PM
Comment:
Excellent Overview. All topics are dicussed in an effective timeline.
Title: XML   
Name: Rajesh Medackel,India
Date: 2005-10-01 5:26:30 AM
Comment:
Good write up .... Thanx
Title: ADO.Net   
Name: k
Date: 2005-05-03 11:31:30 AM
Comment:
to the authors thanks a lot for the unselfish information

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-04-25 7:05:41 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search