CafeProject.GarsonGuncellemeEkrani.fncDataGetir C# (CSharp) Метод

        public void fncDataGetir()
        {
            db.dbConnect();
            SqlCommand com = new SqlCommand("SELECT kulAdi,sifre, tcno,mail,adres,telefon, adi FROM kullanicilar , profil  where kullanicilar.profilID=profil.id", db.dbConnect());
            SqlDataReader dr1 = com.ExecuteReader();

            dr1.Read();

            txtTcNo.Text = dr1["tcno"].ToString();
            txt_kulAdı.Text = dr1["kulAdi"].ToString();
            txtSifre.Text = dr1["sifre"].ToString();
            txtAdres.Text = dr1["adres"].ToString();
            txtMail.Text = dr1["mail"].ToString();
            txtTel.Text = dr1["telefon"].ToString();

            db.dbClose();
        }