default.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

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 Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        //从文件Web.config中读取连接字符串
        string strconn = ConfigurationSettings.AppSettings["dsn"];
        //连接本地计算机的HMS数据库
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        //构造SQL语句，该语句在Users表中检查用户名和密码是否正确
        string mysql = "select * from Users where Uid='" + tbx_uid.Text + "'and UPassword='" + tbx_upassword.Text + "'";
        //创建Command对象
        SqlCommand cm = new SqlCommand(mysql, cn);
        //执行ExecuteReader ()方法
        SqlDataReader dr = cm.ExecuteReader();
        if (dr.Read())
        {
            lbl_message.Text = "";
            //保存当前用户名及用户权限
            Session["uid"] = dr["uid"].ToString();
            Session["upower"] = dr["upower"].ToString();
            lbl_message.Text = "欢迎您！" + Session["uid"];
            if (Session["upower"].ToString() == "1")
            {	//进入酒店总管界面
                Response.Redirect("roommanage.aspx");
            }
            else if (Session["upower"].ToString() == "2")
            {	//进入酒店前台界面
                Response.Redirect("roomlist.aspx");
            }
        }
        else
        {
            lbl_message.Text = "对不起，您的用户名/密码不正确，请重新输入";
        }
        //关闭连接
        cn.Close();
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        tbx_uid.Text = "";
        tbx_upassword.Text = "";
    }
}