写了一个三层的登录,不知道是那出错了!
Web层代码:
public partial class _Default : System.Web.UI.Page
{
LoginBusiness.Business rule = new LoginBusiness.Business();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string user =this.txtUser.Text.Trim();
string userpwd = this.txtPwd.Text.Trim();
bool flag = rule.LoginUser(user, userpwd);
if (flag == true)
{
Response.Write( " <script language= 'javascript '> alert( '登陆成功 '); </script> ");
}
else
{
Response.Write( " <script language= 'javascript '> alert( '登陆失败 '); </script> ");
}
}
}
------
数据层:
namespace LoginData
{
public class SqlHelper
{
public string conStr = ConfigurationManager.AppSettings[ "ConnectionStrng1 "].ToString();
public int ExcuteNonQuery(string sql)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = conStr;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}