usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data.OracleClient;usingSystem.Data;usingSystem.IO;namespaceTextCSV
{classProgram
{static void Main(string[] args)
{//用provide 报错,去掉就好了,注意需要引用oracleclient
string strCon = "Password=egdb;User ID=egdb;Data Source=egdb;Persist Security Info=True";
OracleConnection con= newOracleConnection(strCon);
con.Open();
OracleCommand cmd= newOracleCommand();
cmd.Connection=con;
cmd.CommandText= "select * from menu_perm";
cmd.CommandType=CommandType.Text;
OracleDataAdapter ad= newOracleDataAdapter(cmd);
DataSet ds= newDataSet();
ad.Fill(ds);
con.Close();using (StreamWriter streamWriter = new StreamWriter(@"d:\1.csv", false, Encoding.Default))
{if (ds.Tab