login.aspx.cs

来自「用Excel文件做数据库进行数据的读写,实现数据集的读取」· CS 代码 · 共 47 行

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.OleDb;


//*********************Write by PudnPh


public partial class Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string Username = TextBox1.Text.ToString();
        string Password = TextBox2.Text.ToString();

        string Path = Server.MapPath("App_Data") + "\\FreeDB.xls";
        string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + Path + "';Extended Properties=Excel 8.0;";
        OleDbConnection conn = new OleDbConnection(ConnStr);
        conn.Open();
        string SelectText = "select * from [Sheet1$] where UserName='" + Username + "' and  Password='" + Password + "'";
        OleDbCommand cmd = new OleDbCommand(SelectText, conn);
        OleDbDataReader MyReader = cmd.ExecuteReader();
        if (MyReader.Read())
        {
            Response.Write("<script>alert('登录成功')</script>");
        }
        else
        {
            Response.Write("<script>alert('登录失败')</script>");
        }
        conn.Close();
    }
}