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