using System.Data.Odbc;

OdbcConnection con = new OdbcConnection();
string mysql = "driver={MySql};server=[server];database=[database]/DB;uid=[brugernavn];pwd=[password];OPTION=3";
con.ConnectionString = mysql;
con.Open();

OdbcCommand cmd = new OdbcCommand();
cmd.CommandText = "SELECT * FROM TestTabel";
cmd.Connection = con;

OdbcDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
Response.Write(reader.GetValue(0).ToString());
}