query about datareader object

Question

i want simple exlaination from you guyz that why we close the datareader object like datareader dr = new datareader; //assume that some code is here. dr.close(); and when we close datareader object...

Upendra Pratap Shahi · Answer

Hello, You should always call the Close method when you have finished using the DataReader Object.Closing a SqlConnection should destroy any resources that the SqlDataReader is using. Do not call Close or Dispose on a Connection, a DataReader, or any other managed object in the Finalize method of your class. http://stackoverflow.com/questions/2655978/is-closing-disposing-an-sqldatareader-needed-if-you-are-already-closing-the-sqlc

Munesh Sharma · Answer

https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.close(v=vs.110).aspx

Rojalin Sahoo · Answer

Using statement is an awesome tool to close and dispose objects of c lasses that implement IDisposable that helps to reduce coding effort and possible issues. Safe side is warrped SqlDataReader object in a Using Statement . If it's in a using block, then it is automatically closed. You do not need to explicitly close it. You should always call the Close method when you have finished using the DataReader Object.Closing a SqlConnection should destroy any resources that the SqlDataReader is using. Following are some links that will help you to know better: Need of sqldatareader-dispose Is closing/disposing an SqlDataReader needed if you are already closing the SqlConnection? Dispose SqlDataReader

Karthikeyan K · Answer

Hi sir, Refer the below link, 1.https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.close%28v=vs.110%29.aspx If it is useful then kindly accept my answer Karthikeyan K

Karthikeyan K · Answer

Hi, Remarks You must explicitly call the Close method when you are through using the SqlDataReader to use the associated SqlConnection for any other purpose. The Close method fills in the values for output parameters, return values and RecordsAffected, increasing the time that it takes to close a SqlDataReader that was used to process a large or complex query. When the return values and the number of records affected by a query are not significant, the time that it takes to close the SqlDataReader can be reduced by calling the Cancel method of the associated SqlCommand object before calling the Close method. Do not call Close or Dispose on a Connection, a DataReader, or any other managed object in the Finalize method of your class. In a finalizer, you should only release unmanaged resources that your class owns directly. If your class does not own any unmanaged resources, do not include a Finalize method in your class definition. For more information, see Garbage Collection .

query about datareader object

Answers (5)