private void btQuery_Click(object sender, EventArgs e) { string sql = "SELECT dname 系名称, cspec 专业名称, sname 学生名字" + " FROM students s, classes c, departments d" + " WHERE s.cno = c.cno AND c.dno = d.dno"; if (checkBox1.Checked) { string dname = comboBox1.SelectedItem.ToString(); sql += " AND dname = '" + dname + "'"; } if (checkBox2.Checked) { string cspec = comboBox2.SelectedItem.ToString(); sql += " AND cspec = '" + cspec + "'"; //string.Format("'{0}' ", comboBox2.SelectedItem.ToString()); } if (checkBox3.Checked) { string sname = textBox1.Text.Trim(); sql += " AND sname LIKE '%" + sname + "%'"; } sql += " ORDER BY d.dno desc, c.cno, s.sno desc"; //MessageBox.Show(sql); //Console.WriteLine(sql); DBUtil.fillListView(lvShow, sql); }
private void btQuery_Click(object sender, EventArgs e) { string sql = "SELECT dname 系名称, COUNT(*) 人数" + " FROM departments d, classes c, students s" + " WHERE d.dno = c.dno AND s.cno = c.cno" + " GROUP BY dname"; if (radioButton2.Checked) { sql = "SELECT cyear 入学年份, COUNT(*) 人数" + " FROM classes c, students s" + " WHERE s.cno = c.cno" + " GROUP BY cyear"; } DBUtil.fillListView(lvShow, sql); }
void reLoad() { string sql = "SELECT sno AS 学号, sname AS 姓名, sdate AS 出生日期, cno AS 班号 FROM students"; DBUtil.fillListView(lvShow, sql); }