c# 执行txt中的sql语句，sql语句中文内容 显示乱码

Question

 string path = @"SQL";
            string sql = ReadXmlStringFromFile("Q.txt", "\r\n", path);
            cmd = new SqlCommand(sql, constr);
            string sqlstr = sql.ToString();
            SqlDataAdapter myDataAdapter;
            DataSet myDataSet = new DataSet();
            myDataAdapter = new SqlDataAdapter(sqlstr, connstr);
            myDataAdapter.Fill(myDataSet, "kgzt");
            gridControl10.DataSource = myDataSet.Tables["kgzt"];
            for (int i = 0; i < gridView8.Columns.Count; i++)
            {
                this.gridView10.BestFitColumns();
                this.gridView10.Columns[i].BestFit();//自动列宽
            }

sql语句中有 AS中文，执行sql语句中文有乱码。

Answer 1

C# 读取文档的时候指定字符集“GB2312”进行读取
File.ReadAllText(path, Encoding.GetEncoding("GB2312"));