如何在vs2008中链接mysql数据库？？？

Question

如何在vs2008中链接mysql数据库？？？
数据库字符串怎么写‘；

Answer 1

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

Answer 2

  public void InsertRow(string myConnectionString) 
  {
    // If the connection string is null, use a default.
    if(myConnectionString == "") 
    {
      myConnectionString = "Database=Test;Data Source=localhost;User Id=username;Password=pass";
    }
    MySqlConnection myConnection = new MySqlConnection(myConnectionString);
    string myInsertQuery = "INSERT INTO Orders (id, customerId, amount) Values(1001, 23, 30.66)";
    MySqlCommand myCommand = new MySqlCommand(myInsertQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    myCommand.ExecuteNonQuery();
    myCommand.Connection.Close();
  }
  当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

Answer 3

url='http://localhost:3306/test?user=root&password=as&characterEncoding=utf8';

Answer 4

        //数据库连接属性
        private static SqlConnection conn;
        public static SqlConnection Conn
        {
            get
            {                string connectionString = @"Database=Test;Data Source=localhost;User Id=root;Password=root";                if (conn == null)
                {
                    conn = new SqlConnection(connectionString);
                    conn.Open();
                }
                else if (conn.State == System.Data.ConnectionState.Closed)
                {
                    conn.Open();
                }
                else if (conn.State == System.Data.ConnectionState.Broken)
                {
                    conn.Close();
                    conn.Open();
                }
                return conn;
            }
        }
怎么就连不上呢？？？

Answer 5

 我用的环境是vs2008和mysql？？？

Answer 6

你本地能链接上mysql不？还有链接语句加个端口最好debug一下 看看链接获取没 打印输出链接

Answer 7

        public static UserTest GetUserByLoginName(string name)
        {
            string sql = "SELECT * FROM nt_User WHERE name = @name";            try
            {
                MySqlDataReader reader = DBconn.GetReader(sql, new MySqlParameter("@name", MySqlDbType.VarChar, 50, name));
                if (reader.Read())
                {
                    UserTest user = new UserTest();                    user.Id = (int)reader["id"];
                    user.Name = (string)reader["name"];
                    user.Password= (string)reader["password"];
 
                    reader.Close();
                    return user;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
            catch (MySqlException e)
            {
                Console.WriteLine(e.Message);
                return null;
            }
        }
红色部分是不是有问题？reader老是取不到值，数据库连接测试通过了...

Answer 8

DBconn.GetReader()是什么，你不贴出代码，估计猜不出来。

Answer 9

        public static MySqlDataReader GetReader(string sql, params MySqlParameter[] values)
        {
            MySqlCommand cmd = new MySqlCommand(sql, Conn);
            cmd.Parameters.AddRange(values);
            MySqlDataReader reader = cmd.ExecuteReader();
            return reader;
        }

Answer 10

使用MySQL Connector/Net就可以,里面有sample可参考