本文介绍了如何执行存储过程。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试创建日志文件,如何在目录路径中出现错误?一个粗体。
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)
更多推荐
如何执行存储过程。
发布评论