Ado.Net Interview Questions and Answers for Fresher - 1
Question: 1
Write about the ADO.NET Disconnected model?
- The ADO.NET disconnected model is based on using a Data Set object as an in memory cache.
- A Data Adapter serves as the intermediary between the data Set and the Data Source that loads the cache with data.
- After the completion of the work the Data Adapter returns the connection object to the pool, thus disconnecting the data from the data Source.
Question: 2
Define complex data binding?
It is only available on controls that include properties to specify a data source and data members on the data source.
The controls are
List Box,
Checked List Box,
Combo Box and
Data Grid View
Question: 3
What is called Virtual mode?
In order to handle excessive memory requirements, a Data Grid View can be run in virtual mode by setting its Virtual Mode property to true. In this mode the application takes responsibility for maintaining an underlying data cache to handle the population, editing and deletion of Data Grid View cells based on actions of the user.
Question: 4
What is the purpose of the Execute Scalar method?
This method executes the query and returns the value of the first column in the first row of the result set as a scalar value the following code illustrates the usage.
7000+ TNPSC Group 1, 2, 4, VAO Indian Economy Study Materials Pdf More
7000+ Gate Computer Science Engineering Previous Year Questions More
7000+ Fill in the Blanks with Suitable Homonyms More
7000+ Fill in the Blanks with Suitable Homophones More
Power Semiconductor Device and Integrated Circuits MCQ Questions Pdf More
Top 1000 C++ Quiz More
100+ Operating System Fill in the Blanks with Answers More
7000+ Ancient Indian History Objective Questions and Answers Pdf More
100+ UPSC, SSC, Banking Earthquakes Questions and Answers More
Chemistry Gk Questions and Answers 2020-2021 More