RE: What is use of DataAdapater? and is it possible to...
Mr shankar is quite right to say this. Bute here I want to elaborate the answer .Dataset is used in disconnected mode only is major feature of ADO.NET.Dataadpater is a bridge to collect the data from server and keep itslef and afterward move data to dataset. Fill() method is used to transfer data from dataadapter to dataset And Datatable is taken birth from dataset only. if dataset is not then datattable is not in movie.Datareader is used in connection mode and working for retreieve data ready only mode and itcan't be move back becuase its main feature is forward only.Good Luck!
RE: What is use of DataAdapater? and is it possible to...
DataAdapters purpose is to perform database queries and create dataTables containing the query results. Its also capable of writing changes made to the datataTables back to the database.
DataAdapter acts as a go-between providing a layer of abstraction between DataSet and the Physical Data sorce.
RE: What is use of DataAdapater? and is it possible to...
Data Adapter is link between Data base and Dataset without data Adapter we can not bind data in to dataset ... so we use data Adapter which interact with database and fill dataset Easily ...we can also use data Adapter to insert Delete and Update record in database by using only one Select query...
RE: What is use of DataAdapater? and is it possible to...
Yes In asp.net 2005 it is possible to populate a datatable from a datareader. You have to use Load method of datatable and pass the datareader as argument.
