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);
}
}
