c#连接Mysql数据库 Connect to mySQL in C#

Instructions:
1) Download and install the connector: url=http://dev.mysql.com/downloads/connector/net/1.0.html
2) Create a test project
3)Next add reference to: MySql.Data
4) Next add "using MySql.Data.MySqlClient;"
 

/// <summary>
    /// Method for connection to a mySQL database. You
    /// need to download the mySQL Connector located at
    /// http://dev.mysql.com/downloads/connector/net/1.0.html]
    ///
    /// NOTE: I am a big supporter of having the connection
    /// stored in the web.config, not inline like this
    /// </summary>
    /// <param name="server"></param>
    private void connectoToMySql(string server)
    {
        //set your connection string.
        //NOTE: I am a big supporter of having the connection
        //stored in the web.config, not inline like this
        string connString = "SERVER=" + server + ";" +
                "DATABASE=mydatabase;" +
                "UID=testuser;" +
                "PASSWORD=testpassword;";
        //create your mySQL connection
        MySqlConnection cnMySQL = new MySqlConnection(connString);
        //create your mySql command object
        MySqlCommand cmdMySQL = cnMySQL.CreateCommand();
        //create your mySQL reeader object
        MySqlDataReader reader;
        //set the command text (query) of the
        //mySQL command object
        cmdMySQL.CommandText = "select * from mycustomers";
        //open the mySQL connection
        cnMySQL.Open();
        //execute the reader, thus retrieving the data
        reader = cmdMySQL.ExecuteReader();
        //while theres data keep reading
        while (reader.Read())
        {
            string thisrow = "";
            for (int i = 0; i < reader.FieldCount; i++)
                thisrow += reader.GetValue(i).ToString() + ",";
            listBox1.Items.Add(thisrow);
        }
        cnMySQL.Close();
    }

上一篇: Asp.net c#当前上下文中不存在名称“Encoding”
下一篇: 常用正则表达式
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: c#
相关日志: