Interview Questions → ADO.NET 2.0 → ADO.NET Questionnaire I

ADO.NET Questionnaire I

What is the difference between dataset and datareader?

Dataset

      1. Disconnected architecture

      2. No need to manually open and close the connection

      3. Data in dataset is inspected only when the whole dataset is filled.

      4. DataSet represents a complete set of data including related tables, constraints, and relationships among the tables.

      5. Dataset is useful when you want to serialize the results.

Datareader

      1. Connected architecture

      2. Connection is manually open and close

      3. Datareader is a good option when retriving the large amount of data

      4. The ADO.NET DataReader is used to retrieve read-only, forward-only data from a database

      5. Datareader stores only one result at a time so it increases application performance and reduces system overheads.

Can we sort data from a SQLDataSource when mode is set to DataReader?

No.A DataReader is a read only object. It is a quick way for reading through sequential data but you cannot go backwards through it.

Consider an example

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<your_connection_string>" 
	      DataSourceMode="DataReader"
        SelectCommand="SELECT * FROM [Subjects]">
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AllowSorting="true">
</asp:GridView>

Here grid view is bound using SqlDataSource control. When you run the program you can see the gridview with data in it. When you try to sort the records you will get following error.

The SqlDataSource 'SqlDataSource1' cannot sort. Set DataSourceMode to DataSet to enable sorting. If you are using a stored procedure that supports sorting, set the SortParameterName property to the name of the stored procedure's parameter that accepts a sort expression.

If you want to give sorting, paging and filtering like capabilities then change the DataSourceMode from DataReader to DataSet

How to merge 2 datatables?

if table1 and table2 are the instances of DataTable class then you can merge table2 in table1 using Merge method

table1.Merge(table2);

Posted By -

Karan Gupta

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**