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