如何使用ASP.NET将ListBox项目导出到CSV

Question

protected void Button2_Click1(object sender, EventArgs e)
        {
        StreamWriter myOutputStream = new StreamWriter("Myfile.csv");
        foreach (var item in urlLst.Items)
        {
            myOutputStream.WriteLine(item.ToString());
        }
        myOutputStream.Close();
    }

我正在使用此代码，但没有输出。

Answer 1

Hi You can try the below code sample.
            int items = 10; //ListBoxItems.Items.Count;
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < items; i++)
            {
                sb.AppendLine(i.ToString()); //Loop through and get list box item values
            }
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=ListBox_Contents.csv");
            Response.Charset = "";
            Response.ContentType = "application/vnd.csv";
            StringWriter stringWrite = new StringWriter(sb);
            HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
            Response.Write(stringWrite.ToString());
            Response.End();