private void 查看ToolStripMenuItem_Click(object sender, EventArgs e) { if (dgv_tutors.SelectedRows.Count > 0) { string tutors_num = dgv_tutors.SelectedRows[0].Cells[0].Value.ToString(); if (tutors_num != "") { string mysql = "SELECT 姓名 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string tutors_name = mydb.Returnafield(mysql); mysql = "SELECT 学号 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string student_num = mydb.Returnafield(mysql); mysql = "SELECT 院系专业 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string grade_subject = mydb.Returnafield(mysql); mysql = "SELECT 在读学位 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string tutors_degree = mydb.Returnafield(mysql); mysql = "SELECT 性别 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string sex = mydb.Returnafield(mysql); mysql = "SELECT 联系方式 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string phone = mydb.Returnafield(mysql); mysql = "SELECT 生源地 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string place = mydb.Returnafield(mysql); mysql = "SELECT 是否黑名单 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string blacklist = mydb.Returnafield(mysql); mysql = "SELECT 相关说明及监禁期 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string imprisonment = mydb.Returnafield(mysql); mysql = "SELECT 重要备注 FROM [Tutors] WHERE 教员编号='" + tutors_num + "'"; string remarks = mydb.Returnafield(mysql); Students_check myform = new Students_check(tutors_num, tutors_name, student_num, grade_subject, tutors_degree, sex, phone, place, blacklist, imprisonment, remarks); myform.Owner = this; myform.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; myform.Show(); } } }
private void 查看ToolStripMenuItem_Click(object sender, EventArgs e) { if (dgv_blacklist.SelectedRows.Count > 0) { string tutors_num = dgv_blacklist.SelectedRows[0].Cells[1].Value.ToString(); string tutors_name = dgv_blacklist.SelectedRows[0].Cells[2].Value.ToString(); string student_num = dgv_blacklist.SelectedRows[0].Cells[3].Value.ToString(); string grade_subject = dgv_blacklist.SelectedRows[0].Cells[4].Value.ToString(); string tutors_degree = dgv_blacklist.SelectedRows[0].Cells[5].Value.ToString(); string sex = dgv_blacklist.SelectedRows[0].Cells[6].Value.ToString(); string phone = dgv_blacklist.SelectedRows[0].Cells[7].Value.ToString(); string place = dgv_blacklist.SelectedRows[0].Cells[8].Value.ToString(); string blacklist = dgv_blacklist.SelectedRows[0].Cells[9].Value.ToString(); string imprisonment = dgv_blacklist.SelectedRows[0].Cells[10].Value.ToString(); string remarks = dgv_blacklist.SelectedRows[0].Cells[11].Value.ToString(); Students_check myform = new Students_check(tutors_num, tutors_name, student_num, grade_subject, tutors_degree, sex, phone, place, blacklist, imprisonment, remarks); myform.Owner = this; myform.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; myform.Show(); } }