动态数据 - 如何在列表中显示主键字段

发布于 2024-08-07 00:48:31 字数 434 浏览 9 评论 0原文

我终于开始深入研究动态数据（早就应该了）。我注意到，当我查看网站时，主表列表上不会显示主键字段。

例如，我有一个包含状态代码的表，其中包含两个字段。

StatusCode int identity Primary Key
StatusCodeDescription varchar(25)

在我网站的 StatusCodes/List.aspx 页面上，仅显示 StatusCodeDescription。

我意识到我无法编辑主键，但我想显示它。动态数据可以实现这一点吗？

我自己可以想到一些解决方法，老实说，我可以自己进一步深入文档来找到它，但我希望有更多经验的人知道答案，并可以节省我一些寻找的时间。指向适当文档的链接甚至会更好。

原文

I'm finally digging into Dynamic Data (long overdue). I notice that when I'm viewing the web site, on the main table lists, the primary key field is not displayed.

For example, I have a table that holds Status Codes, with two fields.

StatusCode int identity Primary Key
StatusCodeDescription varchar(25)

On my web site's StatusCodes/List.aspx page, only the StatusCodeDescription shows.

I realize that I can't edit the primary key, but I would like to show it. Is this possible with Dynamic Data?

I can think of some workarounds myself, and in all honesty, I could dig into the documentation further to find it myself, but I'm hoping that someone with more experience knows the answer and can save me some time looking. A link to the appropriate documentation would even be good.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

谁的新欢旧爱 2024-08-14 00:48:31

经过一天的大部分时间研究后，我有另一个可能更“正确”的答案。据我所知，这是基于每个表的（这意味着您必须为每个表执行一次）

使用 ScaffoldColumn 属性：

我使用部分类扩展了为表 (StatusCodes) 自动生成的类，如下所示：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.DynamicData;
using System.ComponentModel.DataAnnotations;

namespace ScholarshipAdmin
{
    [MetadataType(typeof(StatusCodesMetaData))]
    public partial class StatusCodes 
    {

    }

    public class StatusCodesMetaData
    {
        [ScaffoldColumn(true)] 
        public object StatusCode;
    }
}

After spending most of the day researching, I have another answer that is probably more "correct". From what I can see, this is on a per table basis (meaning you'd have to do this once per table)

Using the ScaffoldColumn attribute:

I extended the class that is automatically generated for the table (StatusCodes) using a partial class as follows:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.DynamicData;
using System.ComponentModel.DataAnnotations;

namespace ScholarshipAdmin
{
    [MetadataType(typeof(StatusCodesMetaData))]
    public partial class StatusCodes 
    {

    }

    public class StatusCodesMetaData
    {
        [ScaffoldColumn(true)] 
        public object StatusCode;
    }
}

回复收藏 0 原文

給妳壹絲溫柔 2024-08-14 00:48:31

我自己找到了一个可能的答案。我会发布此内容，以防将来其他人来寻找答案。请注意，只有当表都具有单列主键时，这才有效。

我还将保留这个问题，以防其他人有更好、更简单的答案，该答案适用于具有多个主键的表。我宁愿选择别人的答案，也不愿选择我自己的答案。

在 List.aspx 中，我将以下内容添加到 GridView1。

<asp:TemplateField>
   <HeaderTemplate>
      <%# table.PrimaryKeyColumns[0].Name %>
   </HeaderTemplate>
   <ItemTemplate>
      <%# DataBinder.Eval(Container.DataItem, table.PrimaryKeyColumns[0].Name) %>
   </ItemTemplate>
</asp:TemplateField>

I found one possible answer myself. I'll post this in case someone else comes looking for the answer in the future. Note that this will only work if the tables all have a one column primary key.

I'll also keep this question out there in case someone else has a better, simpler answer that will work with tables that have multiple primary keys. I'd rather select someone else's answer than my own.

In the List.aspx, I added the following to GridView1.

<asp:TemplateField>
   <HeaderTemplate>
      <%# table.PrimaryKeyColumns[0].Name %>
   </HeaderTemplate>
   <ItemTemplate>
      <%# DataBinder.Eval(Container.DataItem, table.PrimaryKeyColumns[0].Name) %>
   </ItemTemplate>
</asp:TemplateField>

回复收藏 0 原文