如何使用asp.net中的数据关系删除行 [英] how to delete rows using data relation in asp.net

问题描述

你好，
如何使用数据实现从存储在sqlerver中的表中删除行
您可以引导或发送任何摘要吗?

hello,
how to delete rows from table which is stored insqlerver using data realation
can u guide or send any snippets

DataColumn parentColumn =
           DataSet1.Tables["person"].Columns["sno"];
        DataColumn childColumn =
           DataSet1.Tables["dept"].Columns["no"];
        // Create DataRelation.
        DataRelation relCustOrder;
        relCustOrder = new DataRelation("CustomersOrders",
            parentColumn, childColumn);
        // Add the relation to the DataSet.
        DataSet1.Relations.Add(relCustOrder);
        //DataSet1.Relations.Add(relCustOrder);
        ForeignKeyConstraint fkeyConstraint = new ForeignKeyConstraint("fkey", parentColumn, childColumn);
        fkeyConstraint.DeleteRule = Rule.SetNull;

从我该怎么做删除行

from what i can i do to delete rows

推荐答案

如果数据库中的关系是级联的，则在该关系的属性中，在插入和更新规范"中，选择级联"进行删除角色.
.net自动删除相关表.

If the relations in DataBase is Cascading,in property of that relation ,in Insert and Update Specification, select Cascade for Delete Role.
.net Automatically delete the related tables.

这篇关于如何使用asp.net中的数据关系删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！