Mac OS 下Asp.net连接Mysql
16 Nov 2012我的联想笔记本坏了，不能联网，只能用mac写C#了，还没用mono正式做过东西，这次试试吧。
SQLserver没有mac版，mysql搭配Asp.net貌似也不错。
首先，需要下载Connector/Net，地址：http://dev.mysql.com/downloads/connector/net/5.2.html
2，安装Mysql.data.dll到mono framework
su命令行下，sh-3.2# gacutil -i /z/mysql.data.dll
Installed /z/mysql.data.dll into the gac (/Library/Frameworks/Mono.framework/Versions/2.10.9/lib/mono/gac)
（此dll为下载的文件）
3，创建文件，插入代码：
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="MySql.Data.MySqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>CD cat</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script runat="server">
private void Page_Load(Object sender, EventArgs e)
{
string connectionString = "Server=localhost;Database=mono;User ID=root;Pooling=false;";
MySqlConnection dbcon = new MySqlConnection(connectionString);
dbcon.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM artist", dbcon);
DataSet ds = new DataSet();
adapter.Fill(ds, "result");
dbcon.Close();
dbcon = null;
ArtistsControl.DataSource = ds.Tables["result"];
ArtistsControl.DataBind();
}
</script>
</head>
<body>
<h1>Artists</h1>
<asp:DataGrid runat="server" id="ArtistsControl" />
</body>
</html>
4,在cs文件中引入mysql.data命名空间
5，测试：
转载请注明：于哲的博客 » Mac OS 下Asp.net连接Mysql