private void btnMentes_Click(object sender, EventArgs e) { DataRow row = ds.Tables[0].NewRow(); row[0] = txtID.Text; row[1] = txtNev.Text; row[2] = aktiv(); ds.Tables[0].Rows.Add(row); try { objConnect.UpdateDatabase(ds); MaxRows++; inc = MaxRows - 1; MessageBox.Show("Új beszallító elmentve"); } catch (Exception err) { MessageBox.Show(err.Message); } btnUj.Enabled = true; //btnNext.Enabled = true; //btnPrev.Enabled = true; comboBox1.Enabled = true; btnTorles.Enabled = true; btnMod.Enabled = true; btnMegse.Enabled = false; btnMentes.Enabled = false; combofill(); }
private void btnMentes_Click(object sender, EventArgs e) { DataRow row = ds.Tables[0].NewRow(); row[0] = txtID.Text; row[1] = txtEAN.Text; row[2] = txtNev.Text; row[3] = Arulhatoe(); row[4] = Rendelhetoe(); row[5] = comboBeszallito.SelectedItem.ToString(); ds.Tables[0].Rows.Add(row); try { objConnect.UpdateDatabase(ds); MaxRows++; inc = MaxRows - 1; MessageBox.Show("Új termék elmentve"); } catch (Exception err) { MessageBox.Show(err.Message); } BoltKapcsolat(); btnUj.Enabled = true; comboTermek.Enabled = true; btnTorles.Enabled = true; btnModosit.Enabled = true; btnMegse.Enabled = false; btnMentes.Enabled = false; combofill(); }
private void BoltKapcsolat() { try { DatabaseConnection objBoltok = new DatabaseConnection(); conTermek = Properties.Settings.Default.DatabaseConnectionString; objBoltok.connection_string = conTermek; objBoltok.Sql = "select * from bolt"; DataSet dsBoltok = objBoltok.GetConnection; int MaxRowsBoltok = dsBoltok.Tables[0].Rows.Count; objBoltok.Sql = "select * from bolt_termek"; DataSet dsKapcsolat = objBoltok.GetConnection; for (int i = 0; i < MaxRowsBoltok; i++) { DataRow boltRow = dsBoltok.Tables[0].Rows[i]; DataRow row = dsKapcsolat.Tables[0].NewRow(); row[0] = boltRow.ItemArray.GetValue(0).ToString(); row[1] = txtID.Text; row[2] = 0; dsKapcsolat.Tables[0].Rows.Add(row); } objBoltok.UpdateDatabase(dsKapcsolat); MessageBox.Show("Új termék hozzáadva a boltokhoz"); } catch (Exception err) { MessageBox.Show(err.Message); } }