Connect to My SQL from ASP.NET C#

This is a simple code for connecting to MySQL from ASP.NET using C#. Here I have just read a table from the phpBB database. You have to change your connection string accordingly. Here I have read all the data from the table named bb_posts and shown in a grid view. The last function is required.

 public partial class _Default : System.Web.UI.Page
 {
     MySqlConnection con = new MySqlConnection("Database=phpbb;Data Source=localhost;User Id=root;Password=");
     MySqlDataAdapter adap;
     DataSet ds;
     Panel panel = new Panel();
     GridView gv = new GridView();

     protected void Page_Load(object sender, EventArgs e)
     {
         MySqlCommand command = new MySqlCommand();
         adap = new MySqlDataAdapter("select * from bb_posts", con);
         ds = new DataSet();
         adap.Fill(ds, "bb_posts");

         this.Controls.Add(panel);
         panel.Controls.Add(gv);

         gv.DataSource = ds.Tables["bb_posts"];
         gv.DataBind();
         gv.AllowPaging = true;
         gv.AllowSorting = true;
         gv.AutoGenerateDeleteButton = true;


     }

     public override void VerifyRenderingInServerForm(Control control)
     {
         return;
     }
 }