C#表單
使用需求是點擊右下角的獲取按鈕時，正下方的資料庫將當前連接資訊下的資料庫清單羅列出來，但現在點擊多次都無法實作。
希望高手大神們能指點一下。不勝感激！
部分腳本如下
private DataTable getTable(string str)
{
try
{
MySqlConnection mysqlcon = new MySqlConnection(str);
MySqlDataAdapter da = new MySqlDataAdapter(@"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA)", mysqlcon);
DataTable dt = new DataTable("INFORMATION_SCHEMA.SCHEMATA");
da.Fill(dt);
return dt;
}
catch
{
return null;
}
}
private void btn_Select_Click(object sender, EventArgs e)
{
try
{
MySqlconn = new MySqlConnection(@"server=" + coB_Server.Text + ";port=" + coB_Port.Text + ";database=INFORMATION_SCHEMA;user=" + coB_sa.Text + ";password= " + tB_PassWord.Text.Trim());
MySqlconn.Open();
if (MySqlconn.State == ConnectionState.Open)
try
{
string str = "server=" + coB_Server.Text + ";database=INFORMATION_SCHEMA;Uid=" + coB_sa.Text + ";Pwd=" + tB_PassWord.Text + ";";
coB_DB.DataSource = getTable(str);
coB_DB.DisplayMember = "SCHEMA_NAME";
coB_DB.ValueMember = "SCHEMA_NAME";
}
catch (Exception ex)
{
throw ex;
}
}
catch (Exception ey)
{
throw ey;
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/14658.html
標籤：C#
上一篇：去掉重復元素
下一篇：SqlHelper