Dataadapter not updating database
To improve performance, you can use the WHERE clause to greatly reduce the number of rows returned to the client.You can also reduce the amount of data returned to the client by only explicitly listing required columns in the SELECT statement.
NET Data Set is a memory-resident representation of data that provides a consistent relational programming model independent of the data source.The Data Set represents a complete set of data that includes tables, constraints, and relationships among the tables.Because the Data Set is independent of the data source, a Data Set can include data local to the application, and data from multiple data sources.Interaction with existing data sources is controlled through the Data Adapter.Fill takes as its arguments a Data Set to be populated, and a Data Table object, or the name of the Data Table to be filled with the rows returned from the Select Command.Using the Data Adapter to retrieve all of a table takes time, especially if there are many rows in the table.
This is because accessing the database, locating and processing the data, and then transferring the data to the client is time-consuming.
Pulling all of the table to the client also locks all of the rows on the server.
The Select Command property of the Data Adapter is a Command object that retrieves data from the data source.
The Insert Command, Update Command, and Delete Command properties of the Data Adapter are Command objects that manage updates to the data in the data source according to modifications made to the data in the Data Set.
These properties are covered in more detail in Updating Data Sources with Data Adapters.
The Fill method of the Data Adapter is used to populate a Data Set with the results of the Select Command of the Data Adapter.