asp.net链接mysql

首先是下载安装mysql

http://dev.mysql.com/downloads/mirror.php?id=412535

基本是一直next就可以了

安装好之后,在visualstudio 项目中添加引用

然后就可以实验了

放一段代码 仅供参考

 private MySqlConnection conn;
        protected void Page_Load(object sender, EventArgs e)
        {
           
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (conn != null)
                conn.Close();

            string connStr = String.Format("server={0};user id={1}; password={2}; database=mysql; pooling=false",
                "localhost", "root", "root");

            conn = new MySqlConnection(connStr);
            conn.Open();
            GetDatabases();
        }


        private void GetDatabases()
        {
            MySqlDataReader reader = null;

            MySqlCommand cmd = new MySqlCommand("SHOW DATABASES", conn);
            try
            {
                reader = cmd.ExecuteReader();
                string s = "";
                while (reader.Read())
                {
                    s+=reader.GetString(0)+" ";
                }
                Label1.Text = s;
            }
            catch (MySqlException ex)
            {
                Label1.Text = "Failed to populate database list: " + ex.Message;
            }
            finally
            {
                if (reader != null) reader.Close();
            }
        }