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];
}
}
}