如何删除和更新两个Master&细节表同时？ [英] how to delete and update two Master & Detail tables smultaneously?

问题描述

嗨。



我为大学系统建了一个数据库。在其中一个部分我有3个表（Person，Universtiy，PersonUniversity）。



i在Asp.net4中也有一个表单，当有人在这些表中插入任何数据时两个表格将出现一个gridview。



问题是，当我按下网格视图中的删除按钮或更新按钮时，它们不起作用。



1）问题是什么？



2）如果问题涉及Master&详细信息，那么如何在SqlServer中将存储过程写入删除 gridview中的Selected行以及同时在两个表（Universtiy，PersonUniversity）中？



3）如何在SqlServer中将存储过程写入更新 gridview中的Selected行以及同时在两个表（Universtiy，PersonUniversity）中？

Hi.

I have made a database for university system. in one of its part i have 3 tables (Person , Universtiy , PersonUniversity).

i also have a form in Asp.net4 that when some one insert any data inside these two tables a gridview will be appeared .

the problem is that when i press Delete button or Update button in the gridview ,they don''t work.

1) what is the problem ?

2) if the problem refers to Master & Details , so how can i write a Stored Procedure in SqlServer to Delete the Selected Row in gridview and also in both tables (Universtiy , PersonUniversity) simultaneously?

3) and how can i write a Stored Procedure in SqlServer to Update the Selected Row in gridview and also in both tables (Universtiy , PersonUniversity) simultaneously?

推荐答案

您好，



请按照以下链接获取答案。



ASP.NET 2.0的GridView示例：删除GridView的基础数据

如何从gridview中删除行行命令事件

如何使用rowd删除gridview中的行举办活动

GridView删除，确认



尝试使用链接概念，您将能够删除/更新您的行。



谢谢

Hi,

Follow the following links for your answer.

GridView Examples for ASP.NET 2.0: Deleting a GridView''s Underlying Data
How to remove row from gridview on row command event
how to delete row in gridview using rowdeleting event
GridView Delete, with Confirmation

Try using the links concepts and you will able to delete/update your rows.

Thanks

创建表之间的关系

这篇关于如何删除和更新两个Master&细节表同时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！