adminedit_3.aspx.cs

B/S asp.net的C#编的网站

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 ACMManage : System.Web.UI.Page
{
   
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }

    SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["constr"].ToString());


    protected void Serch_Click(object sender, EventArgs e)
    {
        string tableName;
        string factor;
        

        if (SerchTypeRadioBtn.Items[0].Selected)
        {
            tableName = "[Team]";
            factor = "[CSchoolName] LIKE '" + SerchText.Text.Trim() + "%'";
        }
        else
        {
            if (SerchTypeRadioBtn.Items[1].Selected)
            {
                tableName = "[Team]";
                factor = "[ESchoolName] LIKE '" + SerchText.Text.Trim() + "%'";
            }
            else
            {
                if (SerchTypeRadioBtn.Items[2].Selected)
                {
                    tableName = "[Team]";
                    factor = "[Lodging] = " + Convert.ToInt32(DomRadioBtn.SelectedValue);
                }
                else
                {
                    tableName = "[" + TSRadioBtn.SelectedValue + "]";
                    factor = "[Size] = '" + SizeRadionBtn.SelectedValue + "'";
                }
            }

        }
        string cmdString = "SELECT * FROM " + tableName + " WHERE " + factor;
        //SqlConnection myConncetion = new SqlConnection(ConfigurationManager.AppSettings["constr"].ToString());
        
        SqlDataAdapter da = new SqlDataAdapter(cmdString, myConnection);
        try
        {
            myConnection.Open();
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();

        }
        catch (SqlException sqlex)
        {
            Response.Write(sqlex.Message);
        }
        finally
        {
            myConnection.Close();
        }

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

    protected void SerchTypeRadioBtn_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (SerchTypeRadioBtn.Items[0].Selected || SerchTypeRadioBtn.Items[1].Selected)
            SerchText.Visible = true;
        else
            SerchText.Visible = false;
        SerchText.Text = null;
        if (SerchTypeRadioBtn.Items[2].Selected)
            DomRadioBtn.Visible = true;
        else
            DomRadioBtn.Visible = false;
        if (SerchTypeRadioBtn.Items[3].Selected)
            SizeRadionBtn.Visible = true;
        else
            SizeRadionBtn.Visible = false;
    }
    protected void DomRadioBtn_SelectedIndexChanged(object sender, EventArgs e)
    {

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

    }
    protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (SerchTypeRadioBtn.Items[0].Selected || SerchTypeRadioBtn.Items[1].Selected)
            SerchText.Visible = true;            
        else
            SerchText.Visible = false;
        SerchText.Text = null;
        if (SerchTypeRadioBtn.Items[2].Selected)
            DomRadioBtn.Visible = true;
        else
            DomRadioBtn.Visible = false;
        if (SerchTypeRadioBtn.Items[3].Selected)
        {
            SizeRadionBtn.Visible = true;
            TSRadioBtn.Visible = true;
        }
        else
        {
            SizeRadionBtn.Visible = false;
            TSRadioBtn.Visible = false;
        }
    }
    protected void Return_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/Function.aspx");
    }
    protected void StudentInf_Click(object sender, EventArgs e)
    {
        //SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["constr"].ToString());
        SqlDataAdapter da=new SqlDataAdapter("SELECT * FROM [Player]",myConnection);
        try
        {
            myConnection.Open();
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        catch (SqlException sqlEx)
        {
            Response.Write(sqlEx.Message);
        }
        finally
        {
            myConnection.Close();
        }
    }
    protected void TeacherInf_Click(object sender, EventArgs e)
    {
        //SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["constr"].ToString());
        SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Teacher]", myConnection);
        try
        {
            myConnection.Open();
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        catch (SqlException sqlEx)
        {
            Response.Write(sqlEx.Message);
        }
        finally
        {
            myConnection.Close();
        }
    }
    protected void TeamInf_Click(object sender, EventArgs e)
    {
        
        SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Team]", myConnection);
        try
        {
            myConnection.Open();
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        catch (SqlException sqlEx)
        {
            Response.Write(sqlEx.Message);
        }
        finally
        {
            myConnection.Close();
        }
    }

    protected void DeleteBtn_Click(object sender, EventArgs e)
    {
        //SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["constr"].ToString());
        myConnection.Open();
        string sql = "select * from [Team] where TeamID='" + DeleteItemText.Text + "'";
        SqlCommand cmd = new SqlCommand(sql, myConnection);
        SqlDataReader reader = cmd.ExecuteReader();

        try
        {
            if (reader.Read() == false) throw new NoTeamIDException();
            else
            {
                NoTeamErrLabel.Visible = false;
                myConnection.Close();
                myConnection.Open();
                sql = "delete from [Team] where TeamID='" + DeleteItemText.Text + "'";
                cmd = new SqlCommand(sql, myConnection);
                int i = 0;
                i = cmd.ExecuteNonQuery();
                myConnection.Close();

                Response.Redirect("TableSignup.aspx");
            }
        }

        catch (NoTeamIDException)
        {
            NoTeamErrLabel.Visible = true;
        }
    }


    class NoTeamIDException : ApplicationException { };
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {

    }
}