index.aspx.cs

随着计算机科学的发展

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {

    }


    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("pollresult.aspx?result=" + RadioButtonList1.SelectedIndex.ToString()); //取得数据,Response控件
        RadioButtonList1.SelectedIndex = -1; //不被执行
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string username1,userpwd1;
        username1 =TextBox1.Text.Trim();
        userpwd1 = TextBox2.Text.Trim(); 
        /*SqlConnection con = DB.CreateCon();
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into guest(username,userpwd) values ('" + username1 + "','" + userpwd1 + "')", con);
        cmd.ExecuteReader();
        Response.Redirect("succese.aspx");*/
        //注册代码
        SqlConnection con = DB.CreateCon();
        con.Open();
        SqlCommand cmd = new SqlCommand("select count(*) from guest where(userName like'"+username1+"' and userpwd like'"+userpwd1+"')", con);
        int flag=(int)cmd.ExecuteScalar();
        if (flag > 0)//用户不存在
        {
            Session["userName"]=Label1.Text;
            Response.Redirect("succese.aspx");    
        }
        else 
        {
            Label1.Text = "用户名或密码不符，请重新输入。";
            TextBox1.Text = "";
            TextBox2.Text = "";
        }
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        string username2, userpwd2;
        username2 = TextBox1.Text.Trim();
        userpwd2 = TextBox2.Text.Trim(); 
        SqlConnection con = DB.CreateCon();
        con.Open();
        SqlCommand cmd1 = new SqlCommand("select count(*) from guest where(userName ='"+username2+"' and userpwd='"+userpwd2+"')",con);
        int flag = (int)cmd1.ExecuteScalar();
        if (flag != 0)
        {
            Response.Redirect("houtai.aspx");
        }
        else
        {
            Label1.Text = "用户名或密码不符，请重新输入。";
            TextBox1.Text = "";
            TextBox2.Text = "";
        }
    }
}