Ado.Net Interview Questions and Answers Part 4

1. ) What is DataTable collection in Ado.Net ?                                                                  
The Data Tables collection contains all the Data Table objects in a DataSet.

2. ) What is the use of Data view in Ado.Net ?                                                                    

Data View is mainly used to sort and filter the Table data.

3. )Can we return a result set using ExecuteNonQuery() method  in Ado.Net ?    

No, It only show "Row effected " when any user perform insert ,delete and update operation on a table.We use ExecuteReader() method for return the result set from Database.

4. ) Explain the different methods and properties of Data Reader in Ado.Net ?  
  • Read()
  • GetString()
  • GetInt32()
5. ) What happens when we use Dataset.ReadXml command ?                                   
It Reads XML Schema and data into the Data Set.

6. ) How to check whether a Data Reader is opened or closed  ?                                   

7. ) How to retrieve records counts in DataSet   ?                                                               
Foreach(DataTable this_table in myDataset.Tables)

8. ) How to print the values of each column in table ?                                                    
Foreach(DataRow this_row in thisTable.Rows)

9. ) What Method is used to fill the Dataset in  ?                                              

10. ) What Method is used to get XML data  and schema from dataset?               

  • GetXML()
  • GetSchema()
11. ) What are the Namespace used for connectivity in               
  • System.Data.SqlClient
  • System.Data.OracleClient
  • System.Data.oleDB
  • System.Data.ODBC;


Post a Comment

Powered by Blogger.