Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 68186 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
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
What is a string variable?
Which method is used by command class to execute SQL statements that return single value?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is the DataTableCollection?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What are the namespaces used in ado.net for data access?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
Which parameter of ConnectionString is used to specify the name of the database?
List all the steps in order, to access a database through ado.net?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
How would you connect to a database by using .NET?
How to store data in memory?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
