mysql方面没什么问题,默认编码是 gb2312
c# 窗体里面添加个DataGridView控件,窗体load时,执行以下代码:
C# code:
server = "localhost";
database = "csharp";
name = "root";
password = "root";
string connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + name + ";" + "PASSWORD=" + password + ";";
connection = new MySqlConnection(connectionString);
string mysql = "select * from books";
MySqlDataAdapter mysqlAdapter = new MySqlDataAdapter(mysql, connection);
DataSet ds = new DataSet();
mysqlAdapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
connection.Close();
connection.Dispose();
大家应该看得懂吧,
结果是:
DataGridView的列名 乱码,正常显示应该是中文的,其他情况正常
请大家帮我分析下哪里出了问题?
SQL code:
select * from books
--把*号写成字段名试一试
应该不是Gridview的问题
试过了
数据库表有如下字段:
ID, 书名, 定价, 销次, 销量, 出版社