如何执行存储过程。

本文介绍了如何执行存储过程。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试创建日志文件，如何在目录路径中出现错误？一个粗体。

I am trying to create log file, how come is there an erro in the directory path? the one bolded.

public static void LogFileWrite(string message) { FileStream fileStream = null; StreamWriter streamWriter = null; }

推荐答案

// declare your dataset here.. DataSet ds = new DataSet(); using (SqlConnection conn = new SqlConnection("Connection String")) { SqlCommand sqlComm = new SqlCommand("dbo.Test", conn); sqlComm.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(sqlComm); //DataSet ds = new DataSet(); da.Fill(ds); } //create csv file StreamWriter sw = null; StringBuilder sb = new StringBuilder(); foreach (DataTable dt in ds.Tables) { sw = new StreamWriter(string.Format(@"C:\Users\GP Test Folder\Export" + datetime.ToString("dd-MM-yyyy_hh-mm-ss") + ".csv", dt.TableName)); for (int i = 0; i < dt.Rows.Count; i++) { sb.Clear(); for (int j = 0; j < dt.Columns.Count; j++) { sb.Append(dt.Rows[i][j]); if (j == (dt.Columns.Count - 1)) sb.Append(","); } sw.WriteLine(sb.ToString()); } sw.Close(); }

您还没有在文件名中包含表名。

Also you haven't include table name in your file name.

string.Format(@"C:\Users\GP Test Folder\Export{0}" + datetime.ToString("dd-MM-yyyy_hh-mm-ss") + ".csv", dt.TableName)