MySqlConnection conn = new MySqlConnection("User Id=root;PassWord=sa;Host=localhost;Database=mis;");

conn.Open();

MySqlDataAdapter da = new MySqlDataAdapter("select id, name, age from `mis`.`users` ",conn);

DataSet ds = new DataSet();

da.Fill(ds,"users");

conn.Close();

DataGrid1.DataSource= ds;

DataGrid1.DataBind();