如何执行存储过程。 [英] How do I execute Stored Procedure.

问题描述

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

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)

这篇关于如何执行存储过程。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！