导出TXT关键类:
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.IO; using System.Globalization; using System.Windows.Forms; namespace Demo { /// <summary> /// 导出TXT /// 罗旭成 /// 2014-4-15 /// </summary> public class ExportTxt { #region * 将DataTable指定的列,导出到TXT文件. /// <summary> /// 将DataTable指定的列,导出到TXT文件. /// </summary> /// <param name="pDataTable">数据源表</param> /// <param name="pColName">列名</param> /// <param name="pColCaption">标题(未指定则使用列名)</param> /// <param name="pFilePath">完整的路径和文件名</param> public static void UTF8_SaveToTXT(DataTable pDataTable, string pColName, string pColCaption, string pFilePath) { //如果文件存在则删除 if (File.Exists(pFilePath)) { File.Delete(pFilePath); } //******************************************************************************************** using (FileStream stream = new FileStream(pFilePath, FileMode.Create, FileAccess.Write)) { using (StreamWriter writer = new StreamWriter(stream, Encoding.UTF8)) { //------ if ((pColName == null) || (pColName.Trim() == "")) { return; } if (pColCaption == null) { pColCaption = ""; } String[] xColArray = pColName.Split(new Char[] { ',' }); String[] xColCapArray = pColCaption.Split(new Char[] { ',' }); for (int xI = 0, xN = xColArray.Length; xI < xN; xI++) { xColArray.SetValue(xColArray[xI].Trim(), xI); } for (int xI = 0, xN = xColCapArray.Length; xI < xN; xI++) { xColCapArray.SetValue(xColCapArray[xI].Trim(), xI); } //--************************************************************************************************* //--如果标题不为空 if (pColCaption.Trim() != "") { if (xColArray.Length == xColCapArray.Length)//标题和列名的数量必须相同 { int x = 0; Boolean xFind = false; for (int j = 1; j < xColArray.Length; j++) { //设计列名 for (int i = 0; i < pDataTable.Columns.Count; i++) { if (xColArray[j] == pDataTable.Columns[i].ColumnName) { xFind = true; UTF8_WriteString(writer, xColCapArray[j - 1], 0, 1);//(列名)不是最后一列的处理方式 x = j; break; } } if (xFind == false) { MessageBox.Show("指定的列名不存在!"); return; } } UTF8_WriteString(writer, xColCapArray[x], 0, 2);//(列名)最后一列的处理方式 //--************************************************************************************************ //设计列数据 int y = 0; //------------- for (int b = 0; b < pDataTable.Columns.Count; b++) { for (int a = 0; a < xColArray.Length; a++) { if (xColArray[a] == pDataTable.Columns[b].ColumnName) { y = b;//获取最大列的索引 } } } //------------- for (int j = 0; j < pDataTable.Rows.Count; j++) { for (int i = 0; i < pDataTable.Columns.Count; i++) { String pColType = pDataTable.Columns[i].DataType.Name.ToString();//获取列类型 for (int k = 1; k < xColArray.Length; k++) { if (xColArray[k - 1] == pDataTable.Columns[i].ColumnName.ToString()) { //*************************************************************************************** //--不是最后一列的处理方式 if (pDataTable.Rows[j][i].ToString() != "")