Vb.net (水晶報表) + MySql (PhpMyAdmin) + IIS ==> utf8使用經驗小結
近日對MYSQL與VB.NET就IIS的搭配且使頁面繁簡體都能正常顯示作了些研究,整理如下資訊供參考:
1.在對MYSQL進行設定時請選擇UTF8編碼
2.MYSQL的2個連結檔案:
a.MyODBC-3.51.11-1-win.exe
b.mysql-connector-net-1.0.4.msi
3.MYSQL與VB.NET(ASP.NET)的2種連結寫法:
a.用MYODBC:(請先imports system.data.odbc)
Dim cn As New Odbc.OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Option=131072;Stmt=;Database=mysql;Uid=root;Pwd=1234;")
Dim adpt As New Odbc.OdbcDataAdapter("SELECT * FROM mysql.user", cn)
...
b.用mysql:(請先Imports MySql.Data.MySqlClient)
Dim cn As New MySqlConnection("server=localhost;user id=root;password=1234;database=mysql")
Dim adpt As New MySqlDataAdapter("select * from user", cn)
...
4.如果要用DATAGRID,DATALIST等WEB元件來顯示MYSQL中的資料表時
(1)請將web.config中的
<?xml version="1.0" encoding="utf-8" ?>
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
(2)請採用上述3的b做法(假如有繁簡體的話就會正常)
(3)請將html中的這句話<meta http-equiv="Content-Type" content="text/html; charset=utf8">去掉==>因為頁面控件文字等會出現亂碼
5.如果要用水晶報表
a.製作水晶報表時
請先到ODBC中設定[使用者資料來源名稱],驅動程式選擇[MySql ODBC 3.51 Driver]
在?生水晶報表時的[資料庫專家]選擇[ODBC (RDO)]
b.在代碼中建議使用3中的B給水晶報表,eg:
Dim cn As New MySqlConnection("server=localhost;user id=root;password=1234;database=gs")
Dim adpt As New MySqlDataAdapter("SELECT user.id, user.name,user.age,user.address, scores.chinese, scores.maths, scores.english FROM User INNER JOIN scores ON (user.id=scores.id) ORDER BY User.id", cn)
Dim ds As New DataSet
cn.Open()
adpt.Fill(ds)
cn.Close()
Dim rept As New CrystalReport2
rept.SetDataSource(ds.Tables(0))
'Response.Write(ds.Tables(0).Rows.Count())
ds = Nothing
adpt = Nothing
Me.CrystalReportViewer1.ReportSource = rept
Me.CrystalReportViewer1.DataBind()
rept = Nothing |
附件: 您所在的用戶組無法下載或查看附件
發表於 2010-9-4 02:08
|