chaxuntongji.cs

data structure c 学校管理系统

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 chaxuntongji : Form
    {
        public chaxuntongji()
        {
            InitializeComponent();
        }

        private void chaxuntongji_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.comboBox1.Items.Add(mytable.Rows[i].ItemArray[0].ToString());
            }
        }

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

        private void button1_Click(object sender, EventArgs e)
        {
            this.comboBox1.SelectedIndex = -1;
            this.comboBox2.SelectedIndex = -1;
            this.comboBox3.SelectedIndex = -1;
        }
    }
}