http://blogwind.com/Rex/3106.shtml
public DataSet getTv(string sql)
{
con.openMySql();
MySqlDataAdapter da=new MySqlDataAdapter(sql,con.mySqlConn);
DataSet ds=new DataSet();
da.Fill(ds,"TV");
con.closeMySql();
string xml = ds.GetXml();
ds.Clear();
System.Text.Encoding gb = System.Text.Encoding.GetEncoding("gb2312");
System.Text.Encoding iso = System.Text.Encoding.GetEncoding("iso8859-1");
byte[] ub = iso.GetBytes(xml);
xml = gb.GetString(ub);
ds.ReadXml(new System.IO.StringReader(xml));
return ds;
}