private void SqlForm_Load(object sender, EventArgs e) { //读取下ini配置 IniFiles ini = new IniFiles(Directory.GetCurrentDirectory() + @"\ini\mysqlconfig.ini"); SqlInitInfo = ini.GetSelectedSqlConfig(); if (SqlInitInfo == null) { MessageBox.Show("请先添加数据库配置!"); SqlConfigForm sqlConfigForm = new SqlConfigForm(); sqlConfigForm.Show(); return; } //连接数据库 if (myso.MySqlConncet(SqlInitInfo) == null) { MessageBox.Show("连接数据库失败,请检查数据库配置是否正确。"); return; } //string sText = "show databases"; //读取数据库列表 DataSet ds = myso.MySqlCommand_GetDataSet(SqlInitInfo, "show databases"); SqlDatabase_ListBox.DataSource = ds.Tables[0]; SqlDatabase_ListBox.DisplayMember = ds.Tables[0].Columns[0].ToString(); //设置默认选择项 SetListBoxSelectItem(SqlInitInfo[3]); }
/// <summary> /// 是否连接成功 /// </summary> /// <returns></returns> public bool IsConnectSucess() { MySqlOpration mso = new MySqlOpration(); List <string> SqlInitInfo = new List <string>() { textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, }; if (mso.MySqlConncet(SqlInitInfo) != null) { return(true); } else { return(false); } }