using System;using System.IO;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Data.OracleClient;using System.Drawing;using System.Text;using System.Windows.Forms;//测试数据库连接namespace dbTest{    public partial class Form1 : Form    {        string[] table;        int i = 0;        public Form1()        {            table = new string[20];            InitializeComponent();        }        private void button1_Click(object sender, EventArgs e)        {            //测试,写字符串到文件(文件名:2012-10-10)            string checkStr = "select count(*) from emp";           //时间命名文件            string myFileName = "c:\\" + DateTime.Today.ToShortDateString() + ".txt";            //建立文件流            FileStream fs = new FileStream(myFileName, FileMode.OpenOrCreate);            //建立输入流对象            StreamWriter sw = new StreamWriter(fs);            sw.Write(checkStr);            sw.Flush();            sw.Close();            try            {                //连接 用OracleCommand方法进行简单查询                  string ConString = "Data Source=TEST;user=TEST001;password=123456";                OracleConnection OraConn = new OracleConnection(ConString);                //查询语句                OracleCommand OraCmd = new OracleCommand("select empno from emp", OraConn);                //打开数据连接                OraConn.Open();                //存储过程测试                  //OraCmd.CommandText="proc_test";                //OraCmd.CommandType=CommandType.StoredProcedure;                //OracleCommandBuilder.DeriveParameters(OraCmd);                             DataSet ds1;                ds1 = new DataSet();                OracleDataAdapter da1 = new OracleDataAdapter(OraCmd);//取出数据                   da1.Fill(ds1);                DataTable dt = ds1.Tables[0];                this.dataGridView1.DataSource = dt.DefaultView;                this.dataGridView1.Refresh();//刷新数据控件                //关闭数据连接                OraConn.Close();            }            catch (Exception ex)            {                MessageBox.Show("出错了!!");            }        }    }    }