本文介绍了用管道写ascii文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家早上好
我有一个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
推荐答案
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文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!