Datatable转txt文本格式

在C#编程过程中，我们会把数据库查询出来的数据放到datatable中。在这里我利用SaveFileDialog控件来输出文本形式的代码

public int outTxt(string path, DataTable dt)

        {
            int flag = 0;
            StringBuilder s_column = new StringBuilder();
            StringBuilder s_values = new StringBuilder();

            StreamWriter sw = new StreamWriter(new FileStream(path, FileMode.CreateNew), Encoding.GetEncoding("utf-8"));//强转utf8
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                s_column.Append(dt.Columns[i].ColumnName);
                s_column.Append(",");
            }
            try
            {
                s_column.Remove(s_column.Length - 1, 1);
                //sw.WriteLine(s_column);
                foreach (DataRow dr in dt.Rows)
                {
                    s_values.Remove(0, s_values.Length);
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        s_values.Append(dr[i].ToString());
                        s_values.Append(",");

                    }
                    s_values.Remove(s_values.Length - 1, 1);
                    sw.WriteLine(s_values);
                }
                sw.Close();
                flag = 1;

            }
            catch (IOException err)
            {
                flag = 0;
                throw new Exception(err.ToString());
            }
            return flag;
        }