各位好,我想请教一下,如果我要对一个AC数据库进行实时监控,并且自动的把最新得到的数据插入到一个SQL数据库,需要怎么做?请高手指点,万分感谢!我是初学者,请多多指教。
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.OleDb;
using System.Data.SqlClient;namespace Water
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
String connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
connectionString += @"f:\water\water.mdb";
OleDbConnection con = new OleDbConnection(connectionString);
con.Open();
String sqlconnectionString = "server=localhost;Initial catalog=inqz;user ID=sa;password=880926;";
SqlConnection conn = new SqlConnection(sqlconnectionString);
conn.Open();
OleDbCommand cmd=con.CreateCommand();
cmd.CommandText = "select * from WaterData";
cmd.CommandType=CommandType.Text;
OleDbDataReader reader=cmd.ExecuteReader();
while (reader.Read())
{
label1.Text = reader["w_s1"].ToString();
SqlCommand sqlcmd = conn.CreateCommand();
sqlcmd.CommandText = "insert into water(w_s1) values("+reader["w_s1"].ToString()+")";
sqlcmd.CommandType = CommandType.Text;
sqlcmd.ExecuteNonQuery();
}
con.Close();
}
}
}
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.OleDb;
using System.Data.SqlClient;namespace Water
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
String connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
connectionString += @"f:\water\water.mdb";
OleDbConnection con = new OleDbConnection(connectionString);
con.Open();
String sqlconnectionString = "server=localhost;Initial catalog=inqz;user ID=sa;password=880926;";
SqlConnection conn = new SqlConnection(sqlconnectionString);
conn.Open();
OleDbCommand cmd=con.CreateCommand();
cmd.CommandText = "select * from WaterData";
cmd.CommandType=CommandType.Text;
OleDbDataReader reader=cmd.ExecuteReader();
while (reader.Read())
{
label1.Text = reader["w_s1"].ToString();
SqlCommand sqlcmd = conn.CreateCommand();
sqlcmd.CommandText = "insert into water(w_s1) values("+reader["w_s1"].ToString()+")";
sqlcmd.CommandType = CommandType.Text;
sqlcmd.ExecuteNonQuery();
}
con.Close();
}
}
}
http://access911.net/fixhtm/72FAB21E11DCE7F3.htm?tt=