private void btn_overview_Click(object sender, EventArgs e)
{
string empid2 = cb_emp.SelectedValue.ToString();
try
{
myconn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"UPDATE Temp_EmpID set TempEmpID=@empid where ID=@id";
cmd.Parameters.AddWithValue("@empid", empid2);
cmd.Parameters.AddWithValue("@id", 1);
cmd.Connection = myconn;
cmd.ExecuteNonQuery();
myconn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
myconn.Close();
}
Form_Overview f = new Form_Overview();
f.Show();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string empid2 = dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + string.Empty;
try
{
myconn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"UPDATE Temp_EmpID set TempEmpID=@empid where ID=@id";
cmd.Parameters.AddWithValue("@empid", empid2);
cmd.Parameters.AddWithValue("@id", 1);
cmd.Connection = myconn;
cmd.ExecuteNonQuery();
myconn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
myconn.Close();
}
Form_Overview f = new Form_Overview();
f.Show();
}
