private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int indexrow;
indexrow = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[indexrow];
//MessageBox.Show(row.Cells[0].Value.ToString());
employeeID = Convert.ToInt32(row.Cells[0].Value.ToString());
editEmployee eEmployee = new editEmployee();
eEmployee.employeeID = employeeID;
try
{
string query = "SELECT name, address, nic, age, hiredate, status, deptid, desigid, contactNo, basicpay FROM tblemp WHERE empid=" + employeeID + ";";
SQLiteCommand myCommand = new SQLiteCommand(query, db.myConnection);
db.OpenConnection();
SQLiteDataReader result = myCommand.ExecuteReader();
// if (result.HasRows)
//{
while (result.Read())
{
//s=result["Name"];
eEmployee.textBox2.Text = result.GetString(0); //name
eEmployee.textBox4.Text = result.GetString(1); //address
eEmployee.textBox10.Text = result.GetString(2); //nic
eEmployee.textBox3.Text = Convert.ToString(result.GetInt32(3)); //age
eEmployee.dateTimePicker1.Value = DateTime.Parse(result.GetString(4)); //hiredate
eEmployee.comboBox1.Text = result.GetString(5); //status
deptID = result.GetInt32(6); //deptid
desigID = result.GetInt32(7); //desigid
eEmployee.textBox9.Text = Convert.ToString(result.GetInt32(8)); //contactNo
eEmployee.textBox7.Text = Convert.ToString(result.GetDouble(9)); //basicpay
eEmployee.textBox6.Text = departmentName(deptID);
eEmployee.textBox8.Text = designationName(desigID);
//translatedBy = result.GetDouble(18); //translatedBy
// MessageBox.Show(Convert.ToString(result.GetDouble(9)));
}
db.CloseConnection();
eEmployee.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void editbboxEmployee()
{
DataGridViewRow row = dataGridView1.SelectedRows[0];
employeeID = Convert.ToInt32(row.Cells[0].Value.ToString());
editEmployee eEmployee = new editEmployee();
eEmployee.employeeID = employeeID;
try
{
string query = "SELECT name, address, nic, age, hiredate, status, deptid, desigid, contactNo, basicpay FROM tblemp WHERE empid=" + employeeID + ";";
SQLiteCommand myCommand = new SQLiteCommand(query, db.myConnection);
db.OpenConnection();
SQLiteDataReader result = myCommand.ExecuteReader();
while (result.Read())
{
eEmployee.textBox2.Text = result.GetString(0); //name
eEmployee.textBox4.Text = result.GetString(1); //address
eEmployee.textBox10.Text = result.GetString(2); //nic
eEmployee.textBox3.Text = Convert.ToString(result.GetInt32(3)); //age
eEmployee.dateTimePicker1.Value = DateTime.Parse(result.GetString(4)); //hiredate
eEmployee.comboBox1.Text = result.GetString(5); //status
deptID = result.GetInt32(6); //deptid
desigID = result.GetInt32(7); //desigid
eEmployee.textBox9.Text = Convert.ToString(result.GetInt32(8)); //contactNo
eEmployee.textBox7.Text = Convert.ToString(result.GetDouble(9)); //basicpay
eEmployee.textBox6.Text = departmentName(deptID);
eEmployee.textBox8.Text = designationName(desigID);
}
db.CloseConnection();
eEmployee.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}