asp.net开发的网站中使用mysql

使用mysql-connector-net-5.1.7-noinstall

 

Web.config 文件的设置

<appSettings>
  <add key="connStr" value="Server=FENGSULEI\SQL2005;Database=new_tes;uid=sa;pwd=sa"/>
  <add key="yycc" value="Server=localhost;Database=ftdms;uid=root;pwd=123456"/>
 </appSettings>

 

 

Bin文件夹中拷入下载的

MySql.Data.dll

 

 

统一引入数据库连接文件

 

 

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

/// <summary>
///数据库类
/// </summary>
public class Db
{
    public string strConn = ConfigurationSettings.AppSettings["connStr"];
}
public class my
{
    public string mystr = ConfigurationSettings.AppSettings["yycc"];
}

 

在页面中使用方法同使用mssql数据库的方法相似

 

 

using System;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class mysql : System.Web.UI.Page
{
    my db = new my();
    protected void Page_Load(object sender, EventArgs e)
    {
        MySqlConnection mycon = new MySqlConnection(db.mystr);
        mycon.Open();
        MySqlCommand mycmd = new MySqlCommand("select * from ftdms_admin where id=?id", mycon);
        {
            mycmd.Parameters.AddWithValue("?id", 1);

        }
        MySqlDataReader myreader = mycmd.ExecuteReader();
        while (myreader.Read())
        {
            if (myreader.HasRows)
            {
                Response.Write(myreader.GetString("admin_user") + "<br/>");
            }
        }
        myreader.Close();
        mycon.Close();

    }
}

 

ok完毕。