最近在连接mysql的时候出现了中文乱码,我的代码如下:
MySqlDB.CS代码
using System;
using System.Data;
using System.Windows.Forms;
using System.Diagnostics;
using MySql.Data.MySqlClient;
using System.Configuration;
using System.Xml;
using System.IO;
using System.Runtime.InteropServices;
using System.Runtime.Remoting;
namespace TV1200_Mgr
{
///
/// Description of MySqlDB.
///
public class MySqlDB
{
public MySqlConnection m_MySqlCon;
public MySqlCommand m_MySqlCmd;
static string m_ConnectString = "";
public MySqlDB()
{
if (m_ConnectString == "")
{
}
m_MySqlCon = new MySqlConnection(m_ConnectString);
m_MySqlCmd = new MySqlCommand("", m_MySqlCon);
}
static public void SetDBConnection(string strCon)
{
m_ConnectString = strCon;
}
public MySqlConnection GetCon()
{
if (m_MySqlCon == null)
return null;
return m_MySqlCon;
}
public void OpenCon()
{
if (m_MySqlCon.State == ConnectionState.Closed)
{
try
{
m_MySqlCon.Open();
}
catch (MySqlException e)
{
if(m_MySqlCon.State == ConnectionState.Closed)
MessageBox.Show("连接数据库失败\r\nError:" + e.Message);
}
}
}
public void CloseCon()
{
if (m_MySqlCon.State == ConnectionState.Open)
{
try
{