How can we force the Connection object to close after DataReader object is closed?

Posted By: Avi

Date: 6 October 2009 06:34:42 AM

Answer:

We use ExecuteReader method of Command object to get the DataReader object. This ExecuteReader method takes a parameter of type CommandBehavior. With the help of this CommandBehavior parameter we can specify to close the associated Connection object to close automatically after the DataReader object is closed.

Following code snippet is used to do the same:

objDataReader = objCommand.ExecuteReader (CommandBehavior.CloseConnection);

Posted By: eTechPlanet

Date: 6 October 2009 06:34:42 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

Explain the various steps involved to fill a dataset?

Step-1: Open the database connection by creating a Connection object. We can load the connection str....

Category: ADO.Net

Date: 10/8/2009 3:16:53 AM

What is the difference between DataSet.Clone() and DataSet.Copy() methods?

DataSet.Clone(): It only copies structure, does not copy data. DataSet.Copy(): Copies both structur....

Category: ADO.Net

Date: 10/6/2009 6:37:58 AM