private void comboBox4_SelectedIndexChanged(object sender, EventArgs e) { string Constring = "datasource=localhost;port=3306;username=root;password="******"select * from youken_springs.employee where e_id ='" + comboBox4.Text + "';"; string quarry2 = "select * from youken_springs.job where e_id ='" + comboBox4.Text + "';"; MySqlConnection ConDataBase = new MySqlConnection(Constring); MySqlConnection ConDataBase2 = new MySqlConnection(Constring); MySqlCommand cmdDataBase = new MySqlCommand(quarry, ConDataBase); MySqlCommand cmdDataBase2 = new MySqlCommand(quarry2, ConDataBase2); MySqlDataReader MyReader; MySqlDataReader MyReader2; try { ConDataBase.Open(); MyReader = cmdDataBase.ExecuteReader(); /* IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true); * DateTime join_date = DateTime.ParseExact(txt_joinDate.Text, "dd/MM/yyyy", theCultureInfo); * DateTime today = DateTime.Now; * txt_wkdduration.Text = ((today - join_date).TotalDays).ToString();*/ //DateTime date = DateTime.ParseExact(this.Text, "dd/MM/yyyy", null)theCultureInfo while (MyReader.Read()) { txt_flname.Text = MyReader.GetString("e_full_name"); txt_add1.Text = MyReader.GetString("address_line1"); txt_add2.Text = MyReader.GetString("address_line2"); txt_addCity.Text = MyReader.GetString("city"); // txt_sal.Text = (MyReader["salary"].ToString()); lbl_em_id.Text = MyReader.GetUInt32("e_id").ToString(); lbl_pro_em_id.Text = MyReader.GetUInt32("e_id").ToString(); e_id = lbl_pro_em_id.Text; lbl_fullAdd.Text = txt_add1.Text + "," + "" + txt_add2.Text + "," + "" + txt_addCity.Text; } ConDataBase.Close(); ConDataBase2.Open(); MyReader2 = cmdDataBase2.ExecuteReader(); while (MyReader2.Read()) { txt_joinDate.Text = MyReader2.GetString("join_date"); txt_position.Text = MyReader2.GetString("designation"); } ConDataBase2.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void cmb_mat_name2_SelectedIndexChanged(object sender, EventArgs e) { string Constring = "datasource=localhost;port=3306;username=root;password="******"select * from youken_springs.meterial where meterial_name ='" + cmb_mat_name2.Text + "';"; MySqlConnection ConDataBase = new MySqlConnection(Constring); MySqlCommand cmdDataBase = new MySqlCommand(quarry, ConDataBase); MySqlDataReader MyReader; try { ConDataBase.Open(); MyReader = cmdDataBase.ExecuteReader(); while (MyReader.Read()) { lbl_mat_id2.Text = MyReader.GetUInt32("meterial_id").ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void cmb_product_name1_SelectedIndexChanged(object sender, EventArgs e) { string Constring = "datasource=localhost;port=3306;username=root;password="******"select * from youken_springs.products where name ='" + cmb_product_name1.Text + "';"; MySqlConnection ConDataBase = new MySqlConnection(Constring); MySqlCommand cmdDataBase = new MySqlCommand(quarry, ConDataBase); MySqlDataReader MyReader; try { ConDataBase.Open(); MyReader = cmdDataBase.ExecuteReader(); while (MyReader.Read()) { lbl_prduct_id1.Text = MyReader.GetUInt32("product_id").ToString(); lbl_des1.Text = MyReader.GetString("description"); lbl_unitP1.Text = MyReader.GetUInt32("unit_price").ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }