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

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

4 Answers
7980 Views
SVI, I also Faced
E-Mail Answers

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

Explain the difference between data reader and data set?

0 Answers

What does ado stand for in ado.net?

0 Answers

How can we check that some changes have been made to dataset since it was loaded?

0 Answers

What are the major challenges in accessing data from a database?

0 Answers

How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers Mind Tree, TCS,

How to call the SQL commands asynchronously in ADO.NET version 2.0

4 Answers DELL,

How to store data in memory?

0 Answers

How to read data with the sqldatareader ?

0 Answers

What is the DataTableCollection?

0 Answers

Define the data provider classes that is supported by ado.net?

0 Answers

What is the provider and namespaces being used to access oracle database?

5 Answers E2E, Microsoft,

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

0 Answers

For more ADO.NET Interview Questions Click Here