private void btnKonto_Click(object sender, EventArgs e) { //Now Year string Jahrr = DateTime.Now.Year.ToString(); //Check if A DNr exist in db Table Stundenliste_konto string DNrForKonto = this.comboDNr.SelectedItem.ToString(); //DateTime Now DateTime dateTime = DateTime.Now; DateTime nowTime = Convert.ToDateTime(dateTime); try //stundenliste_konto { string Query = "select * from um_db.stundenliste_konto where DNr='" + DNrForKonto + "' and Jahr='" + Jahrr + "';"; MySqlConnection conDataBase = new MySqlConnection(constring); MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase); MySqlDataReader myReader; //Open Connection conDataBase.Open(); myReader = cmdDataBase.ExecuteReader(); if (myReader.HasRows) { while (myReader.Read()) { //Show Konto form Stundenliste_Konto std_konto = new Stundenliste_Konto(); std_konto.txtDNr.Text = this.comboDNr.SelectedItem.ToString(); std_konto.txtVorname.Text = this.txtVorname.Text; std_konto.txtNachname.Text = this.txtNachname.Text; std_konto.txtAktualisiert.Text = myReader.GetString("Datum_Aktualisiert"); std_konto.txtKontostand.Text = myReader.GetString("Kontostand"); std_konto.ShowDialog(); } } //Close Connection conDataBase.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Stundenliste_Konto_Report_Load(object sender, EventArgs e) { Stundenliste_Konto std_konto = (Stundenliste_Konto)Application.OpenForms["Stundenliste_Konto"]; //Convert Kontostand textbox to integer int intDNr; intDNr = Convert.ToInt32(std_konto.txtDNr.Text); intDNr = int.Parse(std_konto.txtDNr.Text); string txtJahr = std_konto.comboJahr.SelectedItem.ToString(); // TODO: This line of code loads data into the 'um_db_DataSet.stundenliste_konto' table. You can move, or remove it, as needed. this.stundenliste_kontoTableAdapter.Fill(this.um_db_DataSet.stundenliste_konto, intDNr, txtJahr); // TODO: This line of code loads data into the 'um_db_DataSet.einstellungen_firma' table. You can move, or remove it, as needed. this.einstellungen_firmaTableAdapter.Fill(this.um_db_DataSet.einstellungen_firma); this.reportViewer1.RefreshReport(); }