public String OpenConnection(string dateiname)
{
try
{
MySQLConn conparameters = ReadXML(dateiname);
string connstring = "";
if (conparameters.ssl == true)
{
connstring = string.Format("Server={0}; database={1}; UID={2}; password={3};", conparameters.IP, conparameters.Datenbankname, conparameters.benutzer, conparameters.passwort);
}
else
{
connstring = string.Format("Server={0}; database={1}; UID={2}; password={3}; SslMode=None;", conparameters.IP, conparameters.Datenbankname, conparameters.benutzer, conparameters.passwort);
}
connection = new MySqlConnection();
connection.ConnectionString = connstring;
connection.Open();
return(conparameters.Datenbankname);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return("");
}
}
public static void WriteXML(string ip, string benutzer, string passwort, string datenbankname, bool checkstate, string dateiname)
{
MySQLConn verbindungsdatei = new MySQLConn();
verbindungsdatei.IP = ip;
verbindungsdatei.benutzer = benutzer;
verbindungsdatei.passwort = passwort;
verbindungsdatei.Datenbankname = datenbankname;
verbindungsdatei.ssl = checkstate;
System.Xml.Serialization.XmlSerializer writer =
new System.Xml.Serialization.XmlSerializer(typeof(MySQLConn));
System.IO.FileStream file = System.IO.File.Create(dateiname);
writer.Serialize(file, verbindungsdatei);
file.Close();
}
public MySQLConn ReadXML(string dateiname)
{
try
{
MySQLConn verbindungsdatei = new MySQLConn();
System.Xml.Serialization.XmlSerializer reader = new System.Xml.Serialization.XmlSerializer(typeof(MySQLConn));
System.IO.FileStream file = System.IO.File.OpenRead(dateiname);
verbindungsdatei = (MySQLConn)reader.Deserialize(file);
file.Close();
datenbankname = verbindungsdatei.Datenbankname;
return(verbindungsdatei);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(null);
}
}
