.net2.0 connection Mysql5 database configuration

I have always preferred Mysql. The main reasons are: 1. The database is small in size. 2. The database is open source and free. 3. The database has many useful client tools.

4. Cross-platform. 5. The performance and functions are relatively powerful (it is impossible to compare with those heavyweights). 6. Easy to transplant, deploy and install. Therefore, Mysql is generally the first choice for small projects I do. Recently, I am using the combination of .net sqlserver05, but I am suffering from the sqlserver enterprise version. The standard version only supports server 03. My computer is XP,

, so I am very depressed. I installed Express, which has too few functions. . It's not fun to use either. Can't even remove it cleanly. Finally, I even considered using someone else's Sqlserver2000 Enterprise

version remotely. But because .net also supports Mysql connection, I searched online for implementation and required tools. There is really no technical content. It seems that I can also consider the combination of

.net Mysql in the future. There is a lot of information on this aspect on the Internet, and I will only record my own implementation experience. If you don’t know it, please refer to it. If you know it, just take a detour.

Download tool:

Mysql connector/net5.0 download address:

http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector- net-5.0.6.zip/from/pick

Just install it directly after downloading.

After the installation is complete, add a reference to the project and you can use it.

Let’s show the code below: The function is to read a user table from Mysql and execute the Mysql stored procedure. The example is not difficult, success is the answer. The execution of

on this machine has passed. Native environment: XP Mysql5 VS05 C# (ASP.NET2.0)

The code is very simple, mainly for testing:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using MySql.Data.MySqlClient;
namespace ConnectMysql
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!Page.IsPostBack){
                MySqlConnection con = DB.createCon();
                string sql = "select * from t_user";
                MySqlDataAdapter mda = new MySqlDataAdapter(sql,con);
                DataSet ds = new DataSet();
                mda.Fill(ds, "user");
                this.GridView1.DataSource = ds;
                this.GridView1.DataBind(); 
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            MySqlConnection con = DB.createCon();
            MySqlCommand cmd = new MySqlCommand("getUsername", con);
            cmd.CommandType = CommandType.StoredProcedure;
            con.Open();
            try
            {
                MySqlDataReader dr = cmd.ExecuteReader();
                this.GridView2.DataSource = dr;
                this.GridView2.DataBind();
                con.Close();
            }
             catch(Exception ex)
            {
                ex.ToString();
                con.Close();
            }
        }
    }
}

The question is quite attractive, in fact.net1.0 even Mysql is actually the same.

This article explains the configuration of .net2.0 connection to Mysql5 database. For more related content, please pay attention to the PHP Chinese website.

Related recommendations:

Detailed explanation of the difference between cookie and session

Understand how to optimize MySQL

Simple PHP MySQL paging class

The above is the detailed content of .net2.0 connection Mysql5 database configuration. For more information, please follow other related articles on the PHP Chinese website!