c# 生成text 数据

  public string Test()
        {

            DataTable dt = hotWorksComment.get_info();//查询数据库信息
            if (dt.Rows.Count > 0)
            {
               
                string json = DataTableToJson(dt); //查询出来的datatable转换成json字符串


                Encoding code = Encoding.GetEncoding("gb2312");  //编码格式   

                string htmlfilename = HttpContext.Current.Server.MapPath("/FileUp/信息.txt");    //文件保存路径  

                string str = json;     //写入内容   类型
                StreamWriter sw = null;
                {

                    try

                    {

                        sw = new StreamWriter(htmlfilename, true, code);

                        sw.Write(str);//写入text



                        sw.Flush();

                    }

                    catch { }

                }
                // 关闭流文件
                sw.Close();

                sw.Dispose();




            }

            return "";
        }

 

附带方法-->将datatable转换成json字符串

 public string DataTableToJson(DataTable table)
        {
            var JsonString = new StringBuilder();
            if (table.Rows.Count > 0)
            {
                JsonString.Append("[");
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    JsonString.Append("{");
                    for (int j = 0; j < table.Columns.Count; j++)
                    {
                        if (j < table.Columns.Count - 1)
                        {
                            JsonString.Append("\"" + table.Columns[j].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][j].ToString() + "\",");
                        }
                        else if (j == table.Columns.Count - 1)
                        {
                            JsonString.Append("\"" + table.Columns[j].ColumnName.ToString() + "\":" + "\"" + table.Rows[i][j].ToString() + "\"");
                        }
                    }
                    if (i == table.Rows.Count - 1)
                    {
                        JsonString.Append("}");
                    }
                    else
                    {
                        JsonString.Append("},\r\n");
                    }
                }
                JsonString.Append("]");
            }
            return JsonString.ToString();
        }