How to Connect Mono with MySql
The box where I test this was a Fedora Core 2 Kernel 2.6.10-1.12
I used the mono installer available at HERE
* I installed it in /opt/mono/monobundle
* Run the XSP server from the command line: /opt/mono/monobundle/bin/xsp
* Edit an index.aspx page on /opt/mono/monobundle/bin:
<![CDATA[
<%@ Import namespace="System" %>
<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Web" %>
<%@ Assembly name="ByteFX.Data" %>
<%@ Import namespace="ByteFX.Data.MySqlClient" %>
<html>
<head>
<title>Pagina de Inicio</title>
<style>
body{
font-family:Verdana,Sans;
font-size:10;
}
</style>
</head>
<body>
<script language="C#" runat="server">
void Page_Load(object sender, EventArgs e)
{
string host="<your_host>";
string user="<your_user>";
string password="<your_password>";
string dbname="<your_database>";
string connString="Server=" +host+
";Database=" +dbname+
";User Id=" +user+
";Password=" +password+ ";";
MySqlConnection conn=new MySqlConnection(connString);
conn.Open();
MySqlCommand cmd;
cmd=conn.CreateCommand();
string sqlString="SELECT <field1>,<field2> FROM <your_table>";
cmd.CommandText=sqlString;
MySqlDataReader reader=cmd.ExecuteReader();
while (reader.Read())
{
string strNombre=(string) reader["<field1>"];
string strApellido=(string) reader["<field2>"];
Response.Write(strNombre + " " +strApellido + "<br>");
}
Page.DataBind();
reader.Close();
reader=null;
cmd.Dispose();
cmd=null;
conn.Close();
conn=null;
}
</script>
</body>
</html>
]]>
Notes: I tried using the latest MySql .Net Connector
but so far I can't make the XSP Server see the assembly.
Actually, this example is working with driver that came along with the mono installer, workis w/o problems
Hope this helps others...
regards,
-eduardo s.m.