.net2.0连接Mysql5数据库配置

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();
            }
        }
    }
}