简单的登录界面代码!

来源:互联网 发布:阳台 百叶窗 知乎 编辑:程序博客网 时间:2024/06/11 20:56
private void Button1_Click(object sender, System.EventArgs e)
{
string name;
string pass;
name=tbname.Text;
pass=tbpass.Text;
// 建立数据库连接对象
try
{
OleDbConnection Conn = new OleDbConnection();
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("User.mdb");
//OleDbConnection:该对象管理与可通过OLEDB访问的任何数据存储区的连接,创建对象conn,连接数据库User.mdb
Conn.Open();//打开连接conn
string str = "select * from [user] where [userid] =" + name + " and [password] =" + pass + "";
OleDbCommand Comm = new OleDbCommand(str, Conn); //存储过程
OleDbDataReader dr = Comm.ExecuteReader(CommandBehavior.CloseConnection);
if(dr.Read())
Response.Redirect("WebForm5.aspx");
else
{
tbname.Text="";
tbpass.Text="";
Response.Write("<script>alert(还未注册?)</script>");
lblMessage.Text = "用户或密码不正确!请验证后再输入!";
}

dr.Close();
Conn.Close();
}
catch(Exception ex)
{

lblMessage.Text = (ex.Message);
}
原创粉丝点击