All You Need To Know About ADO.NET: Part 1/2
page 7 of 9
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 37391/ 97

Allowing Updates via Bound Controls
A DataSet is an in memory copy of the data, updating is a two step process with the DataSet. The process of writing data to the table is distinctly separate from writing to the DataSet.

The first step is to update the DataSet with new information such as modifications, deletions etc. The DataSet does not automatically pass these changes to the underlying database. That has to be done explicitly. This is the second step in updating the database. Typically, this is achieved by calling the Update method of the DataAdapter. This method loops through the database checking every record for modification requirements such as Update, Insert or Delete. On finding modified records, the DataAdapter executes the appropriate update.

RowState Property
For finding out if a record has been modified or not, the RowState property of the DataSet is used. It has 4 values:

  1. UnChanged
  2. Modified
  3. Deleted
  4. Inserted

View Entire Article

User Comments

Title: PC Analyst   
Name: Eddie Mathews
Date: 2006-11-27 6:23:17 PM
I am new to Visual Studio after many years of employment in other industries. Now I want to come but I am having problem locating the Data Form Wizard. I know my installation is correct.

Thanks buddy
Title: Joe   
Name: Joseph David
Date: 2006-05-04 5:32:24 AM
Click any Customer from the first grid and you will notice the second grid displaying records only for the selected Customer

how this work

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2021  |  Page Processed at 2021-04-12 11:27:49 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search