带有sql后端的登录页面的c＃.net源代码 [英] c#.net source code for log in page with sql backend

问题描述

请我想要C＃.net代码登录页面nd sql用作后端.....

please i want C#.net code for log in page nd sql is used as back end.....

推荐答案

使用SQL登录ASP.net中的页面 [ ^ ]

登录页面示例 [ ^ ]

尝试

http://msdn.microsoft.com/en-us/library/ms178331%28v=vs.90%29.aspx [<一个href =http://msdn.microsoft.com/en-us/library/ms178331%28v=vs.90%29.aspxtarget =_ blanktitle =New Window> ^ ]

http://www.aspdotnet-suresh.com/2011/12/how- to-create-simple-login-form-using.html [ ^ ]

http://www.mikesdotnetting.com/Article/75/Simple-Login-and-Redirect-for-ASP.NET-and-Access [ ^ ]

Try
http://msdn.microsoft.com/en-us/library/ms178331%28v=vs.90%29.aspx[^]
http://www.aspdotnet-suresh.com/2011/12/how-to-create-simple-login-form-using.html[^]
http://www.mikesdotnetting.com/Article/75/Simple-Login-and-Redirect-for-ASP.NET-and-Access[^]

 SqlConnection con = new SqlConnection(@"Data Source=.\Aroona;Initial Catalog=ACSDatabase;Integrated Security=True;Pooling=False");
SqlDataAdapter loginadp = new SqlDataAdapter("SELECT count(*) FROM Login WHERE username = '" + uName.Text + "' AND password = '" + pWord.Text + "' ", con);
            
DataTable dt = new DataTable();
loginadp.Fill(dt);
            
           
if (dt.Rows[0][0].ToString() == "1")
      {
         if (uName.Text == "Admin")
             {
                 MPageAdmin mpa = new MPageAdmin();
                 mpa.Show();
                 this.Hide();
             }
          else
             {
                  Main_Page mp = new Main_Page(this.UserName);
                  mp.Show();
                  this.Hide();
              }
       }
else
       {
           label4.Visible = true;
           label4.Text = "Username or Password Incorrect!";
        }

这对我有用。

This works for me.

这篇关于带有sql后端的登录页面的c＃.net源代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！