ÀûÓÃMySQLDriverCSʵÏÖÔÚ.NET»·¾³Ï·ÃÎÊMySQLÊý¾Ý¿â

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.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySQLDriverCS;
 
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        MySQLConnection conn = null;
        conn = new MySQLConnection(new MySQLConnectionString("127.0.0.1", "Dvbbs", "root", "123456").AsString);
        conn.Open();
        MySQLCommand commn = new MySQLCommand("set names gb2312",conn);
        commn.ExecuteNonQuery();
        string sql = "select title,topicID, boardId ,dateandtime,hits  from  Dv_topic order by dateandtime desc limit 10";
        MySQLDataAdapter mda = new MySQLDataAdapter(sql,conn);
        DataSet ds = new DataSet();
        mda.Fill(ds, "table1");
        this.Repeater1.DataSource = ds;
        this.Repeater1.DataBind();
        conn.Close();
    }
}
¾ÍÕâÑù¾Í¿ÉÒÔʵÏÖÔÚ.NET»·¾³Ï¶ÔMySQLÊý¾ÝµÄ·ÃÎÊ¡£ÔÚÕâ֮ǰ»¹Òª×öһЩ׼±¸£¬ÏÂÔØMySQLDriverCS£¬°²×°£¬ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖоÍOKÁË¡£Ò²ÐíÄã¶ÔÕâÐдúÂë
MySQLCommand commn = new MySQLCommand("set names gb2312",conn);
        commn.ExecuteNonQuery();
²»Ì«Àí½â¡£ÕâÊÇÒòΪÈç¹ûûÓÐÕâ¾ä»