- private static void WriteHeader(SqlDataReader reader, TextWriter output)
- {
- for (int i = 0; i < reader.FieldCount; i++)
- {
- if (i > 0)
- output.Write(',');
- output.Write(reader.GetName(i));
- }
- output.WriteLine();
- }
- private static void WriteData(SqlDataReader reader, TextWriter output)
- {
- for (int i = 0; i < reader.FieldCount; i++)
- {
- if (i > 0)
- output.Write(',');
- String v = reader[i].ToString();
- if (v.Contains(',') || v.Contains('\\n') || v.Contains('\\r') || v.Contains('"'))
- {
- output.Write('"');
- output.Write(v.Replace("\\"", "\\"\\""));
- output.Write('"');
- }
- else
- {
- output.Write(v);
- }
- }
- output.WriteLine();
- }
- //该片段来自于http://www.codesnippet.cn/detail/1310201513798.html
来源: http://www.codesnippet.cn/detail/1310201513798.html