What Is The Difference Between Datareader And Dataadapter?
1. Data Reader is read only forward only and much faster than DataAdapter. 2. If you use DataReader you have to open and close connection explicitly where as if you use DataAdapter the connection is automatically opened and closed. 3. DataReader is connection oriented where as Data Adapter is disconnected
