Setting DataReader = nothing

Posted by tanmay on Stack Overflow See other posts from Stack Overflow or by tanmay
Published on 2010-04-19T07:22:29Z Indexed on 2010/04/19 7:33 UTC
Read the original article Hit count: 361

Filed under:

datareader

|

nothing

Hi all, In my project I have seen that at many places developer has just nullify the DataReader object after use and hasn't close or dispose.. I want to know the advace effect of doing so, I mean nullifying the datareader and not closeing them.

Thanks and Regards, Tanmay.

© Stack Overflow or respective owner

Related posts about datareader

DataReader-DataSet Hybrid solution

as seen on Stack Overflow - Search for 'Stack Overflow'
My solution architects and I have exhausted both pure Dataset and Datareader solutions. Basically we have a Microsoft.NET 2.0 windows service application that pulls data based on a query and processes additional tasks per record; almost a poor mans workflow system. The recordsets are broader (in terms… >>> More
Increase application performance

as seen on Programmers - Search for 'Programmers'
I'm writing a program for a company that will generate a daily report for them. All of the data that they use for this report is stored in a local SQLite database. For this report, the utilize pretty much every bit of the information in the database. So currently, when I query the datbase, I retrieve… >>> More
DataReader Behaviour With SQL Server Locking

as seen on Stack Overflow - Search for 'Stack Overflow'
We are having some issues with our data layer when large datasets are returned from a SQL server query via a DataReader. As we use the DataReader to populate business objects and serialize them back to the client, the fetch can take several minutes (we are showing progress to the user :-)), but we've… >>> More
VBNet2008 Transfer DATAREADER rows to CrystalReport DataSet1.xsd

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Good Guys, I need your help. Please help me as I am a newbie using VB.NET. I have been asked to transfer DATAREADER rows into Crystal Report DATASET1.XSD Here are the coding Private Sub BtnTransfer() dim strsql as string = "Select OrderID, OrderDate from ORDERS" dim DS as new dataset1… >>> More
Transfer DataReader rows to a CrystalReport DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
Please help me as I am a newbie using VB.NET. I have been asked to transfer rows from a DataReader into a Crystal Report dataset. Here are the coding: Private Sub BtnTransfer() dim strsql as string = "Select OrderID, OrderDate from ORDERS" dim DS as new dataset1 '<---crysal report dataset1… >>> More

Related posts about nothing

Get Something For Nothing - Benefit From Free Web Page Counters

as seen on Ezine Articles - Search for 'Ezine Articles'
Offers for free web page counters are everywhere. A free web page counter provides beneficial information. Get one, at least one. >>> More
HP 1210 Scan Button does nothing.

as seen on Super User - Search for 'Super User'
I have an HP 1210 all-in-one nightmare of a printer which has decided not to listen to the scan button anymore. I've dug into it, and see in the properties of the scanner in Windows XP that it says "No applications are registered for this event" under what to do when the Scan button is pressed. … >>> More
Question ...........? [closed]

as seen on Stack Overflow - Search for 'Stack Overflow'
Just bored and do not know what to do right now... so I decided to ask about a question to be asked..? >>> More
Setting DataReader = nothing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, In my project I have seen that at many places developer has just nullify the DataReader object after use and hasn't close or dispose.. I want to know the advace effect of doing so, I mean nullifying the datareader and not closeing them. Thanks and Regards, Tanmay. >>> More
Check for Nothing in vbscript/classic asp

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to update an old classic asp, and I have to call a function that normally returns an array, but under certain circumstances might return either Nothing or an undefined value. How can I check that the result actually returns an array? >>> More