private void cmdSave_Click(object sender, EventArgs e)
{
TstServerName = txtServerHost.Text;
TstPortName = txtPort.Text;
TstUserName = txtUserName.Text;
TstPwd = txtPassword.Text;
TstDBName = txtDatabase.Text;
try
{
SQLConn.conn.ConnectionString = "Server = '" + TstServerName + "'; " + "Port = '" + TstPortName + "'; " + "Database = '" + TstDBName + "'; " + "user id = '" + TstUserName + "'; " + "password = '******'";
SQLConn.conn.Open();
SQLConn.DBName = txtDatabase.Text;
SQLConn.ServerName = txtServerHost.Text;
SQLConn.UserName = txtUserName.Text;
SQLConn.PortName = txtPort.Text;
SQLConn.Pwd = txtPassword.Text;
SQLConn.SaveData();
this.Close();
}
catch
{
MessageBox.Show("The system failed to establish a connection", "Database Settings", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
SQLConn.DisconnMy();
//save database
}
