private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { dbw1.ChangeDataInDataBase("QUIM", "insert into report (progName, PercOfEnd, CreationD_rep) values('" + textBox1.Text + "', 0.0, 2342645)"); for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++) { dbw1.ChangeDataInDataBase(SqlConnectionParametrs.DataBaseName, "insert into MetrInRep (id_rep, id_met) select (select id_rep from report where ProgName like '" + textBox1.Text + "'), (select id_met from metric where name_met like '" + checkedListBox1.CheckedItems[i].ToString() + "')"); } //dbw1.ReadDataBaseToDataSet(temp.name_db, "select * from factor, criteria, metric, profile, report"); }
private void button1_Click(object sender, EventArgs e) { Metrics = new String[checkedListBox1.CheckedItems.Count]; for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++) { Metrics[i] = checkedListBox1.CheckedItems[i].ToString(); } dbw1.ChangeDataInDataBase(SqlConnectionParametrs.DataBaseName, "update report set progName = '" + comboBox2.Text + "' where progName like '" + comboBox2.GetItemText(comboBox2.Items[lastSelect]) + "'"); dbw1.UpdateMetrics(comboBox2.Text, Metrics); this.Close(); }