提示在 ConnectionString 中未指定 OLE DB 提供程序。 改哪里才行
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;
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 = TBX_Username.Text.Trim();
string password = TBX_Pass.Text.Trim();
string type = DropDownList1.Text.Trim();
string temp =@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\wgl\Documents\stuorg.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
string sql = "select * from Login where Username='" + username + "' and Password='" + password + "'and Type='" + type + "'";
OleDbConnection conn = new OleDbConnection(temp);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Session["Username"] = username;
Session["Password"] = password;
if (type == "0")
{
Response.Redirect("系统管理员.aspx");
}
else if(type == "1")
{
Response.Redirect("普通用户视图.aspx");
}
}
else
{
Response.Write("<script language='javascript'>alert('用户名或密码错误!');location='login.aspx' </script>");
}
}
protected void TBX_Username_TextChanged(object sender, EventArgs e)
{
}
protected void TBX_Pass_TextChanged(object sender, EventArgs e)
{
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
}
}