private void Employees_Load(object sender, EventArgs e) { FormBorderStyle = FormBorderStyle.None; WindowState = FormWindowState.Maximized; TopMost = false; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 10); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; Employeesdb edb = new Employeesdb(); dataGridView1.DataSource = edb.selectall(); }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { try { int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; Employeesdb edb = new Employeesdb(); DataTable dt = edb.get(id); textBox2.Text = dt.Rows[0]["ID"].ToString().Trim(); textBox1.Text = dt.Rows[0]["Name"].ToString().Trim(); textBox6.Text = dt.Rows[0]["Father Name"].ToString().Trim(); textBox3.Text = dt.Rows[0]["Phone Number"].ToString().Trim(); textBox4.Text = dt.Rows[0]["Address"].ToString().Trim(); textBox7.Text = dt.Rows[0]["Designation"].ToString().Trim(); textBox5.Text = dt.Rows[0]["Salary"].ToString().Trim(); } catch (Exception e1) { //MessageBox.Show(e1.Message); } }
private void dataGridView1_MouseClick(object sender, MouseEventArgs e) { try { int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; Employeesdb edb = new Employeesdb(); DataTable dt = edb.get(id); textBox2.Text = dt.Rows[0]["Emp_id"].ToString().Trim(); textBox1.Text = dt.Rows[0]["Name"].ToString().Trim(); textBox6.Text = dt.Rows[0]["father_name"].ToString().Trim(); textBox3.Text = dt.Rows[0]["Phone_num"].ToString().Trim(); textBox4.Text = dt.Rows[0]["Address"].ToString().Trim(); textBox7.Text = dt.Rows[0]["Designation"].ToString().Trim(); textBox5.Text = dt.Rows[0]["emp_salary"].ToString().Trim(); } catch (Exception e1) { //MessageBox.Show(e1.Message); } }