Join Our Email Alerts-Subscribe
Important Note:Login & Check Your Email Inbox and Activate Confirmation Link

Enter Your Email :

Copyright Disclaimer:
Section 107 of the Copyright Act Fair Use Contents .
We are forwarding content link(s) from our website to content website & We are not serving any contents.
Main the Content PDF link(s) is/are obtained from GoogleSearch
for the purpose of Education & Teaching Intention. Not for commercial purpose. is not liable/responsible for any copyright issues.

ADO.Net Materials-Free Download

What are DataReaders?

Answer: DataReader object is ‘stream-based’, ‘read-only’ and ‘forward-only’, which provides a connection based data access from a database. This contains a ‘Read ()’ method that retrieves the data stored in a data source.

A Connection Object has only one DataReader at a time. ‘Read ()’ method retrieves only one row at a time. That is data need not be completely read into the application before it is processed. Give few examples of DataReader that is used in different DataProviders.

Answer: Each DataProvider has a DataReader class.

Few are given in the table below:

DataProvider DataReader

OleDb OleDbDataReade

Sql SqlDataReader


Q #12) What is Databinding?

Answer: Databinding is the process of binding the data with graphical elements (controls in a window form). After binding the data in a window form, you can navigate through the records with the help of the Binding Navigator Control.

One of the advantages of data binding is, the user does not need to write the codes explicitly, for establishing the connections and creating a data set, this feature will write the necessary ADO.NET code for the user.

Q #12) What are the types of Databinding?

Answer: This classification is based on the number of bound values that can be displayed through a control of the window form.

Two types of Databinding

• Simple Data Binding

• Complex Data Binding

Simple Data Binding: It is the process of binding a control to a single data element.

For Example: Binding a textbox or label with a single value.

Complex Data Binding: It is the process of binding a component to display one data element or multiple data elements.

) What are DataProviders?

Answer: DataProviders are used for connecting to a database, retrieving data storing data, updating the data etc.

Example of DataProviders: SQL, OleDb, ODBC

Four Components of DataProviders are:

• Connection

• Commands

• DataReader

• DataAdapter

Q #14) Describe ADO.NET object model in detail.

Answer: is based on an Object Model. The data from Datasource is retrieved with Data Provider. The Data providers include components such as connection, DataAdapter, DataReader, and Command. It provides data to the application, updates the database with the changes made in the application.

An Application can access the data either through a data set or through a DataReader object. also enables to create an XML representation of a dataset. In an XML representation of a dataset, data is written in XML format.

Q #15) What are the key events of SqlConnection Class?

Answer: The two key events of SqlConnection are:

• StateChange event

• InfoMessage event

StateChange event: This event occurred when the state of the Connection changes.

The event handler receives an argument (Datatype: StateChangeEventArgs) which contains the data related to that particular event.

InfoMessage event: This event occurred when an info message or Warning is returned from a data source. The event handler receives an argument (Datatype: SqlInfoMessageEventArgs) which contains the data related to that particular event.

Q #16) What you mean by Filtering of data?

Answer: Filtering of data is done when you need to display only selective records.

Given below are the two methods for filtering data:

• Creating parameterized queries.

• Filtering data using control of a window form.

What do you mean by performing Asynchronous Operation using Command Object?

Answer: Sometimes execution of the commands in the database may take a large amount of time to complete as they are linked to each other.

A solution for such a situation has asynchronously executed the commands against the database without waiting for the command execution to finish, which can be handy in the situation in which, when you try to execute the long-running base commands.

Advantages of Asynchronous Execution:

• Improves performance.

• Improve responsiveness of the client application.

Q #19) What do you mean by ‘Batch Updates’?

Answer: A batch update can be defined as a batch of updates grouped together. To improve the performance of the data updates in a database is to update and send the changes in batches to the database, rather than one by one.

Advantages of Batch Updates:

• Less network traffic is involved as data is sent in batches.

• A database might be able to execute some of the updates in parallel.

Q #20) What is the difference between Typed and Untyped Dataset?

Answer: The differences are explained below:

Typed Dataset: A typed dataset is derived from the Dataset class and has an associated XML schema, which is created at the time of creation of the dataset.

The XML schema contains information about the dataset structure such as tables, columns, and rows. Data is transferred from a database into a dataset and from the dataset to another component in the XML format.

Untyped Dataset: Untyped dataset doesn’t have an XML schema associated with it. Untyped Dataset, the tables, and columns are represented as a collection.

Q #21) What are the rules to implement connection pooling?

Answer: To establish a connection pooling, following rules must be followed:

• The connection string must be the same for every User.

• The UserID must be the same for every user.

Q #22) What is a Datatable?

Answer: Datatable is a collection of rows, columns, and constraints. A Datatable is able to perform disconnected data access.

Q #23) What is DataView?

Answer: A DataView control creates a customized view of data stored in Datatable. The changes in DataView will affect the Datatable. By default, every table has a data view attached to it.

You can then add the DataView control and bind it to a Windows form. It allows the user to filter, navigate and sort the data in it.

Q #24) What are the major challenges in accessing data from a database?

Answer: The challenges include:

• More than one user might need to access the data simultaneously from one database.

• More than one user might need to access the data anytime, anywhere.

The solution to this problem is attained by implementing a ‘Database locking’ during the time of transaction execution.

Q #25) What is meant by ‘Transaction’ in a database and what are the ‘Properties of Transaction’?

Answer: Transaction can be defined as a series of operation. If the transaction is successful, all the data modifications performed in the database will be committed and saved.

Properties of Transaction

• Atomicity

• Consistency

• Isolation

• Durability

Source: Contents are provided by Technicalsymposium Google Group Members. Disclaimer: All the above contents are provided by Google Group members. Further, this content is not intended to be used for commercial purpose. is not liable/responsible for any copyright issues.

Download Technical Interview Materials PDF-Free Download

Technical Interview Questions and Answers Notes PDF
Placement Materials PDF-Free Download Study Materials PDF-Free Download Live Support-Chat with Our Experts

Official Contact: +91-9245556793 (Whatsapp Message / SMS / Voice Call)

Our Expert team is ready to answer all your questions immediately-Feel free to speak in Tamil/English.

(Example:Events info/Lecture Notes/Off-Campus & All Jobs/Projects & All education information)

Working hrs (IST): (Morning: 10:00AM-3:00 PM) and (Evening:5:00 PM to 10:00 PM)

All Latest Question & Answer Page (FAQ)-Click here