Using the Data Adapters you can fill Data Set and use this dataset for retrieving and storing information.
It is independent of Data Source and because it exists in the local system, it makes application fast and reliable.Such queries separate the body of the query from the data values managed by that query, and enforce data type expectations on those values. The process begins by replacing hardcoded values in the query text with placeholders, each starting with an "@" sign: Right away, things look simpler. A primary function of any database application is connecting to a data source and retrieving the data that it contains. A key function of any database application is the ability to update the data that is stored in the database. NET, updating data involves using the Data Adapter and Data Set, and Command objects; and it may also involve using transactions. NET serve as a bridge between an application and a data source, allowing you to execute commands as well as to retrieve data by using a Data Reader or a Data Adapter.