private void dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
//Edit a row
form.Clear();
form.id = dataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();
form.name = dataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();
form.reg = dataGridView.Rows[e.RowIndex].Cells[4].Value.ToString();
form.@class = dataGridView.Rows[e.RowIndex].Cells[5].Value.ToString();
form.section = dataGridView.Rows[e.RowIndex].Cells[6].Value.ToString();
form.UpdateInfo();
form.ShowDialog();
return;
}
if (e.ColumnIndex == 1)
{
//Delete a row
if (MessageBox.Show("Do you want to delete this student record..?", "Infromation", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information) == DialogResult.Yes)
{
DbStudent.DeleteStudent(dataGridView.Rows[e.RowIndex].Cells[2].Value.ToString());
Display();
}
return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim().Length < 3)
{
MessageBox.Show("Student name is empty ( > 3).");
return;
}
if (txtReg.Text.Trim().Length < 1)
{
MessageBox.Show("Student reg no is empty ( > 1).");
return;
}
if (txtClass.Text.Trim().Length == 0)
{
MessageBox.Show("Student class is empty ( > 0).");
return;
}
if (txtSection.Text.Trim().Length == 0)
{
MessageBox.Show("Student section is empty ( > 0).");
return;
}
if (btnSave.Text == "Save")
{
Student std = new Student(txtName.Text.Trim(), txtReg.Text.Trim(), txtClass.Text.Trim(), txtSection.Text.Trim());
DbStudent.AddStudent(std);
Clear();
}
if (btnSave.Text == "Update")
{
Student std = new Student(txtName.Text.Trim(), txtReg.Text.Trim(), txtClass.Text.Trim(), txtSection.Text.Trim());
DbStudent.UpdateStudent(std, id);
}
_parent.Display();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
DbStudent.DisplayAndSearch("SELECT ID, Name, Reg, Class, Section FROM student_table WHERE Name Like'%" + txtSearch.Text + "%'", dataGridView);
}
public void Display()
{
DbStudent.DisplayAndSearch("SELECT ID, Name, Reg, Class, Section FROM student_table", dataGridView);
}