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完畢。