private void button_testconnect_Click(object sender, EventArgs e)
{
if (checkBox_DBType.Checked == true)
{
VC_DB conn = new VC_DB();
try
{
conn.connect();
var reader = conn.getUser();
while (reader.Read())
{
comboBox_user.Items.Add(reader[0]);
}
MessageBox.Show("Connect to Database is Complated");
conn.getDBlog(richTextBox_log);
}
catch (Exception g)
{
MessageBox.Show(g.ToString());
}
}
//update database
//if (checkBox1.Checked = true)
//{
// string vcenter_ip = textBox_ServerIP.Text;
// string vcenter_user = textBox_User.Text;
// string vcenter_password = textBox_Password.Text;
// string vcenter_port = textBox_port.Text;
// string sql = string.Format("update vCenterDB set vcenter_ip='{0}',vcenter_user='******'," +
// "vcenter_password='******',vcenter_port='{3}' where id =1", vcenter_ip, vcenter_user, vcenter_password, vcenter_port);
// SQLiteOperation update = new SQLiteOperation();
// update.query(sql);
// SQLiteOperation setDF = new SQLiteOperation();
// SQLiteDataReader reader = setDF.query("select * from vCenterDB");
// while (reader.Read())
// {
// textBox_ServerIP.Text = reader[1].ToString();
// textBox_User.Text = reader[2].ToString();
// textBox_Password.Text = reader[3].ToString();
// textBox_port.Text = reader[4].ToString();
// }
// textBox_ServerIP.ReadOnly = true;
// textBox_User.ReadOnly = true;
// textBox_Password.ReadOnly = true;
// textBox_port.ReadOnly = true;
// checkBox1.Checked = false;
// connectDB();
//}
//else
//{
// connectDB();
//}
}
