纠结的VS2008+mysql显示乱码

 　　mysql数据库的字符集为拉丁文(latin1)，又不能修改数据库的默认字符集，只好从程序进行转换。

       1。数据绑定显示

            .cs文件

           public string GetGBK(object name) { string key = Convert.ToString(name); byte[] bytes = Encoding.GetEncoding ("latin1").GetBytes(key); return Encoding.Default.GetString(bytes); }

            前端页面：

            <asp:TemplateColumn HeaderText ="角色名" > <ItemTemplate > <%# GetGBK(Eval("c_self_role_name"))%> </ItemTemplate> </asp:TemplateColumn>

       2。数据查询

             1).链接字符串          <add name="GSLog.Conn" connectionString="Server=;Database=;Uid=;Pwd=;

Character Set=gbk;" providerName="MySql.Data.MySqlClient" />

             2);获取数据集(MySqlCommand cmd = new MySqlCommand("SET NAMES  latin1", conn);)

                    public override DataTable GetWlzzChatLogList(string SearchTerms, int pageStart, int pageSize) { DataTable list = new DataTable(); using (MySqlConnection conn = this.GetLogConnection()) { string strSQL = "SELECT * FROM t_wlzz_chat_log WHERE 1=1 " + @SearchTerms + " order by c_time DESC LIMIT " + @pageStart + "," + @pageSize + ""; conn.Open(); MySqlCommand cmd = new MySqlCommand("SET NAMES latin1", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@SearchTerms", MySqlDbType.VarChar).Value = SearchTerms; cmd.Parameters.Add("@pageStart", MySqlDbType.Int32).Value = pageStart; cmd.Parameters.Add("@pageSize", MySqlDbType.Int32).Value = pageSize; cmd.ExecuteNonQuery(); // 执行 Log.Error("SQL"+strSQL); MySqlDataAdapter sd = new MySqlDataAdapter(strSQL,conn); sd.Fill(list); cmd.Dispose(); conn.Close(); } return list; }

            第一次用mysql数据库，这样写终于可以正常了。。。。还在晕乎中！