using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class admin_login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)//登录按钮
{
string username = txtname.Text.Trim();
string pwd = txtpwd.Text.Trim();
string sql = select * from Admin where Username=' + username + ' and Pwd=' + pwd + ' and Type=0;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[LinXuan].ConnectionString);
con.Open();//打开连接
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader();//执行命令
if (dr.Read())
{
Session[myadmin] = username;//保存登录名
Response.Redirect(manage.aspx, true);//登录成功跳转页面
}
else
{
Response.Write(script language=javascriptalert('用户名或者密码不正确!请重新输入!');/script);
}
dr.Close();
con.Close();
}
}
取消
评论