14.3.2 功能实现

protected void Button1_Click(object sender, EventArgs e)
{   //创建连接
SqlConnection con = new SqlConnection("server=.;database=login;uid=sa;pwd=;");
if (Session["CheckCode"].ToString().Equals(TextBoxYzm.Text.ToString()))
{
try
{
con.Open();
SqlCommand com = new SqlCommand("select count(*) from loginInfo 
where  Name= @name and Pass=@ps", con);
com.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar, 50));
com.Parameters["@name"].Value = TextName.Text;
com.Parameters.Add(new SqlParameter("@ps", SqlDbType.VarChar, 50));
com.Parameters["@ps"].Value =  
FormsAuthentication.HashPasswordForStoringInConfigFile(TextPass.Text, "MD5");
int i = (int)com.ExecuteScalar();
if (i > 0)
{
//添加登陆日志
com = new SqlCommand("insert EntryLog values('" + TextName.Text 
+  "','" + DateTime.Now.ToString() + "')", con);
com.ExecuteNonQuery();
con.Close();
Response.Redirect("index.aspx");
}
else
{
Response.Write("<script>alert('密码或用户名错误！')</script>");
}
}
catch (Exception error)
{
Response.Write(error.ToString());
}
}
else
Response.Write("<script>alert('验证码错误！')</script>");           
}

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Image1.ImageUrl = "ValidateCode.aspx";

}
}

protected void LinkButton2_Click(object sender, EventArgs e)
{
this.Image1.ImageUrl = "ValidateCode.aspx";
}