//筛选学生签到记录 private void toolStripButton7_Click(object sender, EventArgs e) { string option = ""; if (toolStripComboBox4.Text.Trim() != "") { option = " AND Sign.classId = " + Convert.ToInt32(toolStripComboBox4.Text.Trim()) + "AND ChooseCls.classId = " + Convert.ToInt32(toolStripComboBox4.Text.Trim()); DataTable dt = SignManager.DisplayDifferentSignUp(teacher.Id, option); dt.Columns[0].ColumnName = "签到编号"; dt.Columns[1].ColumnName = "学生学号"; dt.Columns[2].ColumnName = "学生姓名"; dt.Columns[3].ColumnName = "IP地址"; dt.Columns[4].ColumnName = "签到时间"; dt.Columns[5].ColumnName = "签到状态"; dataGridView3.DataSource = dt; } else { RefreshClassTable(); } }