This can be helpful in multi-tier application where every user can change or modifications in rows or table, to determine how the rows are modified (insert, delete or modified). NET method, in the code above, takes two parameters: a Dataset and a table name.
Your data source is updated every quarter with sales information for the most recent quarter.You can add the most recent sales information to your dataset by republishing your dataset. Changes made in the dataset will not affect the database and changes made in the database will not be reflected in our dataset.The main advantage of working with disconnected database is that there is no need of live connection to the database.Once the result of query is fetched from database into the are also helpful when building multi-tiered applications.
If the application uses business objects running on a middle-tier server to access database, business object needs to pass disconnected data structures to client application.
In Lesson 3, we discussed a fully connected mode of operation for interacting with a data source by using the Sql Command object.
In Lesson 4, we learned about how to read data quickly an let go of the connection with the Sql Data Reader.
The Data Set is created for data access independent of any data source.
It can be used with multiple and differing data sources, with XML data, or used to manage data local to the application.
When update image data, if the encode mode of the source data used is DCT, the result will has deckle edge.