using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class Default2 : System.Web.UI.Page
{
private BaseDB db = new BaseDB();
protected void Page_Load(object sender, EventArgs e)
{ }
protected void btnDC_Click(object sender, EventArgs e)
{ DataSet ds = new DataSet();
ds = db.dataSet("select * from User_tab");
//Comm.ex
// DataTable dt = ds.Tables;
DataTable dt = ds.Tables[0];
dt.DataSet.DataSetName = ds.ToString();
HttpContext.Current.Response.Clear(); System.IO.StringWriter sw = new System.IO.StringWriter(); int iColCount = dt.Columns.Count; for (int i = 0; i < iColCount; i++)
{ sw.Write("\"'" + dt.Columns[i] + "\""); if (i < iColCount - 1)
{ sw.Write(","); } } sw.Write(sw.NewLine); foreach (DataRow dr in dt.Rows)
{ for (int i = 0; i < iColCount; i++)
{ if (!Convert.IsDBNull(dr[i])) sw.Write("\"'" + dr[i].ToString() + "\""); else sw.Write("\"\""); if (i < iColCount - 1)
{ sw.Write(","); } } sw.Write(sw.NewLine); } sw.Close(); HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=ss.csv"); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); HttpContext.Current.Response.Write(sw); HttpContext.Current.Response.End();
}
}结果为:
第一列 第二列 第三列
,A ,B .C
,21 ,123 ,213
然后按按钮后下载成CVS文件
需要结果为合并为一列A;B;C;
21;123;213;所有数据都是一列,存放到项目中,随数据库值更新覆盖原来数据更新。因为在是在做amcharts线型图,有没有动态数据源的范例
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class Default2 : System.Web.UI.Page
{
private BaseDB db = new BaseDB();
protected void Page_Load(object sender, EventArgs e)
{ }
protected void btnDC_Click(object sender, EventArgs e)
{ DataSet ds = new DataSet();
ds = db.dataSet("select * from User_tab");
//Comm.ex
// DataTable dt = ds.Tables;
DataTable dt = ds.Tables[0];
dt.DataSet.DataSetName = ds.ToString();
HttpContext.Current.Response.Clear(); System.IO.StringWriter sw = new System.IO.StringWriter(); int iColCount = dt.Columns.Count; for (int i = 0; i < iColCount; i++)
{ sw.Write("\"'" + dt.Columns[i] + "\""); if (i < iColCount - 1)
{ sw.Write(","); } } sw.Write(sw.NewLine); foreach (DataRow dr in dt.Rows)
{ for (int i = 0; i < iColCount; i++)
{ if (!Convert.IsDBNull(dr[i])) sw.Write("\"'" + dr[i].ToString() + "\""); else sw.Write("\"\""); if (i < iColCount - 1)
{ sw.Write(","); } } sw.Write(sw.NewLine); } sw.Close(); HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=ss.csv"); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); HttpContext.Current.Response.Write(sw); HttpContext.Current.Response.End();
}
}结果为:
第一列 第二列 第三列
,A ,B .C
,21 ,123 ,213
然后按按钮后下载成CVS文件
需要结果为合并为一列A;B;C;
21;123;213;所有数据都是一列,存放到项目中,随数据库值更新覆盖原来数据更新。因为在是在做amcharts线型图,有没有动态数据源的范例
System.IO.StreamWriter sw = new System.IO.StreamWriter(Server.MapPath("~/xx.csv"));就可以了