登陆页面

 1   protected void Button1_Click(object sender, EventArgs e)
 2     {
 3         string userID = TextBox1.Text;
 4         string userPASSWORD = TextBox2.Text;
 5 
 6         string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["NewTestConnectionString"].ConnectionString;
 7 
 8         try
 9         {
10             SqlConnection conn = new SqlConnection();
11             conn.ConnectionString = conStr;
12             conn.Open();
13 
14             SqlCommand cmd = new SqlCommand();
15             cmd.Connection = conn;
16             cmd.CommandText = "select adminId,adminPassword from AdminInfo where adminId = '"+TextBox1.Text+"' and adminPassword = '"+ TextBox2.Text+"'";
17             //cmd.CommandText = "select adminId,adminPassword form AdminInfo where adminId = '"+userID+"' and adminPassword = '"+userPASSWORD+"'";
18             SqlDataReader reader = cmd.ExecuteReader();
19 
20             if (reader.Read())
21             {
22                 Response.Redirect("http://baidu.com");
23             }
24 
25             else
26             {
27                 Response.Redirect("http://qq.com");
28             }
29 
30         }
31 
32         catch(Exception ex)
33         {
34             Console.WriteLine(ex.Message);
35  
36         }
37      

转载于:https://www.cnblogs.com/fromcuit/archive/2012/05/16/2505543.html