private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; if (selectedItem == 0) { studentId = Convert.ToInt32(row.Cells["id"].Value.ToString()); TB_studentNo.Text = row.Cells["studentNo"].Value.ToString(); TB_name.Text = row.Cells["name"].Value.ToString(); TB_lastName.Text = row.Cells["lastName"].Value.ToString(); TB_birthPlace.Text = row.Cells["birthPlace"].Value.ToString(); TB_birthYear.Text = row.Cells["birthYear"].Value.ToString(); } else if (selectedItem == 1) { TB_lessonsStudentNo.Text = row.Cells["studentNo"].Value.ToString(); if (row.Cells["bm100"].Value.ToString() == "1") { CLB_studentLessons.SetItemChecked(0, true); } if (row.Cells["bm200"].Value.ToString() == "1") { CLB_studentLessons.SetItemChecked(1, true); } if (row.Cells["bm300"].Value.ToString() == "1") { CLB_studentLessons.SetItemChecked(2, true); } } else if (selectedItem == 2) { updateResultGroup.Controls.Clear(); int i = 4; TB_resultsStudentNo.Text = row.Cells["studentNo"].Value.ToString(); while (i < 7) { if (row.Cells[i].Value.ToString() != "0") { row.HeaderCell.Value = "BM" + (i * 100 - 300).ToString(); Control[] objs = new Control[2]; Label side = new Label(); TextBox results = new TextBox(); objs[0] = side; objs[1] = results; side.Text = row.HeaderCell.Value.ToString(); side.Location = new Point(6, 63 + loc); results.Location = new Point(112, 60 + loc); results.Name = "TB_" + row.HeaderCell.Value.ToString(); updateResultGroup.Controls.AddRange(objs); loc += 30; } i++; } loc = 0; } } }
private void getInfo(int b) { string studentNo = ""; if (b != 0) { for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i][1].ToString() == TB_studentNo.Text) { studentNo = table.Rows[i][1].ToString(); TB_name.Text = table.Rows[i][2].ToString(); TB_lastName.Text = table.Rows[i][3].ToString(); TB_birthYear.Text = table.Rows[i][4].ToString(); TB_birthPlace.Text = table.Rows[i][5].ToString(); num = i; break; } } } else { if (num < table.Rows.Count && num >= 0) { studentNo = table.Rows[num][1].ToString(); TB_name.Text = table.Rows[num][2].ToString(); TB_lastName.Text = table.Rows[num][3].ToString(); TB_birthYear.Text = table.Rows[num][4].ToString(); TB_birthPlace.Text = table.Rows[num][5].ToString(); } } // Ders Kayıtlarını Al string query = "SELECT * FROM lessons WHERE studentNo = '" + studentNo + "'"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { if (read[2].ToString() == "1") { CLB_studentLessons.SetItemChecked(0, true); } if (read[3].ToString() == "1") { CLB_studentLessons.SetItemChecked(1, true); } if (read[4].ToString() == "1") { CLB_studentLessons.SetItemChecked(2, true); } } read.Close(); // Ders Kayıtlarını Al query = "SELECT * FROM examsResults WHERE studentNo = '" + studentNo + "'"; cmd.CommandText = query; read = cmd.ExecuteReader(); while (read.Read()) { TB_bm100.Text = read[2].ToString(); TB_bm200.Text = read[3].ToString(); TB_bm300.Text = read[4].ToString(); } conn.Close(); }