c# 控件 自定義控件-關於c#的dr.Close();放哪裡好？

關於c#的dr.Close();放哪裡好？

     cn.ConnectionString = "server = (local);password = 123;uid = sa;database = keshe";
    cn.Open();

    SqlCommand cmd_jiage = new SqlCommand("select 出租價格 from 房屋表", cn);
    SqlDataReader dr = cmd_jiage.ExecuteReader();
    while (dr.Read())
    {

        if (dr["出租價格"].ToString().Trim() == TextBox1.Text)
        {

            SqlCommand cmd = new SqlCommand("select * from 房屋表 where 出租價格 = @jiage", cn);
            cmd.Parameters.Add("@jiage", TextBox1.Text);
            GridView1.DataSource = cmd.ExecuteReader();
            GridView1.DataBind();

        }
        else
        {
            Label1.Text = "asd";
        }
        dr.Close();
    }
    cn.Close();

最佳回答：

使用

using (SqlDataReader dr = cmd_jiage.ExecuteReader()) {
    while(dr.Read()) {
        // do the readings.....
    }
} // will be automatically disposed here, no Close is needed