sql - 中继器从许多表中显示相同的值

Question

对不起，糟糕的帖子和英语，我是 stackoverflow 的新手。

我已经为包含多对多表的联合表编写了一个复杂的 SQL 注释。

当我执行查询时，它会返回正确的数据。我在转发器中使用这个视图。它显示来自多对多表的相同值。我已经尝试了我所知道的一切，但无法解决我的问题。我希望你能明白我的意思。我添加了代码和结果。

SELECT   ROW_NUMBER() OVER (ORDER BY secID,ListID,ord) ROW_NUM, *
FROM  (SELECT        dbo.MotorList.section_id AS 'secId' ,dbo.MDIsignal.name AS Sname, dbo.MotorList.mList_id AS 'ListID', dbo.MotorType.name AS Type, dbo.Project.project_id, dbo.Section.code, dbo.MotorList.Mindex AS 'Index', dbo.MotorList.stat AS 'Stat', dbo.MotorList.description

FROM            dbo.MDI INNER JOIN
                         dbo.MDIsignal ON dbo.MDI.mDIsgnl_id = dbo.MDIsignal.mDIsgnl_id INNER JOIN
                         dbo.MotorList ON dbo.MDI.mList_id = dbo.MotorList.mList_id INNER JOIN
                         dbo.Section ON dbo.MotorList.section_id = dbo.Section.section_id INNER JOIN
                         dbo.Project ON dbo.Section.project_id = dbo.Project.project_id INNER JOIN
                         dbo.MotorType ON dbo.MotorList.motor_id = dbo.MotorType.motor_id
  UNION 
SELECT        dbo.MotorList.section_id AS 'secId' ,dbo.MDOsignal.name AS Sname, dbo.MotorList.mList_id AS 'ListID', dbo.MotorType.name AS 'Type', dbo.Project.project_id, dbo.Section.code, dbo.MotorList.Mindex AS 'Index', dbo.MotorList.stat AS 'Stat', dbo.MotorList.description 

FROM        dbo.MDO INNER JOIN
                         dbo.MDOsignal ON dbo.MDO.mDOsgnl_id = dbo.MDOsignal.mDOsgnl_id INNER JOIN
                         dbo.MotorList ON dbo.MDO.mList_id = dbo.MotorList.mList_id INNER JOIN
                         dbo.Section ON dbo.MotorList.section_id = dbo.Section.section_id INNER JOIN
                         dbo.Project ON dbo.Section.project_id = dbo.Project.project_id INNER JOIN
                         dbo.MotorType ON dbo.MotorList.motor_id = dbo.MotorType.motor_id
)a

此处返回 SQL 的正确值

这里我如何绑定转发器来查看：

        var list = db.SignalList_S.Where(a => a.secId == sec_id).ToList();
        RptListe.DataSource = list;
        RptListe.DataBind();

这里显示转发器相同的值

我标记了一些值以便更容易显示。

标签： sqlasp.netsql-serverwebformsasprepeater