WebProje.admin.DB.ac C# (CSharp) Method

        public void ac()
        {
            try
            {
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
            }
            catch (Exception ex)
            {

                //MessageBox.Show("DB Kapatma Sorunu " + ex);
            }
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            ktgrls.Clear();
            SqlDataReader krd = db.dataGetir("hbrKategori");

            while (krd.Read())
            {
                pHbrKategori hbrkgtr = new pHbrKategori();
                hbrkgtr.KatId = Convert.ToInt32(krd["ID"]);
                hbrkgtr.KatAd = krd["adi"].ToString();
                ktgrls.Add(hbrkgtr);
            }
            db.kapat();

            foreach (pHbrKategori item in ktgrls)
            {
                DropDownList1.Items.Add(new ListItem(HttpUtility.HtmlDecode("") + item.KatAd, item.KatId.ToString()));
            }

            try
            {
                db.ac();
                SqlCommand    cm = new SqlCommand("select * from haberler where ID = '" + Request.QueryString["hbrID"].ToString() + "'", db.conn);
                SqlDataReader rd = cm.ExecuteReader();
                while (rd.Read())
                {
                    pHaberler hbr = new pHaberler();
                    hbr.HbrID       = Convert.ToInt32(rd["ID"]);
                    hbr.HbrKatId    = Convert.ToInt32(rd["katID"]);
                    hbr.HbrBaslik   = rd["baslik"].ToString();
                    hbr.HbrAciklama = rd["kisaAciklama"].ToString();
                    hbr.HbrIcerik   = rd["icerik"].ToString();
                    hbr.HbrDurum    = Convert.ToInt32(rd["durum"]);
                    hbr.HbrTarih    = Convert.ToDateTime(rd["tarih"]);
                    hbr.HbrResim    = rd["resim"].ToString();
                    hbrList.Add(hbr);
                }
                db.kapat();
                pHaberler lst = (pHaberler)hbrDuzenle.hbrList[0];
                txthbrBaslik.Text    = lst.HbrBaslik;
                txtIcerik.Text       = lst.HbrIcerik;
                txtKisaAciklama.Text = lst.HbrAciklama;
                FileInfo dosyaBilgi = new FileInfo(fluDosya.FileName);
            }
            catch (Exception ex)
            {
                // hata
            }
        }