using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing;
using System.Collections;
using System.IO;
using System.Net;
using System.Text;
using System.Data;
using System.Data.OracleClient;
namespace dome
{
public partial class csv : System.Web.UI.Page
{
private void csv()
{
string connstr = “Data Source=127.0.0.1/orcl;user id=user;PassWord=psword”;
OracleConnection conn = new OracleConnection(connstr);
conn.Open();
string sqlstr = “select * from data”;
OracleCommand CMD = new OracleCommand(sqlstr, conn);
DataSet DS = new DataSet();
OracleDataAdapter da = new OracleDataAdapter(sqlstr, conn);
da.Fill(DS, “table1”);
DataTable dt = DS.Tables[“table1”];
string name = “d:\TEST” + “.csv”;
FileStream fs = new FileStream(name, FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding(“gb2312”));
sw.WriteLine(“name,dm,rq”);
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(dr[“name”] + “,” + dr[“dm”] + “,” + dr[“rq”]);
}
sw.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
csv();
}
}
}
aps.net ,导出股票交易明细数据,转换为csv