ASP.NET2.0关闭数据库连接另一种方法

我们还可以采用一种更加简便的方法来实现上述程序的功能。这就是将SqlConnection对象包含到using区块中，这样程序会自动调用Dispose()方法释放SqlConnection对象所占用的系统资源，无需再使用SqlConnection对象的Close()方法。

范例程序代码如下：

01 public partial class _Default : System.Web.UI.Page 02 { 03 protected void Page_Load(object sender, EventArgs e) 04 { 05 string connectionString = "server=localhost;database=Northwind; 06 integrated security=SSPI"; 07 SqlConnection mySqlConnection = new SqlConnection(connectionString); 08 using (mySqlConnection) 09 { 10 mySqlConnection.Open(); 11 lblInfo.Text = "＜b＞mySqlConnection对象的ConnectionString属性为：＜b＞" + 12 mySqlConnection.ConnectionString + "＜br＞"; 13 lblInfo.Text += "＜b＞mySqlConnection对象的ConnectionTimeout属性为＜b＞" + 14 mySqlConnection.ConnectionTimeout + "＜br＞"; 15 lblInfo.Text += "＜b＞mySqlConnection对象的Database属性为＜b＞" + 16 mySqlConnection.Database + "＜br＞"; 17 lblInfo.Text += "＜b＞mySqlConnection对象的DataSource属性为＜b＞" + 18 mySqlConnection.DataSource + "＜br＞"; 19 lblInfo.Text += "＜b＞mySqlConnection对象的PacketSize属性为＜b＞" + 20 mySqlConnection.PacketSize + "＜br＞"; 21 lblInfo.Text += "＜b＞mySqlConnection对象的ServerVersion属性为＜b＞" + 22 mySqlConnection.ServerVersion + "＜br＞"; 23 lblInfo.Text += "＜b＞mySqlConnection对象的当前状态为＜b＞"+ 24 mySqlConnection.State + "＜br＞"; 25 } 26 lblInfo.Text += "＜br＞＜b＞关闭连接后的mySqlConnection对象的状态为：＜/b＞"; 27 lblInfo.Text += mySqlConnection.State.ToString(); 28 } 29 }

　　程序代码说明：在上述范例的程序代码中，采用using(mySqlConnection)的形式使得代码更加简洁，并且其最大的优点就是无需编写finally区块代码，可以自动关闭与数据库的连接