前台代码
<asp:Button runat="server" ID="btnDC" Text ="导出CSV" οnclick="btnDC_Click"/>
后台代码
protected void btnDC_Click(object sender, EventArgs e)
{
DataTable dt = WorkOrderQuery.FindMyOrderList(358, 1, 100, "");//数据源
try
{
StringWriter swCSV = new StringWriter();
//列名
swCSV.WriteLine("工单编号,工单标题,工单类型,创建时间,当前状态,当前节点名称,当前处理人 ");
//遍历datatable导出数据
foreach (DataRow drTemp in dt.Rows)
{
StringBuilder sbText = new StringBuilder();
sbText = AppendCSVFields(sbText, drTemp["WORK_ORDER_ID"].ToString());
sbText = AppendCSVFields(sbText, drTemp["work_order_title"].ToStri