using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MysqL.Data.Common;
using MysqL.Data.MysqLClient;
using System.Data.sqlClient;
using System.Windows.Forms;
using System.Data;

public partial class viewAdmin : System.Web.UI.Page
{
    String MyConString = "SERVER=localhost;" +
                "DATABASE=databasename;" +
                "UID=root;" +
                "PASSWORD=;";
protected void Page_Load(object sender,EventArgs e)
{

        MysqLConnection conn = new MysqLConnection(MyConString);
        MysqLCommand cmd = new MysqLCommand("SELECT * FROM tablename;",conn);
        conn.Open();
        DataTable dataTable = new DataTable();
        MysqLDataAdapter da = new MysqLDataAdapter(cmd);

        da.Fill(dataTable);


        GridVIew.DataSource = dataTable;
        GridVIew.DataBind();
}

}