Ejemplo n.º 1
0
        private void add_btn_Click(object sender, EventArgs e)
        {
            Add_Update_Lecturer add_stud_lecturer_frm = new Add_Update_Lecturer();

            add_stud_lecturer_frm.update_btn.Visible = false;
            add_stud_lecturer_frm.add_btn.Visible    = true;
            add_stud_lecturer_frm.heading_lb.Text    = "Add Lecturer";
            add_stud_lecturer_frm.ShowDialog();
            this.lecturer_infoTableAdapter.Fill(this.ttms_dbDataSet1.lecturer_info);
        }
Ejemplo n.º 2
0
        private void lecturer_info_table_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            databaseConnection.Open();
            MySqlCommand cmd1 = new MySqlCommand("Select id from lecturer_info where lecturer_id = '" + this.lecturer_info_table.CurrentRow.Cells[0].Value.ToString() + "'", databaseConnection);
            int          id   = Convert.ToInt32(cmd1.ExecuteScalar());

            databaseConnection.Close();

            if (e.ColumnIndex == 4)
            {
                string edit = "edit";
                Add_Update_Lecturer add_stud_lecturer_frm = new Add_Update_Lecturer(id, this.lecturer_info_table.CurrentRow.Cells[2].Value.ToString(), edit);

                add_stud_lecturer_frm.lect_reg_textbox.Text    = this.lecturer_info_table.CurrentRow.Cells[0].Value.ToString();
                add_stud_lecturer_frm.lect_name_textbox.Text   = this.lecturer_info_table.CurrentRow.Cells[1].Value.ToString();
                add_stud_lecturer_frm.lect_email_textbox.Text  = this.lecturer_info_table.CurrentRow.Cells[2].Value.ToString();
                add_stud_lecturer_frm.lect_mobile_textbox.Text = this.lecturer_info_table.Rows[e.RowIndex].Cells[3].Value.ToString();

                add_stud_lecturer_frm.update_btn.Visible = true;
                add_stud_lecturer_frm.add_btn.Visible    = false;
                add_stud_lecturer_frm.heading_lb.Text    = "Edit Lecturer";
                add_stud_lecturer_frm.ShowDialog();

                this.lecturer_infoTableAdapter.Fill(this.ttms_dbDataSet1.lecturer_info);
            }
            else if (e.ColumnIndex == 5)
            {
                if (MessageBox.Show("Are you sure want to delete this record?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    databaseConnection.Open();
                    DataGridViewRow row = lecturer_info_table.Rows[e.RowIndex];
                    MySqlCommand    cmd = new MySqlCommand("Delete from lecturer_info where lecturer_id = '" + row.Cells[0].Value.ToString() + "'", databaseConnection);
                    cmd.ExecuteNonQuery();

                    //remove from datatable
                    lecturerinfoBindingSource.RemoveCurrent();
                    //refresh table
                    this.lecturer_infoTableAdapter.Fill(this.ttms_dbDataSet1.lecturer_info);
                    databaseConnection.Close();
                }
            }
        }