Posted by Ganesan - +919042710472
1. What is ADO.NET?
ADO.NET stands for Microsoft ActiveX Data Object. Ado.net is a database technology which we can think like a set of classes that can be used to interact with the data sources like databases and XML files.
Asp.net application, windows application, console application are the few types of .net applications that use ADO.NET to connect with the databases to execute commands and retrieve data.
2. What are the key features of ADO.NET?
· Disconnected data architecture
· Data cached in data set
· Scalability
· Data transfer in HTML Format
· Strongly typed language.
3. Why is it important to close an ADO.NET application?
Connections need to be closed properly because it affects the scalability and reliability of the applications.
Open connections are always vulnerable to attack, so to be short , ‘ open connections as late as possible and close it as early as possible’. We can close the connection by final block or using the USING statement.
4. What are the different methods by which we can populate a Data set?
Using Data Adapter objects and the ‘fill’ method.
Pro-grammatically creating Data table, Data row, and Data Column objects.
Data from XML Documents.
Merging with another Data set.
5. What is Data Adapt or?
Data Adapter helps in linking the database and connection object. Data Adapter provides the communication between Data Set and Data Sources.
Data moves ‘in and out’ of the Data set through Data Adapter.
Properties of Data Adapter that allow the user to control the database are:
· Select Command
· Update Command
· Insert Command
· Delete Command
6. What is Data binding?
Data binding 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.
7. What are the types of Data binding?
This classification is based on the number of bound values that can be displayed through a control of the window form.
Two types of Data Binding:
Simple Data Binding: It is the process of binding a control to a single data element.
For example: Binding a text box 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.
For example: Grid-view or List-box control binding one data element or more than one records in a table.
8. What are the rules to implement connection pooling?
To establish a connection pooling, the following rules must be followed:
· The connection string must be the same for every user.
· The User ID must be the same for Every user.
9. What is a Data table?
Data table is a collection of rows, columns, and constraints. A data table is able to perform disconnected data access.
10. What is Data View?
A Data view control creates a customized view of data stored in data table. The changes in Data view will affect the Data table. By default, every table has a data view attached to it.
You can then add the Data view control and bind it to a windows form. It allows the user to filter, navigate and sort the data in it.
Comments
Post a Comment