当前文件： XiaobaiLiuyanban/Login.aspx.cs[1K，2009-6-12 11:59:24]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class Login : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void Button1_Click(object sender, EventArgs e)
20    ...{
21        if (tname.Text == string.Empty || tpass.Text == string.Empty)
22        ...{
23            Response.Write("<script>alert('用户名和密码不能为空')</script>");
24        }
25        else
26        ...{
27            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["getcon"].ConnectionString);
28            con.Open();
29            string cmdtext = "select u_name,u_pass from message_users where u_name=@name and u_pass=@pass";
30            SqlCommand com = new SqlCommand(cmdtext, con);
31            com.Parameters.Add("@name", SqlDbType.VarChar).Value = this.tname.Text.ToString();
32            com.Parameters.Add("@pass", SqlDbType.VarChar).Value = this.tpass.Text.ToString();
33            SqlDataReader rs = com.ExecuteReader();
34            
35            if (rs.Read())
36            ...{
37
38                Session["name"] = this.tname.Text;
39                rs.Close();
40                com.Clone();
41
42                Response.Redirect("showmessage.aspx");
43            }
44            else
45            ...{
46                Response.Write("<script>alert('用户名和密码错误')</script>");
47            }
48        }
49    }
50}
51