Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

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?

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / 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

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

Answer / satyambabu

we use dispose

Is This Answer Correct ?    0 Yes 1 No

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

Answer / guest

we use dispose

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More ADO.NET Interview Questions

What we do with the object of ado.net dataset after using it?

0 Answers  

what is type dataset?

3 Answers  

What are the ado.net objects?

0 Answers  

What is Dataset Object?

0 Answers  

What are the different execute methods of Ado.Net?

0 Answers  

Explain the difference between an ado.net dataset and an ado recordset?

0 Answers  

can we create synonymn in ms access,sql server,my sql if so explain me with example

0 Answers  

How to connect and retrieve data from database using dataset

0 Answers  

what is bubbled event can u pls explain

3 Answers   Wipro,

Describe connection object in ado.net

0 Answers  

What are the three Ado objects?

6 Answers   Microsoft, StarSoft,

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,

For more ADO.NET Interview Questions Click Here
Categories