C#和oracle编程

Code部分

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.OracleClient;

 

namespace mc

{

   

   public partial class Form1 : Form

    {

       string strCon = "Server = 127.0.0.1;Data Source = ORCL;UserId=system;Password=123;";

       //利用数据库连接信息创建数据库连接对象

       OracleConnection connection;

       long n;

       

       public Form1()

       {

           InitializeComponent();

           connection = new OracleConnection(strCon);

       }

       private void timer1_Tick(object sender, EventArgs e)//每毫秒执行一次

        {

          

           n++;

           string str = "insert into scott.users6 values(" + n.ToString()+ "," + n.ToString() + "," + n.ToString() + "," +n.ToString() + "," + n.ToString() + "," + n.ToString() +")";

 //          MessageBox.Show(n.ToString());

           OracleCommand command = new OracleCommand(str, connection);

           command.ExecuteNonQuery();

 

 

       }

       private void button1_Click(object sender, EventArgs e)

       {

           Timer timer1 = new Timer();

           timer1.Enabled = true;//设置为truetimer1_Tick实践就会执行，开始计时

           timer1.Interval = 1;//设置timer1的timer1_Tick实践执行周期为毫秒

           timer1.Tick += timer1_Tick;

       }

 

      

 

       private void Form1_Load(object sender, EventArgs e)

       {

           n = 0;

           connection.Open();

           string addtable = "create table scott.users6 (userId Number(15)Primary Key NOT NULL,UserNUM Number(15),UserNUM1 Number(15),UserNUM2Number(15),UserNUM3 Number(15),UserNUM4 Number(15))";

            OracleCommand command = newOracleCommand(addtable, connection);

           command.ExecuteNonQuery();

       }

 

       private void button2_Click(object sender, EventArgs e)

       {

           connection.Close();

       }

 

       private void button3_Click(object sender, EventArgs e)

       {

           string strCom = "SELECT * FROM scott.users6";

           DataSet ds = new DataSet();

           OracleDataAdapter oda = new OracleDataAdapter(strCom, connection);

           oda.Fill(ds);

           dataGridView1.DataSource = ds.Tables[0];

       }

    }

}