private void Form5_Load(object sender, EventArgs e) { comboBox1.SelectedIndex = 0; DataSet dataSet1 = dbw1.ReadDataBaseToDataSet("QUIM", "select progName, CreationD_rep, percofend from Report where progName LIKE '" + g_reportName + "'"); this.Text = dataSet1.Tables[0].Rows[0].ItemArray[0].ToString() + " " + dataSet1.Tables[0].Rows[0].ItemArray[1].ToString(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { dataSet1 = dbw1.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select m.name_met from metric m, profile p, profile_metric pm where p.id_prof = pm.id_prof and m.id_met = pm.id_met and p.name_prof like '" + comboBox1.GetItemText(comboBox1.Items[comboBox1.SelectedIndex]) + "'"); foreach (int checkedItemIndex in checkedListBox1.CheckedIndices) { checkedListBox1.SetItemChecked(checkedItemIndex, false); } for (int i = 0; i < dataSet1.Tables[0].Rows.Count; i++) { checkedListBox1.SetItemChecked(checkedListBox1.Items.IndexOf(dataSet1.Tables[0].Rows[i].ItemArray[0].ToString()), true); } }
private void checkBox1_CheckedChanged(object sender, EventArgs e) { if (checkBox1.Checked) { comboBox1.Enabled = true; comboBox1_SelectedIndexChanged(comboBox1, null); } else { foreach (int checkedItemIndex in checkedListBox1.CheckedIndices) { checkedListBox1.SetItemChecked(checkedItemIndex, false); } dataSet1 = dbw1.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select m.name_met from metric m, metrInRep mr, report r where r.id_rep = mr.id_rep and m.id_met = mr.id_met and r.progName like '" + comboBox2.GetItemText(comboBox2.Items[lastSelect]) + "'"); for (int i = 0; i < dataSet1.Tables[0].Rows.Count; i++) { checkedListBox1.SetItemChecked(checkedListBox1.Items.IndexOf(dataSet1.Tables[0].Rows[i].ItemArray[0].ToString()), true); } comboBox1.Enabled = false; } }
private void Form6_Load(object sender, EventArgs e) { UseWaitCursor = true; BindingSource bindingSource1 = new BindingSource(); DataSet dataSet1 = dbw1.ReadDataBaseToDataSet("QUIM", "select progName, CreationD_rep, percofend from Report where progName LIKE '" + g_reportName + "'"); this.Text = dataSet1.Tables[0].Rows[0].ItemArray[0].ToString() + " " + dataSet1.Tables[0].Rows[0].ItemArray[1].ToString(); dataSet21 = new DataSet(); adapter = new SqlDataAdapter(); dataSet11 = dbw1.ReadDataBaseToDataSet("QUIM", "select m.name_met, mr.MinValue, mr.Curvalue, MaxValue, mr.Rate, mr.Value, mr.Type from metric m, MetrInRep mr where m.id_met = mr.id_met and mr.id_rep in (select r.id_rep from report r where r.progName like '" + g_reportName + "')"); dataGridView8.DataSource = dataSet11.Tables[0]; dataGridView8.Columns[0].HeaderText = "NAME METRIC:"; dataGridView8.Columns[0].ReadOnly = true; dataGridView8.Columns[1].HeaderText = "MIN VALUE:"; dataGridView8.Columns[2].HeaderText = "CUR VALUE:"; dataGridView8.Columns[3].HeaderText = "MAX VALUE:"; dataGridView8.Columns[4].HeaderText = "RATE:"; dataGridView8.Columns[5].HeaderText = "VALUE:"; dataGridView8.Columns[5].ReadOnly = true; dataGridView8.Columns[6].HeaderText = "TYPE:"; adapter = dbw1.fillDataAdapter(SqlConnectionParametrs.DataBaseName, "select mr.MinValue, mr.Curvalue, MaxValue, mr.Rate, mr.Value, mr.Type from MetrInRep mr where mr.id_rep in (select r.id_rep from report r where r.progName like '" + g_reportName + "')"); cmdBuilder = new SqlCommandBuilder(adapter); UseWaitCursor = false; dataGridView8_Resize(dataGridView8, null); try { dataSet21 = dataSet11.GetChanges(); if (dataSet21 != null) { adapter.Update(dataSet21); } } catch (Exception) { dataSet21 = null; } }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { //dbworker.Attatch_DataBase(SqlConnectionParametrs.DataBaseName, @"F:\TEMP\123\QUIM.mdf", @"F:\TEMP\123\QUIM_log.ldf"); //TEMP ATTATCHING!!!!!!!!!!!!!!!!!!!!! DBwork dbw1 = new DBwork("QUIM", ""); DBwork dbw2 = new DBwork("QUIM", "SQLEXPRESS"); try { dbw1.ReadDataBaseToDataSet("master", "select * from spt_monitor"); SqlConnectionParametrs.DataBaseServiceName = ""; } catch (Exception) { try { dbw2.ReadDataBaseToDataSet("master", "select * from spt_monitor"); SqlConnectionParametrs.DataBaseServiceName = "SQLEXPRESS"; } catch (Exception) { throw new Exception("Data base server 2005 not found."); } } dbworker = new DBwork(SqlConnectionParametrs.DataBaseName, SqlConnectionParametrs.DataBaseServiceName); //attatching db dbworker.Attatch_DataBase(SqlConnectionParametrs.DataBaseName, Environment.CurrentDirectory + "\\QUIM.mdf", Environment.CurrentDirectory + "\\QUIM_log.ldf"); //checking struck of db dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from factor"); dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from criteria"); dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from metric"); dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from profile"); dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from report"); dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from profile_metric"); dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from metrInRep"); dbworker.ReadDataBaseToDataSet(SqlConnectionParametrs.DataBaseName, "select * from Factor_Criteria"); //collect garb. after temp selecting GC.Collect(); }