各位好,我想请教一下,如果我要对一个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();
        }
    }
}