如何在vb.net中同时更新多个表 [英] how to update multiple tables simultaneously in vb.net

问题描述

如何同时更新vb.net中的表格。



这是我有2个表名称数据和排序。

如果我在数据表中进行任何更改/更新也会在排序表中反映出来。



i最初通过创建
$同时插入多个表b $ b 2插入查询用分号分隔。



像supose我在数据表中输入输入值，所以我的相同值也被插入到排序表中。



但同样如何更新和删除查询。



任何人都可以帮助我。

How to update tables in vb.net simultaneously.

that is i have 2 tables name data and sort.
if i make any changes/updation in data table that change will also be reflected in sort table also.

i had initially done insertion to multiple tables simultaneously by creating
2 insert query separated by semi colon.

like supose i enter enter values in data table, so my same values were getting inserted in sort table also.

but same way how to do the updation and delete query.

can anyone help me please.

推荐答案

如果我没错，你想在多个表上进行插入/更新/删除操作。



那么，在这种情况下，你为什么要查询？

只需调用存储过程并传递所有参数。



在该程序中，只需插入/更新/删除到具有相应数据的表格。

If I am not wrong, you want to do Insert/Update/Delete operations on multiple tables.

So, in that case, why are you going for queries?
Just call a Stored Procedure and pass all the parameters.

Inside that procedure, just Insert/Update/Delete to the tables with respective data.

如果您使用的是SQL Server 2005或更高版本，请尝试使用OUTPUT子句。

If you are using SQL Server 2005 or higher try making making use of the OUTPUT clause.

尝试 SQL SERVER - 2005 - OUTPUT子句示例和INSERT，UPDATE，DELETE解释 [< a href =http://blog.sqlauthority.com/2007/10/01/sql-server-2005-output-clause-example-and-explanation-with-insert-update-delete/\"target =_ blank title =新窗口> ^ ]

这篇关于如何在vb.net中同时更新多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！