基於 MySQL Connector /ODBC driver 之 C# 存取 MySQL 範例
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Odbc; // 引入 odbc driver 之名稱空間
namespace wap5
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void bT1_Click(object sender, EventArgs e)
{
OdbcConnection odbcCon;
OdbcCommand odbcCmd;
OdbcDataReader dataSet;
string conString;
//-----------------------------
conString = "DRIVER={MySQL ODBC 5.1 Driver};server=localhost;uid=user;"+
"pwd=1234;database=localbase;charset=utf8;";
try
{
odbcCon = new OdbcConnection(conString);
odbcCon.Open();
odbcCmd = new OdbcCommand();
odbcCmd.Connection = odbcCon;
odbcCmd.CommandText = "select * from infolook";
dataSet = odbcCmd.ExecuteReader();
while (dataSet.Read())
{
dataOut.Text += dataSet + "<br/>";
}
odbcCon.Close();
dataSet.Close();
}
catch (OdbcException oe)
{
Response.Write("錯誤:" + oe.ToString());
}
}
}
}
頁:
[1]