using System;
using System.Collections.Generic;
using System.Text;
using MySql.Data.MySqlClient;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{ MySqlCommand com = new MySqlCommand("insert into testinfo values(1,admin)", Mysqlcon);
MySqlDataReader dr = com.ExecuteReader();
string str = "";
if(dr.Read())
{
str=dr[1].ToString();
}
Console.WriteLine(str);
Console.ReadLine();
}
public static MySqlConnection Mysqlcon
{
get
{
MySqlConnection Mysqlcon = new MySqlConnection("server=.;user id=root;password=1234;database=test;CharSet=gb2312;");
if (Mysqlcon.State == System.Data.ConnectionState.Open)
{ Mysqlcon.Close();
Mysqlcon.Open();
}
else if (Mysqlcon.State == System.Data.ConnectionState.Closed)
{
Mysqlcon.Open();
}
else if (Mysqlcon.State == System.Data.ConnectionState.Broken)
{
Mysqlcon.Close();
}
return Mysqlcon;
}
} }
}
请问这个连接 哪里出了问题! Mysqlcon.Open(); 出错! 我的MySql.Data.MySqlClient 是5.0版的;都说server sql 和Mysql是一样的,可我为什么连不上呢?
server值设成localhost
先在外头用命令行测一下
mysql -u root -p -h localhost
!
跟你的应用环境有关,有的可以,有的就不可以,除了localhost,你还可以用127.0.0.1试试。