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

            }

        }

    }

}