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(); //} }