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 is difference between executequery and executeupdate?

1097


What is bubbled event can you please explain?

1107


How can I retrieve two tables of data at a time by using data reader?

1092


What is the difference between DataReader and DataSet in ADO.NET?

1251


What is an example of ordinal data?

1239


What is defaultview in datatable?

1074


What are the types of databinding?

1033


What is the difference between ADO and ADO.Net?

1121


What are the different methods available under the sqlcommand class to access the data?

1100


How does entity framework work?

970


What is Dataset Object?

1061


Does executenonquery return a value?

1005


What is data adapter in ado.net with example?

1107


What is the difference in an abstract class and an interface?

1067


Does entity framework use ado.net?

1029