{"id":2119,"date":"2023-04-12T14:05:36","date_gmt":"2023-04-12T11:05:36","guid":{"rendered":"https:\/\/www.aydiner.gen.tr\/?p=2119"},"modified":"2023-05-16T15:48:27","modified_gmt":"2023-05-16T12:48:27","slug":"visual-studio-kullanici-kaydol-girisi-islemleri","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2023\/04\/12\/visual-studio-kullanici-kaydol-girisi-islemleri\/","title":{"rendered":"Visual Studio Kaydol-Giri\u015f-\u00c7\u0131k\u0131\u015f-Y\u00f6netim i\u015flemleri"},"content":{"rendered":"

veritaban\u0131 ad\u0131: kitapyurdu<\/p>\n

tablo: Kullanici<\/p>\n

Giris Sayfas\u0131 Giri\u015f Yap Butonu<\/strong><\/p>\n

\r\n\r\nstring kullanici = TxtEposta.Text;\r\n            string sifre = TxtSifre.Text;\r\n            SqlConnection baglan = new SqlConnection("Data Source=LAB3OGRTMEN\\\\SQLEXPRESS;Initial Catalog=kitapyurdu;Integrated Security=True");\r\n            SqlCommand sorgula = new SqlCommand("SELECT * FROM Kullanici WHERE Eposta=@KullaniciAdi AND Sifre=@Sifre", baglan);\r\n            sorgula.Parameters.AddWithValue("@KullaniciAdi", kullanici);\r\n            sorgula.Parameters.AddWithValue("@Sifre", sifre);\r\n            baglan.Open();\r\n            SqlDataReader oku = sorgula.ExecuteReader();\r\n            if (oku.Read())\r\n            {\r\n                Session["KullaniciAdi"] = oku["AdSoyad"].ToString();\r\n                Session["Yetki"] = oku["Yetki"].ToString();\r\n                Response.Redirect("Default.aspx");\r\n            }\r\n            else\r\n            hata.Visible = true;\r\n            TxtEposta.Text = "";\r\n            TxtSifre.Text = "";\r\n            TxtEposta.Focus();\r\n            oku.Close();\r\n            baglan.Close();\r\n            baglan.Dispose();\r\n\r\n\r\n\r\n<\/pre>\n
Master Sayfas\u0131 Session Kar\u015f\u0131lama<\/p>\n
\r\n protected void Page_Load(object sender, EventArgs e)\r\n        {\r\n\r\n            if (Session["KullaniciAdi"] != null)\r\n            {\r\n                LblGiris.Text = "Ho\u015fgeldin " + Session["KullaniciAdi"].ToString();\r\n                BtnCikis.Visible = true;\r\n            }\r\n\r\n\r\n        }\r\n\r\n        protected void BtnCikis_Click(object sender, EventArgs e)\r\n        {\r\n            Session["KullaniciAdi"] = null;\r\n            Response.Redirect("Default.aspx");\r\n        }\r\n<\/pre>\n
Y\u00f6netim Sayfas\u0131 Yetkilendirme<\/p>\n
\r\n protected void Page_Load(object sender, EventArgs e)\r\n        {\r\n\r\n\r\n            if(Session["Yetki"]==null || Session["Yetki"].ToString()=="normal")\r\n            {\r\n\r\n                Response.Redirect("hata.aspx");\r\n            }\r\n\r\n\r\n        }\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
veritaban\u0131 ad\u0131: kitapyurdu tablo: Kullanici Giris Sayfas\u0131 Giri\u015f Yap Butonu string kullanici = TxtEposta.Text; string sifre = TxtSifre.Text; SqlConnection baglan […]<\/p>\n","protected":false},"author":1,"featured_media":672,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[179],"class_list":["post-2119","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web","tag-visual-studio-kullanici-kaydol-girisi-islemleri"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/comments?post=2119"}],"version-history":[{"count":7,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2119\/revisions"}],"predecessor-version":[{"id":2217,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2119\/revisions\/2217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media\/672"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}