How can i export listbox items to csv using asp.net?

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();
    }

I am using this code but not getting output.

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();