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