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

Define table relations?

973


What is ado circle?

1135


What is the role of clr?

947


Compare Data Reader & Dataset in ado.net?

997


What is oledb connection?

983


Which is faster entity framework or ado.net?

928


How to store data in memory?

946


What is the difference between data grid and data repeater?

1073


What is a column variable?

936


What is the difference between a datareader and a dataset?

1029


Is it possible to load multiple tables in a Dataset?

1072


What is the difference between ADO and ADO.Net?

1077


What is a dynaset in access?

1061


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

866


Explain the difference in record set and dataset?

933