?using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Panel1.Visible = false; 
        Panel2.Visible = false;
        Panel3.Visible = true;
        Panel4.Visible =  false;

    }
    
    
    protected void Button4_Click(object sender, EventArgs e)
    {
        Panel1.Visible = false;
        Panel2.Visible = false;
        Panel3.Visible = true;
       
        Panel4.Visible = false;
        string xm = TextBox6.Text;
        string xl = TextBox7.Text;

        SqlConnection conn = new SqlConnection("server=.;database=tong ;pwd=sa;uid=sa");
        conn.Open();
        SqlDataAdapter sdr = new SqlDataAdapter();
        sdr.SelectCommand = new SqlCommand("select * from chengxu where name = " + "'" + xm + "'", conn);
        sdr.SelectCommand = new SqlCommand("select * from chengxu where mima = " + "'" + xl + "'", conn);
       　DataSet rs = new DataSet();
         sdr.Fill(rs, "cheng");
        if (rs.Tables["cheng"].Rows.Count　== 0)
        {
            Response.Write("<script>alert('對不起，密碼或者用戶名錯誤，請重新輸入！')</script>");
            Panel3.Visible = true;
            TextBox6.Text = " ";
            TextBox7.Text = " ";
            
            
        }

        else
        {
            Panel3.Visible = false;
            Panel4.Visible = true; 

        }



       

        conn.Close();
    }
   
    protected void  Button2_Click(object sender, EventArgs e)
{
        Panel1.Visible = false;
        Panel2.Visible = true;
         Panel3.Visible = false;

        Panel4.Visible = false;
        string xm = TextBox1.Text;
        string pass = TextBox2.Text;
        SqlConnection conn = new SqlConnection("server=.;pwd=sa;uid=sa;database=tong");
        conn.Open();
        SqlDataAdapter sdr = new SqlDataAdapter();
        sdr.SelectCommand = new SqlCommand("select * from chengxu", conn);
        DataSet rs = new DataSet();
        sdr.Fill(rs, "cheng");
　　　　sdr.InsertCommand = new SqlCommand("Insert Into chengxu(name ,mima) Values('" + xm + "','" + pass + "')", conn);
        sdr.InsertCommand.ExecuteNonQuery();
        sdr.Update(rs, "cheng");
        conn.Close();
}
    protected void Button5_Click(object sender, EventArgs e)
    {
        
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
       
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        Panel1.Visible = true;
        Panel2.Visible = false;
        Panel3.Visible = false;
        Panel4.Visible = false;
        string xm = TextBox1.Text;
        SqlConnection conn = new SqlConnection("server=.;database=tong ;pwd=sa;uid=sa");
        conn.Open();
        SqlDataAdapter sdr = new SqlDataAdapter();
        sdr.SelectCommand = new SqlCommand("select * from chengxu where name = " + "'" + xm + "'", conn);
        DataSet rs = new DataSet();
        sdr.Fill(rs, "cheng");
        if (rs.Tables["cheng"].Rows.Count == 0)
        {
            Response.Write("<script>alert('恭喜你，該用戶名可用！')</script>");
          
        }
        else
        {
            Response.Write("<script>alert('對不起，該用戶名已被使用，請重新輸入！')</script>");
          
            TextBox1.Text = " ";
        }


        conn.Close();
    }
    protected void Button3_Click1(object sender, EventArgs e)
    {
        
    }
    protected void TextBox6_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox7_TextChanged(object sender, EventArgs e)
    {

    }
    protected void Button3_Click2(object sender, EventArgs e)
    {
        Panel1.Visible = false;
        Panel2.Visible = false;
        Panel3.Visible = true;
        Panel4.Visible = false;
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox2_TextChanged(object sender, EventArgs e)
    {

    }
    protected void TextBox1_TextChanged1(object sender, EventArgs e)
    {

    }
    protected void Button5_Click1(object sender, EventArgs e)
    {
         Panel1.Visible =  true;  
        Panel2.Visible = false;
        Panel3.Visible = false;
        Panel4.Visible = false; 
    }
}