private void saveSetting()
{
if (cmbDB.EditValue == "")
{
MessageBox.Show("Silakan pilih database yang tersedia", "Data Transfer", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
cmbDB.Focus();
}
else
{
mod md = new mod();
md.setConString("server=" + txtServer.Text + "; port=" + txtPort.Text + "; username="******"; password="******"; database=" + cmbDB.EditValue + ";");
if (File.Exists(Directory.GetCurrentDirectory() + "\\config.xml"))
{
File.Delete(Directory.GetCurrentDirectory() + "\\config.xml");
}
createXML();
}
}
private Boolean cekKoneksi()
{
Boolean hasil = false;
mod md = new mod();
md.setConString("server=" + txtServer.Text + "; port=" + txtPort.Text + "; user id=" + txtUserName.Text + "; password="******"; database=information_schema");
conn = md.getConn();
sda = md.getSda();
comm = md.getComm();
try
{
conn.Open();
comm.Connection = conn;
comm.CommandText = "select schema_name DATABASE_LIST from schemata";
comm.CommandType = CommandType.Text;
comm.CommandTimeout = 1000;
DataSet ds = new DataSet();
sda.SelectCommand = comm;
sda.Fill(ds);
conn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
cmbDB.Properties.DataSource = ds.Tables[0].DefaultView;
cmbDB.Properties.DisplayMember = "DATABASE_LIST";
cmbDB.Properties.ValueMember = "DATABASE_LIST";
cmbDB.Enabled = true;
}
}
catch (MySqlException ex) {
MessageBox.Show(ex.Message);
MessageBox.Show("Koneksi gagal", "Data Transfer", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(hasil);
}
private void loadSetting()
{
String server = "", port = "", username = "", password = "", db = "";
XmlDocument doc = new XmlDocument();
doc.Load(Directory.GetCurrentDirectory() + "\\config.xml");
XmlNodeList list = doc.GetElementsByTagName("Connection");
if (list.Count > 0)
{
foreach (XmlNode nodeParent in list)
{
foreach (XmlNode nodeChild in nodeParent.ChildNodes)
{
switch (nodeChild.Name)
{
case "Server":
server = nodeChild.InnerText;
break;
case "Port":
port = nodeChild.InnerText;
break;
case "Username":
username = nodeChild.InnerText;
break;
case "Password":
password = nodeChild.InnerText;
break;
case "Database":
db = nodeChild.InnerText;
break;
default:
break;
}
;
}
}
}
try
{
myString = "server=" + server + "; port=" + port + "; username="******"; password="******"; database=" + db + ";";
md.setConString(myString);
conn = md.getConn();
comm = md.getComm();
sda = md.getSda();
conn.Open();
}
catch (MySqlException ex)
{
frmKoneksi konek = new frmKoneksi();
konek.ShowDialog();
}
finally {
conn.Close();
}
}
