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