Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Difference between datareader and dataset?

Answer Posted / chitaranjan mallick

- Data Reader apply only Select Statement, It can featch data from multiple Table Through Multiple Select Statement separated by Semicolon(;) Likes For Ex:
SqlCommand cmd=new SqlCommand("Select * from Emp";" Select * From Dept",Con);
DataReader dr=cmd.ExecuteReader();
dr.NextResults();
Here NextResults() Navigate from One Tables to Anather Tables
- It is Readonly, It can featch single Record At a Time..

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What DataReader class do in ADO.NET ?

1042


What is the use of SqlCommand object?

1180


What does datareader object do?

954


What is aggregate root?

1016


How to check if a datareader is closed or opened? IsClosed()

976


What is variable view?

834


How to bind the controls(best practice) comboboxes to the data in the dataset?

1012


What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

935


How does entity framework work?

859


What does executenonquery () method return?

884


What is ado.net code?

896


What is bubbled event?

923


What are the several execute methods of ado.net?

878


Explain how to call the sql commands asynchronously in ado.net version 2.0?

895


What is the DataTableCollection?

1012