private void điểmDanhToolStripMenuItem_Click(object sender, EventArgs e) { connect = cn.getConnect(); connect.Open(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.Connection = connect; string text = "", sql = ""; TreeNode theNode = this.TvDanhSachLop.SelectedNode; int tag = 0; if (theNode.Tag == "1") { sql = "select MaLop from Lop where TenLop= N'" + theNode.Text + "'"; tag = 1; } else if (theNode.Tag == "2") { sql = "select MaLop from LopHocPhan where TenLop= N'" + theNode.Text + "'"; tag = 2; } else { MessageBox.Show("Bạn chưa chọn lớp cần điểm danh!", "Thông báo"); return; } //string str = "select from SinhVien sv, " + tmp + " lop where sv.MaLop = TenLop= N'" + theNode.Text + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, connect); DataTable tb = new DataTable();// cn.getTable(sql); da.Fill(tb); text = tb.Rows[0][0].ToString(); connect.Close(); frmDiemDanh frm = new frmDiemDanh(text, tag); // text ma lop frm.ShowDialog(); dataGridView1.DataSource = getTable(theNode.Text, Convert.ToInt16(theNode.Tag));//cn.getTable(sql); color(); }
private void điểmDanhToolStripMenuItem_Click(object sender, EventArgs e) { frmDiemDanh frm = new frmDiemDanh(); frm.ShowDialog(); }