如何通过vb.net将表数据移动到另一个表中 [英] How to move table data to another table in access through vb.net
问题描述
如何将表数据移动到Access中的另一个表.我有两种形式,例如availablecomp(Form1).vb和soldcomp(Form2).vb,还有两种表,例如msaccess中数据库中的avacomp和sldcomp,当我出售计算机时.像公司名称,类别,日期,价格这样的avacomp中的数据应该移到sldcomp表中...我想在datagrid视图中看到它...在vb.net中如何操作请帮助我不要有关ms访问权限... ..this我的项目请提供帮助,....
How to move table data to another table in access. i have have two forms like availablecomp(Form1).vb and soldcomp(Form2).vb and two tables like avacomp and sldcomp in database in ms access ..when i sell a computer. that datas in avacomp like companyname,category,date, price should move to sldcomp table...i want see this in datagrid view...how to do in vb.net Please help i don''t about ms access.....this my project please help , kindly....
推荐答案
您可以通过多种方式执行此任务
1.使用批量插入
2.通过插入+选择查询
并可以通过选择查询来简单地显示到网格.
You can do this task by many ways
1. by using bulk insert
2. by Insert + select Query
and simple by select query you can display to the grid .
复制表,然后删除表.........
copy table and then delete table.........
这篇关于如何通过vb.net将表数据移动到另一个表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!