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(); }