Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual C# >> Visual C# General

reopen connection

Can I reopen a DB connection object after I close it? e.g.

SqlConnection conn = new SqlConnection(...);
conn.Open();
...
conn.Close();
conn.Open(); // reopen OK?

[180 byte] By [nonno] at [2007-12-16]
«« Full Text Search Engine in Chinese Simplied
»» Dynamic SQL task
# 1
Yes, you definately can reopen a connection after its been closed. But before its been Disposed. If you call the Dispose method on the Connection object, then it looses the unmanaged connection reference and will not open.

Are you facing any problems in this aspect?

Regards,
Saurabh Nandu
www.MasterCSharp.com
www.AksTech.com

SaurabhNandu at 2007-9-9 > top of Msdn Tech,Visual C#,Visual C# General...
Visual C#
Visual C# General

Visual C# Hot Topic

Visual C# New Topic

Visual C#

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified