向ACCESS关系表中 删除同步,更新同步。带图的（DataSet类）

Question

关系表报错
我想对 CARD-USAGE-ONLINE表 删除同步,更新同步 应该怎么做 
我是个初学者，能不能给代码。
问题好久了，有点急。望知道的老师,帮助下，谢谢了。谢谢大家。
我自己在谷歌上和CSDN上，都找过了。没有找到想要的答案。55555555

Answer 1

TRANSFER表中没有数据
只对CARD-USAGE-ONLINE表 删除同步,更新同步

Answer 2

access数据库可以创建触发器？

Answer 3

ivony 怎么不来回答我的提问那 ？？
5555555555555

Answer 4

 OleDbConnection oleCon1 = new OleDbConnection(strPath);
     oleCon1.Open();
    string ls_id = "0";
    while(i<n)
    {
               
        ls_id = "0";
          OleDbDataAdapter oleDap1 = new OleDbDataAdapter("insert into card(code,cardtype,kind,owndate,idkind,name,sex,birthdate,address,country,state,hoststate,membercode,keyword,gradeid,contact,profession,balance,consumed,limit) values('" + wangdunlist[i]+ "',0,1,'0:00:00',11,'等待验证…',1,'0:00:00','-','未知',0,'00000','" + wangdunlist[i] + "','11',0,'-','-',0,0,0)", oleCon1);
                DataSet ds1 = new DataSet();
                oleDap1.Fill(ds1, "card");
                       
                ds1.Dispose();
             oleDap1.Dispose();
            
         OleDbDataAdapter oleDap2 = new OleDbDataAdapter("select * from card", oleCon1);
                DataSet ds2 = new DataSet();
                oleDap2.Fill(ds2, "card");
                
                ls_id = ds2.Tables[0].Rows[i][0].ToString();
                ds2.Dispose();
             oleDap2.Dispose();
             oleCon1.Close();
             oleCon1.Open();
        OleDbDataAdapter oleDap3 = new OleDbDataAdapter("insert into usage(cardid,price,charge,times,starttime,endtime,state,grade) values(" + ls_id + " ,0,0,0,'" + maskedTextBox1.Text + "','" + maskedTextBox1.Text + "',1,0)", oleCon1);
         DataSet ds3 = new DataSet();//为什么会在这里报错那 。前一个都成功了 
          oleDap3.Fill(ds3, "usage");
          ds3.Dispose();
          oleDap3.Dispose();
           ls_id="0";
           
                 OleDbDataAdapter oleDap4 = new OleDbDataAdapter("select * from usage", oleCon1);
                DataSet ds4 = new DataSet();
                oleDap4.Fill(ds4, "usage");
                ls_id = ds4.Tables[0].Rows[i][0].ToString();
                ds4.Dispose();
             oleDap4.Dispose();             OleDbDataAdapter oleDap5 = new OleDbDataAdapter("insert into online(uaageid,terminalid,STARTTIME,TIMEFLAG,innerip,state) values(" + ls_id+ " ," + wangdunlid[i] + ",'" + maskedTextBox1.Text + "','" + maskedTextBox1.Text + "','" + wangdunlip[i] + "',1)", oleCon1);
         DataSet ds5 = new DataSet();
          oleDap5.Fill(ds5, "online");
          
          ds5.Dispose();
          oleDap5.Dispose();
          i = i + 1;    }
        
         

Answer 5

额滴神啊……
老实说完全么看懂代码，LZ应该多看几本书弄清楚DataAdapter和DataSet都是啥。

Answer 6

Ivony 
我查了下。
好多地方看不懂。还是不知道怎么用！

Answer 7

插入USAGE表时报错。到底那里用的不对。望高手指点。含泪致谢。using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Security.Cryptography;
using System.Data.OleDb;namespace text
{    public partial class Form1 : Form
    {
        public string strPath = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:DataBase Password='ddccnn';User Id=admin;Data source=" + Application.StartupPath + "\\bar2003.mdb";//加入的数据库
        public Form1()
        {
            InitializeComponent();
        }        private void button1_Click(object sender, EventArgs e)
        {
            //这个代码只插入一条语句的事例
            OleDbConnection oleCon1 = new OleDbConnection(strPath);
         string      ls_id = "0";
            // 向CARD表插入数据
          OleDbDataAdapter oleDap1 = new OleDbDataAdapter("insert into card(code,cardtype,kind,owndate,idkind,name,sex,birthdate,address,country,state,hoststate,membercode,keyword,gradeid,contact,profession,balance,consumed,limit) values('0012319197',0,1,'0:00:00',11,'等待验证…',1,'0:00:00','-','未知',0,'00000','0012319197','11',0,'-','-',0,0,0)", oleCon1);
                DataSet ds1 = new DataSet();
                oleDap1.Fill(ds1, "card");
                       
                ds1.Dispose();
             oleDap1.Dispose();
            //获取card表刚加入的ID
         OleDbDataAdapter oleDap2 = new OleDbDataAdapter("select * from card", oleCon1);
                DataSet ds2 = new DataSet();
                oleDap2.Fill(ds2, "card");
                
                ls_id = ds2.Tables[0].Rows[0][0].ToString();
                ds2.Dispose();
             oleDap2.Dispose();
             oleCon1.Close();
             oleCon1.Open();
            //向USAGE表插入数据
        OleDbDataAdapter oleDap3 = new OleDbDataAdapter("insert into usage(cardid,price,charge,times,starttime,endtime,state,grade) values(" + ls_id + " ,0,0,0,'2008-02-06 12:23:56',''2008-02-06 12:23:56',1,0)", oleCon1);
     
         DataSet ds3 = new DataSet();
          oleDap3.Fill(ds3, "usage");
          ds3.Dispose();
          oleDap3.Dispose();
           ls_id="0";
           //获得USAGE表刚加入的ID
                 OleDbDataAdapter oleDap4 = new OleDbDataAdapter("select * from usage", oleCon1);
                DataSet ds4 = new DataSet();
                oleDap4.Fill(ds4, "usage");
                ls_id = ds4.Tables[0].Rows[0][0].ToString();
                ds4.Dispose();
             oleDap4.Dispose();
//向ONLInE表插入数据
             OleDbDataAdapter oleDap5 = new OleDbDataAdapter("insert into online(uaageid,terminalid,STARTTIME,TIMEFLAG,innerip,state) values(" + ls_id + " ,21,'2008-02-06 12:23:56','2008-02-06 12:23:56','192.168.1.6',1)", oleCon1);//这里的terminalid 和innerip 取自TERMINAL表
         DataSet ds5 = new DataSet();
          oleDap5.Fill(ds5, "online");
          
          ds5.Dispose();
          oleDap5.Dispose();
        }        private void button2_Click(object sender, EventArgs e)
        {
            OleDbConnection oleCon1 = new OleDbConnection(strPath);
            oleCon1.Open();
            OleDbDataAdapter oleDap1 = new OleDbDataAdapter("delete from card", oleCon1);//删除数据库数据
            DataSet ds1 = new DataSet();
            oleDap1.Fill(ds1, "card");
            oleCon1.Close();
            oleCon1.Dispose();
        }        private void Form1_Load(object sender, EventArgs e)
        {        }
    }
}

Answer 8

Ivony 可以加下我的QQ吗 121688608 
或者我把数据库发给你。

Answer 9

access的日期格式...
是#2008-XX-XX#
不是'2008-XX-XX'
:)