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.Data.SqlClient;
//登录搜寻匹配例子
string cmdtext1 = "select * from Staff where s_logname='" + this.tname.Text +"' and s_password='" + this.tpass.Text + "'"; //Staff库,s_logname&s_password数据Design Name;
SqlConnection con =new SqlConnection("Server=localhost;database=qcwx;uid=sa;pwd=sasasa"); //创建连接
con.Open();
SqlCommand cmd =new SqlCommand(cmdtext1, con);
try
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
MessageBox.Show("登录成功!");
sqlconn.Close();
Response.Redirect("user/Usermb.aspx");
}
else
{
MessageBox.Show("用户名或密码错误");
dr.Close();
con.Close();
}
}
catch (Exception err)
{
Response.Write(err);
}