Updating dataset from datagrid

The Sql Data Adapter opens a connection only when required and closes it as soon as it has performed its task.

For example, the Sql Data Adapter performs the following tasks when filling a Data Set with data: In between the Fill and Update operations, data source connections are closed and you are free to read and write data with the Data Set as you need.

In Lesson 3, we discussed a fully connected mode of operation for interacting with a data source by using the Sql Command object.


This Lesson shows how to accomplish something in-between Sql Connection and Sql Data Reader interaction by using the Data Set and Sql Data Adapter objects.

A Data Set is an in-memory data store that can hold numerous tables.

Data Sets only hold data and do not interact with a data source.

It is the Sql Data Adapter that manages connections with the data source and gives us disconnected behavior.

These are the mechanics of working with disconnected data.Because the applications holds on to connections only when necessary, the application becomes more scalable.



  1. Pingback:

  2. eric   •  

    Simpson 9780882680507 0882680501 Self Liberation Through Seeing Everything with Naked Awareness, John Myrdhin Reynolds, John Reynolds 9781846282898 1846282896 H-infinity Control for Nonlinear Descriptor Systems, He-Sheng Wang, Chee-Fai Yung, Fan-Ren Chang 9781852843564 185284356X Outdoor Photography - Landscape, Action and Wildlife Photography for the Outdoor Enthusiast, Jon Sparks 9781418436933 1418436933 The Practical Marketing Handbook of Definitions - Second Edition, Michael C.

  3. eric   •  

    "The event started at about pm, members from almost every single Greek life organization on campus attended.

  4. eric   •  

    Every time you visit the site you never quite know what you’re going to see, but it’s always new, fresh and exciting. You see, in order to comply with obscenity rules from various jurisdictions, performers are no longer allowed to use any object as a dildo unless it’s specifically sold as a sex device designated for the specific purpose of masturbating.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>