use a try...catch statement to force a connection to close : using « ADO.net Database « ASP.NET Tutorial

ASP.NET Tutorial

1.	ASP.Net Instroduction
2.	Language Basics
3.	ASP.net Controls
4.	HTML Controls
5.	Page Lifecycle
6.	Response
7.	Collections
8.	Validation
9.	Development
10.	File Directory
11.	Sessions
12.	Cookie
13.	Cache
14.	Custom Controls
15.	Profile
16.	Configuration
17.	LINQ
18.	ADO.net Database
19.	Data Binding
20.	Ajax
21.	Authentication Authorization
22.	I18N
23.	Mobile
24.	WebPart
25.	XML

Java

Java Tutorial

Java Source Code / Java Documentation

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

ASP.NET Tutorial » ADO.net Database » using

18. 59. 2. use a try...catch statement to force a connection to close


SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True;Initial Catalog=Pubs");

SqlCommand cmd = new SqlCommand("INSERT Titles (Title) VALUES ('Some Title')", con);

try

{

  con.Open();

  cmd.ExecuteNonQuery();

}

finally

{

  con.Close();

}

18. 59. using
	18. 59. 1.	The using statement forces the connection to close, regardless of whether there is an error
	18. 59. 2.	use a try...catch statement to force a connection to close

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.