作者buubuu (buu)
站內Programming
標題ASP.NET
時間Sun Jun 24 00:00:55 2007
小弟不才>"<
在會員驗證的地方 一直跑不出來
它一直說 "ConnectionString 屬性尚未初始化"
可是不知道是哪裡錯了
這是我寫的一段程式碼
login.aspx
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>會員登入</title>
<script runat="server" language="C#">
void LoginUser(Object s, EventArgs e)
{
bool blnAuthenticate = Authenticate(TBusername.Text, TBpwd.Text);
if (FormsAuthentication.Authenticate(TBusername.Text, TBpwd.Text))
{
FormsAuthentication.RedirectFromLoginPage(TBusername.Text,
false);
}
else{
Error.Text ="錯誤 請再輸入一次"
}
}
bool Authenticate(string strUsername, string strPassword)
{
OleDbConnection objConn;
objConn = new OleDbConnection(
ConfigurationSettings.AppSettings["DSN"]);
OleDbCommand objCmd;
OleDbDataReader objDR;
bool userFound;
objCmd = new OleDbCommand("SELECT*FROM Employees " +
"WHERE TBusername='" + TBusername.Text +
"'AND TBpwd='" + TBpwd.Text + "'", objConn);
objConn.Open();
objDR = objCmd.ExecuteReader();
userFound = objDR.Read();
objDR.Close();
objConn.Close();
return userFound;
}
</script>
</head>
<body>
<form id="Form1" runat="server">
<p>會員帳號<br/>
<asp:TextBox ID="TBusername" runat="server" /><br />
<asp:RequiredFieldValidator ID="rfvUsername"
ControlToValidate="TBusername"
ErrorMessage="輸入帳號錯誤" runat="server" /></p>
<p>會員密碼<br/>
<asp:TextBox ID="TBpwd" TextMode="Password" runat="server" /><br />
<asp:RequiredFieldValidator ID="rfvPassord"
ControlToValidate="TBpwd"
ErrorMessage="輸入密碼錯誤" runat="server" /></p>
<p><asp:Button ID="btnSubmit" Text="Login" runat="server"
OnClick="LoginUser" />
<asp:Label ID="Error" ForeColor="Red" Runat="Server" />
</form>
</body>
</html>
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.115.217.216
※ 編輯: buubuu 來自: 140.115.217.216 (06/24 00:01)