作者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)