Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are the usages of the command object in ado.net?

963


What is connected architecture in ado.net?

972


What are the classes in System.Data.Common Namespace?

1085


Which database is the ado.net sql connection object designed for?

995


How to perform sorting on a table in ADO.NET?

968


What are the steps to connect to a database?

974


How to bind the controls(best practice) comboboxes to the data in the dataset?

1001


What is the meaning of executenonquery?

961


What is dataset object? Explain the various objects in dataset.

979


What is defaultview in datatable?

980


What does executenonquery () method return?

877


What is difference between dataset and datatable?

1082


What are the advantages and disadvantages of using datalist?

982


What is dbcontext and dbset in entity framework?

863


Why do we serialize data?

882