关闭数据库连接的高效方法 (asp.net 2.0 C#)

 
我们还可以采用一种更加简便的方
法来实现上述程序的功能。这就是将SqlConnection对象包含到using区块中，这样程序会自动调用Dispose()方法释放
SqlConnection对象所占用的系统资源，无需再使用SqlConnection对象的Close()方法。
范例程序代码如下：
public partial class _Default : System.Web.UI.Page
{
     protected void Page_Load(object sender, EventArgs e)
    {
    string connectionString = "server=localhost;database=Northwind;
    integrated security=SSPI";
    SqlConnection mySqlConnection = new SqlConnection(connectionString);
    using (mySqlConnection)
   {
       mySqlConnection.Open();
       lblInfo.Text = "<b>mySqlConnection对象的ConnectionString属性为：<b>" +
       mySqlConnection.ConnectionString + "<br>";
       lblInfo.Text += "<b>mySqlConnection对象的ConnectionTimeout属性为<b>" +
       mySqlConnection.ConnectionTimeout + "<br>";
      lblInfo.Text += "<b>mySqlConnection对象的Database属性为<b>" +
       mySqlConnection.Database + "<br>";
      lblInfo.Text += "<b>mySqlConnection对象的DataSource属性为<b>" +
      mySqlConnection.DataSource + "<br>";
       lblInfo.Text += "<b>mySqlConnection对象的PacketSize属性为<b>" +
       mySqlConnection.PacketSize + "<br>";
      lblInfo.Text += "<b>mySqlConnection对象的ServerVersion属性为<b>" +