如何用C#获取MySQL数据库名

kissyoulyy 2009-12-19 03:00:09

我用的是MySQLDriverCS的接口，网上的基本连接方法也会，但是我的需求是要在未知数据库名的情况下，已知localhost，用户名，密码，连接上数据库并获取MySQL现有的数据库名。请知道的高手出来回答一下吧！小弟先谢谢你们了！

...全文

400 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

kissyoulyy 2009-12-20

打赏
举报

[Quote=引用 5 楼 waterzhz 的回复:]
static void Main(string[] args)
{
string connctionString = "server = localhost; database = MySql; user id = root; password = ******;";
MySqlConnection connetion = new MySqlConnection(connctionString);
try
{
string sql = "show databases";
MySqlCommand command = new MySqlCommand(sql);
command.Connection = connetion;
connetion.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(reader[0].ToString());
}
}
}
catch(Exception ex)
{
Console.WriteLine("Error:"+ex.Message);
}
finally
{
if(connetion!=null&& connetion.State== ConnectionState.Open)
{
connetion.Clone();
}
}
}
[/Quote]

太感谢了！！搞定了

XiaoShe8 2009-12-19

打赏
举报

public string StrConn="server=本机名（.）;uid=用户名；pwd=密码；database=数据库名"；

wuyq11 2009-12-19

打赏
举报

连接mysql
show databases;

waterzhz 2009-12-19

打赏
举报

static void Main(string[] args)
{
string connctionString = "server = localhost; database = MySql; user id = root; password = ******;";
MySqlConnection connetion = new MySqlConnection(connctionString);
try
{
string sql = "show databases";
MySqlCommand command = new MySqlCommand(sql);
command.Connection = connetion;
connetion.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(reader[0].ToString());
}
}
}
catch(Exception ex)
{
Console.WriteLine("Error:"+ex.Message);
}
finally
{
if(connetion!=null&& connetion.State== ConnectionState.Open)
{
connetion.Clone();
}
}
}