a2zinterviews

66.	What are managed providers?
	A managed provider is analogous to ODBC driver or OLEDB provider. It performs operation of communicating with the database. ADO.NET currently provides two distinct managed providers. The SQL Server managed provider is used with SQL server and is a very efficient way of communicating with SQL Server. OLEDB managed provider is used to communicate with any OLEDB compliant database like Access or Oracle.
	Discuss Your Name Your Email-ID Your Answer

67.	How do I delete a row from a DataTable?
	ds.Tables("data_table_name").Rows(i).Delete dscmd.update(ds,"data_table_name")
	Discuss Your Name Your Email-ID Your Answer

68.	What inside in DataSet?
	Inside DataSet much like in Database, there are tables, columns, constraints, relationships, views and so forth.
	Discuss Your Name Your Email-ID Your Answer

69.	What is connection pooling?
	Connection pooling refers to the task of grouping database connection in cache to make them reusable because opening new connections every time to a database is a time consuming process. Therefore, connection pooling enables you to reuse already existing and active database connections, whenever required, and increasing the performance of your application.
	Discuss Your Name Your Email-ID Your Answer

70.	What is the use of Ado.net connection?
	Establishes a connection to a specific data source.
	Discuss Your Name Your Email-ID Your Answer