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 / om namo bagavathe vasudevaya n

when ever we create an object for a class or any sever
contol etc with in the application and if we forgot to
dispose that object.Then garbage collector runs a Demon
Process(Demon process:A theard that automatically runs when
ever process is called) that is used to collect all the
objects that are not used for so long time.
but when ever we create any DataBase objects or file objects
they are not belong to the application so the IIS sever
doesnot perfom garbage collection for those DataBase or file
objects.So we have to explicity close those database objects
so for that we have to use Dispose mothod for closeing
Database objects and file objects etc..

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 executenonquery ado.net?

712


What do you know about ado.net's methods?

790


What is difference between dataset and datatable?

756


What are the core objects of ADO.NET?

783


Which method is used to sort the data in ADO.Net?

1742


What is ole word?

725


What is microsoft ado?

695


What is execute scalar in ado.net?

693


How to check if a datareader is closed or opened? IsClosed()

774


How to generate a single aggregate?

734


What is ado.net connection?

670


What does executequery return?

700


What are the key features of ado.net?

861


If we are not returning any records from the database, which method is to be used?

995


How would you connect to database using .NET?

782