DataReader object
Explain DataReader object?
Expert
DataReader object helps in accessing the data from the database in a read-only, forward-only mode. Base class for all DataReader objects is the DbDataReader class. The DataReader object is returned as a result of calling the ExecuteReader() method of the Command object. The DataReader object allows faster retrieval of the data from the databases and develops the performance of .NET applications by giving the rapid data access speed. Though, it is less preferred as compared to theDataAdapter object since the DataReader object requires an Open connection till it completes reading all the rows of specified table.
An Open connection required to read the data from large tables consumes many resources of the system. When multiple client applications at the same time access a database by using DataReader object, performance of the data retrieval and other related processes gets significantly reduced. In this case, database might refuses the connections to other .NET applications until other clients frees the resources.
By which method we can add or remove rows from a DataTable object of DataSet?
When.NET was developed?
Illustrate the difference between the .dll extension and .exe extension files?
Describe in brief regarding the Visual basic.NET culture?
Explain what is meant by CTS, and how it is related to the CLS?
State the difference between a ContextMenuStrip control and a MenuStrip control?
Write the difference between for loop and the while in C#.
Briefly describe about the XML elements.
State the difference between Managed and Unmanaged Code?
Illustrate some of the points regarding UserControl in WPF?
18,76,764
1927709 Asked
3,689
Active Tutors
1418865
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!