用户登录验证与数据库交互-优快云博客

前台

效果图

后台

#region 连接数据库
            string sqlsercon = @"Data Source=IDEA-PC\\MSSQ;Initial Catalog=MyTest;User ID=sa;Password=123";
            //System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(sqlsercon);
            SqlConnection conn = new SqlConnection(sqlsercon);
            conn.Open();
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select count(*) from aa where UserName=@username and PassWord=@password ";
            cmd.Parameters.AddWithValue("@username",TextBox1);
            cmd.Parameters.AddWithValue("@password",TextBox2);
            int result=Convert.ToInt32(cmd.ExecuteScalar());
            if (result > 0)
            {
                Response.Write("用户名和密码正确");
            }
            else
            {
                Response.Write("用户名或密码错误,请重新输入");
            }
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
运行结果