protected void scheduleMatch(object sender, EventArgs e)
    {
        //Validation on Dropdown
        if (HomeClubdDropdown.SelectedItem.Text == AwayClubDropdown.SelectedItem.Text)
        {
            ErrorOutput.Text = "Home and Away Cannot be same";
        }
        else
        {
            ErrorOutput.Text = "";

            //Validation on Calendar Selection
            if (DateSelectionCalander.SelectedDate == Convert.ToDateTime("1/1/0001 12:00:00 AM"))
            {
                ErrorOutput.Text = "Select Date";
            }
            else
            {
                //Insert into Database
                comm = new SqlCommand("INSERT INTO matches values(@box1, @box2, @date,@homeid,@awayid)", conn);
                comm.Parameters.Add("@date", System.Data.SqlDbType.VarChar);
                comm.Parameters["@date"].Value = DateSelectionCalander.SelectedDate.ToShortDateString();
                comm.Parameters.Add("@box1", System.Data.SqlDbType.VarChar);
                comm.Parameters["@box1"].Value = HomeClubdDropdown.SelectedItem.Text;
                comm.Parameters.Add("@box2", System.Data.SqlDbType.VarChar);
                comm.Parameters["@box2"].Value = AwayClubDropdown.SelectedItem.Text;
                comm.Parameters.Add("@homeid", System.Data.SqlDbType.VarChar);
                comm.Parameters["@homeid"].Value = HomeClubdDropdown.SelectedValue;
                comm.Parameters.Add("@awayid", System.Data.SqlDbType.VarChar);
                comm.Parameters["@awayid"].Value = AwayClubDropdown.SelectedValue;
                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();

                //Get Matches Again from Database after Insertion of a Match
                comm = new SqlCommand("SELECT * FROM matches", conn);
                conn.Open();
                reader = comm.ExecuteReader();
                GridViewFixtures.DataSource = reader;
                GridViewFixtures.DataBind();
                reader.Close();
                conn.Close();
            }
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        BindList();

        // Do not Load DropDown Data if the Request is Postback
        if (!IsPostBack)
        {
            ErrorOutput.Text = "Both Home and Away Team Cannot be same";

            comm = new SqlCommand("SELECT * FROM Clubs ", conn);
            conn.Open();
            reader = comm.ExecuteReader();
            HomeClubdDropdown.DataSource     = reader;
            HomeClubdDropdown.DataValueField = "registration_number";
            HomeClubdDropdown.DataTextField  = "name";
            HomeClubdDropdown.DataBind();
            reader.Close();
            conn.Close();
            comm = new SqlCommand("SELECT * FROM Clubs", conn);
            conn.Open();
            reader = comm.ExecuteReader();
            AwayClubDropdown.DataSource     = reader;
            AwayClubDropdown.DataValueField = "registration_number";
            AwayClubDropdown.DataTextField  = "name";
            AwayClubDropdown.DataBind();
            reader.Close();
            conn.Close();
        }

        // Load Matches on Every Request
        comm = new SqlCommand("SELECT * FROM matches", conn);
        conn.Open();
        reader = comm.ExecuteReader();
        GridViewFixtures.DataSource = reader;
        GridViewFixtures.DataBind();
        reader.Close();
        conn.Close();
    }