25+ Ado.Net Interview Questions and Answers - 2

Question: 6

What is Data Rows?

The actual data within the table is accessed using the Data Row object.

Question: 7

What is Execute Non Query?

This method is commonly used for UPDATE, INSERT or DELETE statements, where the only returned value is the number of records affected.

Question: 8

Define data set class?

The data set class has been designed as an offline container of data. It has no notion of data base connections. It consists of a set of data tables, each of which will have a set of data columns and data rows.

Question: 9

What are the steps needed to work with the data reader?

1. Creation of connection
2. Creation of command object
3. Creation of Data Reader object

Question: 10

Define connection string?

A connection string specifies the data source and necessary information required to access the data source, such as password and ID. It also includes values for connection time out and packet size.