Hi,everyone
I have login.aspx and login.aspx.cs.
When I click the button no event occurs.
Please help me!
login.aspx
<%@ Page Language="c#" src="login.aspx.cs" AutoEventWireup="false" Inherits="ciq.verify"%>
<html>
<head>
</head>
<body>
<form runat="server" method=post>
<br />
<br />
<br />
<br />
<br />
<br />
<div align="center">
<table bordercolor="#666666" width="200" align="center" bgcolor="#c0ffff" border="1">
<tbody>
<tr>
<th colspan="2">
Login
</th>
</tr>
<tr>
<td>
Username:
</td>
<td>
<asp:TextBox id="userid" runat="server" MaxLength="10" Columns="10"></asp:TextBox>
<asp:RequiredFieldValidator id="RequiredFieldValidator1" runat="server" display="static" ControlToValidate="userid" ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
Password:
</td>
<td>
<asp:TextBox id="pwd" runat="server" Columns="10" MaxLength="8" TextMode="password"></asp:TextBox>
<asp:RequiredFieldValidator id="RequiredFieldValidator2" runat="server" display="static" ControlToValidate="pwd" ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<th colspan="2">
<asp:Button id="btnSubmit" runat="server" Text="Enter"></asp:Button>
<asp:Label ID="errMessage" Runat=Server></asp:Label>
</th>
</tr>
</tbody>
</table>
</div>
</form>
</body>
</html>
login.aspx.cs
using System;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
/// <summary>
/// Summary description for verify
/// </summary>
namespace ciq
{
public class verify : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox userid;
protected System.Web.UI.WebControls.TextBox pwd;
protected System.Web.UI.WebControls.Button btnSubmit;
protected System.Web.UI.WebControls.Label errMessage;
private void Page_Load(object sender, EventArgs e)
{
}
protected void Page_Init(object sender,EventArgs e)
{
InitializeComponent();
}
private void InitializeComponent()
{
this.btnSubmit.Click += new System.EventHandler(this.btnSubmit_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
private void btnSubmit_Click(object sender, EventArgs e)
{
bool pwdVerified = false;
try
{
//verify the password
pwdVerified = verifyPwd(userid.Text, pwd.Text);
}
catch (Exception ex)
{
return;
}
//whether verified
if (pwdVerified==true)
{
errMessage.Text = "ok!";
}
else
{
errMessage.Text = "Incorrect username or password!";
}
}
private bool verifyPwd(string username, string pwd)
{
bool pwdMatch = false;
//connect to database
SqlConnection conn = new SqlConnection("server=(local);database=ciq;uid=sa, pwd=");
string sSql="select pwd from user where userid='"+username+"'";
SqlCommand cmd = new SqlCommand(sSql, conn);
try
{
conn.Open();
string sPwd = (string)cmd.ExecuteScalar();
cmd.Dispose();
conn.Dispose();
pwdMatch=sPwd.Equals(pwd);
}
catch(Exception ex)
{
}
return pwdMatch;
}
}
}
Any help will be greatly appreciated.
code behind
