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