学步园

 mysql.data.dll拷贝到bin下面并引用一下

using MySql.Data.MySqlClient;<br /> public partial class _Default : System.Web.UI.Page<br /> {<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=admin";<br /> MySqlConnection mycn = new MySqlConnection(myConnectionString);</p> <p> try<br /> {<br /> mycn.Open();<br /> Response.Write("<mce:script type="text/javascript"><!--<br /> alert('连接成功')<br /> // --></mce:script>");<br /> }<br /> catch (Exception ex)<br /> {<br /> Response.Write("<mce:script type="text/javascript"><!--<br /> alert(" ex.ToString() ")<br /> // --></mce:script>");<br /> }<br /> }<br /> }

也可以配置app.config (web.config):

<appSettings><br /> <add key="Con" value="Provider=MySQLProv;Data Source=test;User Id=root;Password=admin;pooling=false;CharSet=utf8;port=3306"/><br /> </appSettings>