datareader and dataset
-
I wanna ask a question bout datareader and dataset. If i execute 1 Sp with 2 queries in it as select * from employee and select * from Company bothe this SP's result i execute in dataset as well as datareader at a time. so what o/p it will show in each -datareader and dataset ?
JAX
-
I wanna ask a question bout datareader and dataset. If i execute 1 Sp with 2 queries in it as select * from employee and select * from Company bothe this SP's result i execute in dataset as well as datareader at a time. so what o/p it will show in each -datareader and dataset ?
JAX
Jax_qqq wrote:
so what o/p it will show in each -datareader and dataset ?
It will show the same output unless the database changed between runs. DataReader provides a forward only view of the data. The DataSet is a container that is used by a Data Adapter so that the result set can be accessed in a random access within the application.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog