用管道写ascii文件 [英] write ascii file with pipe deliminate

问题描述

大家早上好

我有一个SQL视图，它有5个字段.我需要使用分隔符(|)将视图数据写入ASCII文件.请任何人帮助我，并为我提供简单方便的资源.

我正在将Visual Studio 2008与C#和Sql Server 2008一起使用.
谢谢

Hi,

Good morning everyone,

I have one sql view and its have 5 field. I need to write that view data into ASCII file with deliminater (|). please anyone help me and provide me good and easy source.

I''m using Visual Studio 2008 with C# and Sql server 2008.

Thanks

推荐答案

我不确定这是给您带来问题的哪一部分，但是您可以从这里进行:

I''m not sure what part of this is giving you problems, but here you go:

private void createFlatFile(SqlDataAdaptor da)
    {
    DataTable dt = new DataTable();
    da.Fill(dt, "myTableName");
    DataView dv = dt.DefaultView;
    List<string> lines = new List<string>();
    foreach (DataRowView row in dv)
        {
        StringBuilder sb = new StringBuilder();
        string sep = "";
        for (int i = 0; i < dv.Table.Columns.Count; i++)
            {
            sb.Append(sep + row[i].ToString());
            sep = "|";
            }
        lines.Add(sb.ToString());
        }
    File.WriteAllLines(@"File:\Temp\myFlatFileWithSeperators.txt", lines.ToArray());
    }

:-O我将分隔符放在数据之后而不是之前. :-O-OriginalGriff [/edit]

[edit] :-O I put the separator after the data instead of before. :-O - OriginalGriff[/edit]

这篇关于用管道写ascii文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！