MetaModel.Tables 屬性

參考

定義

命名空間:: System.Web.DynamicData

組件:: System.Web.DynamicData.dll

重要

部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。

取得屬於資料模型之所有資料表的集合。

public:
 property System::Collections::ObjectModel::ReadOnlyCollection<System::Web::DynamicData::MetaTable ^> ^ Tables { System::Collections::ObjectModel::ReadOnlyCollection<System::Web::DynamicData::MetaTable ^> ^ get(); };

public System.Collections.ObjectModel.ReadOnlyCollection<System.Web.DynamicData.MetaTable> Tables { get; }

member this.Tables : System.Collections.ObjectModel.ReadOnlyCollection<System.Web.DynamicData.MetaTable>

Public ReadOnly Property Tables As ReadOnlyCollection(Of MetaTable)

屬性值

ReadOnlyCollection<MetaTable>

集合，包含屬於資料模型的資料表。

範例

下列範例示範如何使用 Tables 和 VisibleTables 屬性來執行下列工作：

取得資料模型中所有資料表的集合，並將其顯示在控制項中 GridView 。
取得資料模型中可見資料表的集合，並將其顯示在控制項中 GridView 。

此範例包含頁面及其程式碼後置檔案。

<%@ Page Language="C#" AutoEventWireup="true" 
CodeFile="TablesMenu.aspx.cs" 
Inherits="TablesMenu" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title></title>
</head>
<body>
    <h2>Tables</h2>

    <form runat="server">
   
        <h4>Visible Tables</h4>
        <asp:GridView ID="Menu1" runat="server" 
        AutoGenerateColumns="false">
            <Columns>
                <asp:TemplateField HeaderText="Table Name" SortExpression="TableName">
                    <ItemTemplate>
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%#Eval("ListActionPath") %>'><%#Eval("DisplayName") %></asp:HyperLink>
                    </ItemTemplate>
                </asp:TemplateField>
               
            </Columns>
        </asp:GridView>
 
         <h4>Tables in the Data Model</h4>
        <asp:GridView ID="Menu2" runat="server" 
        AutoGenerateColumns="false">
            <Columns>
                <asp:TemplateField HeaderText="Table Name" SortExpression="TableName">
                    <ItemTemplate>
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%#Eval("ListActionPath") %>'><%#Eval("DisplayName") %></asp:HyperLink>
                    </ItemTemplate>
                </asp:TemplateField>
               
            </Columns>
        </asp:GridView>
        
    </form>
    
</body>

<%@ Page Language="VB" AutoEventWireup="true" 
CodeFile="TablesMenu.aspx.vb" 
Inherits="_TablesMenu" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title></title>
</head>
<body>
    <h2>Tables</h2>

    <form id="Form1" runat="server">
   
        <h4>Visible Tables</h4>
        <asp:GridView ID="Menu1" runat="server" 
        AutoGenerateColumns="false">
            <Columns>
                <asp:TemplateField HeaderText="Table Name" SortExpression="TableName">
                    <ItemTemplate>
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%#Eval("ListActionPath") %>'><%#Eval("DisplayName") %></asp:HyperLink>
                    </ItemTemplate>
                </asp:TemplateField>
               
            </Columns>
        </asp:GridView>
 
         <h4>Tables in the Data Model</h4>
        <asp:GridView ID="Menu2" runat="server" 
        AutoGenerateColumns="false">
            <Columns>
                <asp:TemplateField HeaderText="Table Name" SortExpression="TableName">
                    <ItemTemplate>
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%#Eval("ListActionPath") %>'><%#Eval("DisplayName") %></asp:HyperLink>
                    </ItemTemplate>
                </asp:TemplateField>
               
            </Columns>
        </asp:GridView>
        
    </form>
    
</body>

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Web.DynamicData;
using System.Text;

public partial class TablesMenu : System.Web.UI.Page
{
     protected void Page_Load(object sender, EventArgs e) {
     
         GetVisibleTables();
         GetTables();
    }

    // Gets all the tables in the data model.
    protected void GetTables()
    {
         System.Collections.IList tables = 
             MetaModel.Default.Tables;
         if (tables.Count == 0)
         {
             throw new InvalidOperationException(
                 "There are no tables in the data model.");
         }
         Menu2.DataSource = tables;
         Menu2.DataBind();
     }

    // Gets only the visible tables in the data model.
    protected void GetVisibleTables()
    {
         System.Collections.IList visibleTables =
             MetaModel.Default.VisibleTables;
         if (visibleTables.Count == 0)
         {
             throw new InvalidOperationException(
                 "There are no accessible tables. Make sure that at least one data model is registered in Global.asax and scaffolding is enabled or implement custom pages.");
         }
         Menu1.DataSource = visibleTables;
         Menu1.DataBind();
    }
}

Imports System.Collections
Imports System.Configuration
Imports System.Data
Imports System.Linq
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.HtmlControls
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Xml.Linq
Imports System.Web.DynamicData
Imports System.Text

Partial Public Class _TablesMenu
    Inherits System.Web.UI.Page

    'Protected Sub Page_Init(ByVal sender As Object, ByVal e As EventArgs)
    '    GetVisibleTables()
    '    GetTables()
    'End Sub
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

        'Dim visibleTables As System.Collections.IList = MetaModel.Default.VisibleTables
        'If (visibleTables.Count = 0) Then
        '    Throw New InvalidOperationException("There are no accessible tables. Make sure that at least one data model is registered in Global.asax a" & _
        '        "nd scaffolding is enabled or implement custom pages.")
        'End If
        'Menu1.DataSource = visibleTables
        'Menu1.DataBind()

        GetVisibleTables()
        GetTables()

    End Sub

    ' Gets all the tables in the data model.
    Protected Sub GetTables()
        Dim tables As System.Collections.IList = MetaModel.[Default].Tables
        If tables.Count = 0 Then
            Throw New InvalidOperationException("There are no tables in the data model.")
        End If
        Menu2.DataSource = tables
        Menu2.DataBind()
    End Sub

    ' Gets only the visible tables in the data model.
    Protected Sub GetVisibleTables()
        Dim visibleTables As System.Collections.IList = MetaModel.[Default].VisibleTables
        If visibleTables.Count = 0 Then
            Throw New InvalidOperationException("There are no accessible tables. Make sure that at least one data model is registered in Global.asax and scaffolding is enabled or implement custom pages.")
        End If
        Menu1.DataSource = visibleTables
        Menu1.DataBind()
    End Sub
End Class

備註

集合包含資料模型中的所有資料表，其中包含不可見的資料表 (不屬於動態資料 scaffolding) 。

執行此功能的線上範例。

適用於

共用方式為

MetaModel.Tables 屬性

定義

屬性值

範例

備註

適用於

其他資源