private void button2_Click(object sender, EventArgs e)
{
if (cbDatabaza.SelectedItem.ToString() == "MSSQL")
{
string text1 = "";
string text2 = "";
text1 = "server="+db1Server.Text+";database="+db1Name.Text+";uid="+db1Username.Text+";pwd="+db1Pass.Text+";MultipleActiveResultSets=True;";
text2 = "server=" + db2Server.Text + ";database=" + db2Name.Text + ";uid=" + db2Username.Text + ";pwd=" + db2Pass.Text + ";MultipleActiveResultSets=True;";
ConnectionMSSQL con1 = new ConnectionMSSQL(text1);
ConnectionMSSQL con2 = new ConnectionMSSQL(text2);
if (com.createConnections(con1, con2))
{
MessageBox.Show("Connection succesfull");
DBsyncTreeview strom = com.vyrobStromA();
main.aktualizujIkonky(strom);
main.getTvDb1().Nodes.Add(strom);
DBsyncTreeview strom2 = com.vyrobStromB();
main.aktualizujIkonky(strom2);
main.getTvDb2().Nodes.Add(strom2);
this.Close();
}
else MessageBox.Show("Connection was not succesfull");
}
}
public bool vytvorMSSQLpripojenie(string connstring)
{
ConnectionMSSQL sqlPrip = new ConnectionMSSQL(connstring);
prip = sqlPrip;
if (sqlPrip.createConnection())
{
tabulky = sqlPrip.ReadTables();
procedury = sqlPrip.ReadProcedures();
funkcie = sqlPrip.ReadFunctions();
typy = sqlPrip.ReadTypes();
usery = sqlPrip.ReadUsers();
nameOfDatabase = sqlPrip.GetNameOfDB();
pripAktivne = true;
return true;
}
return false;
}