private void button1_Click(object sender, RoutedEventArgs e) { try { MySqlCommand cmd = MainWindow.conn.CreateCommand(); cmd.CommandText = "select * from info"; MySqlDataAdapter adap = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adap.Fill(ds); MainWindow.ilist.Clear(); foreach (DataRow r in ds.Tables[0].Rows) { Info tmp = new Info(); tmp.sid = r["sid"].ToString(); tmp.cid = r["cid"].ToString(); tmp.year = r["year"].ToString(); tmp.score = r["score"].ToString(); MainWindow.ilist.Add(tmp); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } adminWindow adWindow = new adminWindow(); adWindow.f = 3; adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "学号", Binding = new Binding("sid") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "课程编号", Binding = new Binding("cid") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "选课年份", Binding = new Binding("year") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "成绩", Binding = new Binding("score") }); adWindow.dataGrid.ItemsSource = MainWindow.ilist; adWindow.textBlock1.Text = "学号搜索"; adWindow.textBox.Focus(); adWindow.ShowDialog(); }
private void button2_Click(object sender, RoutedEventArgs e)//课程信息管理 { try { MySqlCommand cmd = MainWindow.conn.CreateCommand(); cmd.CommandText = "select * from course"; MySqlDataAdapter adap = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adap.Fill(ds); MainWindow.clist.Clear(); foreach (DataRow r in ds.Tables[0].Rows) { Course tmp = new Course(); tmp.cid = r["cid"].ToString(); tmp.cname = r["cname"].ToString(); tmp.teacher = r["teacher"].ToString(); tmp.credit = r["credit"].ToString(); tmp.minage = r["minage"].ToString(); tmp.cancelyear = r["cancelyear"].ToString(); MainWindow.clist.Add(tmp); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } adminWindow adWindow = new adminWindow(); adWindow.f = 2; adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "课程编号", Binding = new Binding("cid") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "课程名称", Binding = new Binding("cname") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "教师姓名", Binding = new Binding("teacher") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "学分", Binding = new Binding("credit") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "适合年级", Binding = new Binding("minage") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "取消年份", Binding = new Binding("cancelyear") }); adWindow.dataGrid.ItemsSource = MainWindow.clist; adWindow.textBlock1.Text = "课程名搜索"; adWindow.textBox.Focus(); adWindow.ShowDialog(); }
private void button_Click(object sender, RoutedEventArgs e)//学生信息管理 { try { MySqlCommand cmd = MainWindow.conn.CreateCommand(); cmd.CommandText = "select * from student"; MySqlDataAdapter adap = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adap.Fill(ds); MainWindow.slist.Clear(); foreach (DataRow r in ds.Tables[0].Rows) { Student tmp = new Student(); tmp.sid = r["sid"].ToString(); tmp.name = r["name"].ToString(); tmp.sex = r["sex"].ToString(); tmp.inage = r["inage"].ToString(); tmp.inyear = r["inyear"].ToString(); tmp.cls = r["cls"].ToString(); MainWindow.slist.Add(tmp); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } adminWindow adWindow = new adminWindow(); adWindow.f = 1; adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "学号", Binding = new Binding("sid") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "姓名", Binding = new Binding("name") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "性别", Binding = new Binding("sex") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "入学年龄", Binding = new Binding("inage") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "入学年份", Binding = new Binding("inyear") }); adWindow.dataGrid.Columns.Add(new DataGridTextColumn() { Header = "班级", Binding = new Binding("cls") }); adWindow.dataGrid.ItemsSource = MainWindow.slist; adWindow.textBlock1.Text = "姓名搜索"; adWindow.textBox.Focus(); adWindow.ShowDialog(); }