//public void getMonthComboValues() //{ // String[] m = {"January","February","March","April","May","June","July","August","September","October","November","December"}; // MySqlConnection MyConn = ConnectionOld.getConnection(); // MySqlCommand SelectCommand = new MySqlCommand("select distinct Month from ot;", MyConn); // MySqlDataReader MyReader; // MyConn.Open(); // MyReader = SelectCommand.ExecuteReader(); // while (MyReader.Read()) // { // String mon = MyReader.GetString("Month"); // for (int i = 0; i < m.Length; i++) // { // if (mon != m[0]) // { // combo_Month.Items.Add(mon); // } // } // } //} public void getDetails() { MySqlConnection MyConn = ConnectionOld.getConnection(); MySqlCommand SelectCommand = new MySqlCommand("select * from itp.employee where EmpId = '" + Connection.getUserIdFromConnectionString() + "' ;", MyConn); MySqlDataReader MyReader; MyConn.Open(); MyReader = SelectCommand.ExecuteReader(); while (MyReader.Read()) { Emp_txt.Text = MyReader.GetInt32("EmpId").ToString(); First_txt.Text = MyReader.GetString("FirstName"); Last_txt.Text = MyReader.GetString("LastName"); dateTimePicker1.Text = MyReader.GetString("DOB"); if ((MyReader.GetString("Nationality") == "SriLankan")) { combo_Nat.Text = "SriLankan"; } else { combo_Nat.Text = "Foreigner"; Nat_txt.Text = MyReader.GetString("Nationality"); } NIC_txt.Text = MyReader.GetString("NIC"); Add_txt.Text = MyReader.GetString("Address"); Email_txt.Text = MyReader.GetString("Email"); Mob_txt.Text = MyReader.GetString("MobileNo"); Posi_combo.Text = MyReader.GetString("Position"); Dep_txt.Text = MyReader.GetString("DepId"); textBox5.Text = MyReader.GetDouble("BasicSalary").ToString(); String gender = MyReader.GetChar("Gender").ToString(); if (gender == "M") { radioButton1.Checked = true; } else { radioButton2.Checked = true; } } }