?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace schoolManager
{
    public partial class xueshengguanli : Form
    {
        public xueshengguanli()
        {
            InitializeComponent();
        }

        private void button8_Click(object sender, EventArgs e)
        {
            //增加

        }

        private void button6_Click(object sender, EventArgs e)
        {
            //刪除
 
        }

        private void button7_Click(object sender, EventArgs e)
        {
            //更新

        }

        private void button9_Click(object sender, EventArgs e)
        {
            //查詢

        }

        private void button4_Click(object sender, EventArgs e)
        {
            //首記錄
        }

        private void button5_Click(object sender, EventArgs e)
        {
            //尾記錄
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //上一條
        }

        private void button3_Click(object sender, EventArgs e)
        {
            //下一條
        }

        private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {
        }

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
        }

        private void xueshengguanli_Load(object sender, EventArgs e)
        {
            loadxianzhen();           
        }
        private void loadxianzhen()
        {
            string xiangzhenname = "select xiangzhenmingcheng from xiangzhen";
            DataMessager data = new DataMessager(Application.StartupPath);
            DataTable mytable = data.query(xiangzhenname, "xiangzhen");
            for (int i = 0; i < mytable.Rows.Count; i++)
            {
                this.comboBox4.Items.Add(mytable.Rows[i].ItemArray[0].ToString());
            }
        }

        private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.comboBox5.Items.Clear();
            string xiangzhenname = "select xuexiaomingcheng from xuexiaobiao where xiangzhen='" + comboBox4.SelectedItem.ToString() + "'";
            DataMessager data = new DataMessager(Application.StartupPath);
            DataTable mytable = data.query(xiangzhenname, "xuexiaobiao");
            for (int i = 0; i < mytable.Rows.Count; i++)
            {
                this.comboBox5.Items.Add(mytable.Rows[i].ItemArray[0].ToString());
            }
        }

        private void comboBox5_SelectedValueChanged(object sender, EventArgs e)
        {
            string xiangzhenname = "select xuexiaodaima from xuexiaobiao where xuexiaomingcheng='" + comboBox5.SelectedItem.ToString() + "'";
            DataMessager data = new DataMessager(Application.StartupPath);
            DataTable mytable = data.query(xiangzhenname, "xuexiaobiao");
            this.textBox7.Text = mytable.Rows[0].ItemArray[0].ToString();
        }

    }
}