What we do with the object of ado.net dataset after using
it?Can we dispose it or can we set it nothing?Is it must or
not?

Answer Posted / chetan nandwana

This is not must as .Net have its own garbage collector.
but if you feel you have no need of this dataset anymore or
you wanna create it again next time them Better use Dispose
method of this as it Implements IDisposable interface

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

585


What are the ado.net objects?

510


What is the purpose of using adodb?

509


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

583


Which provider is used to connect ms access, oracle, etc…?

530






What are the different ado.net namespaces?

624


What is ado control?

526


Explian About DataAdapters

588


What is difference between executenonquery and executequery?

472


Explain ado.net features?

538


What is oledb driver?

499


Give few examples of datareader that is used in different dataproviders.

541


If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

615


Why is stored procedure used in ado.net?

549


Which is faster ado.net or linq?

515