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?
Answers were Sorted based on User's Feedback
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 |
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 is typed and untyped dataset
Does executenonquery return a value?
What is ambient transaction?
how to add a selected row of a gridview to another gridview without reloading the page??
What providers do you use to connect to oracle database ?
What is dataadapter in ado.net?
Features and disadvantages of dataset?
2 Answers CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,
Explain the difference between ado and ado.net?
What is executequery?
What is meant by executenonquery?
What is the meaning of object pooling?
What is the difference between SqlCommand and SqlCommandBuilder?