using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient; -- 用sql数据包,别忘了加它
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
--程序开始运行的时就执行的语句;下面的语句表示的是Label1是隐藏的
this.Label1.Visible = false;
}
protected void Button1_Click(object sender, EventArgs e)
{
--连接数据库,是以windows身份验证的方式登录数据库的
SqlConnection sc = new SqlConnection("server=.;database=dl;Integrated Security=true");
sc.Open();
--从数据库里去东西
SqlCommand cmd = new SqlCommand("select count(*) from yhdl where yh='" + TextBox1.Text + "'", sc);
--ExecuteScalar()是去单行单列的数据
int a =Convert.ToInt32(cmd.ExecuteScalar());
if (a>0)
{
SqlCommand cmd1 = new SqlCommand("select count(*) from yhdl where mm='" + TextBox2.Text + "'", sc);
int b = Convert.ToInt32(cmd1.ExecuteScalar());
if (b == 1)
{
this.Label1.Text = "登陆成功!";
this.Label1.Visible = true;
}
else
{
this.Label1.Text = "密码不正确!";
this.Label1.Visible = true;
}
}
else
{
this.Label1.Text = "没有此用户!";
this.Label1.Visible = true;
}
}
}