LinqDataSource.TableName Property

Gets or sets the name of the property or field in the data context class that represents a data collection.

Namespace:  System.Web.UI.WebControls
Assembly:  System.Web.Extensions (in System.Web.Extensions.dll)

public string TableName { get; set; }
<asp:LinqDataSource TableName="String" />

Property Value

Type: System.String
A string that contains the name of the property that contains the data collection.

Set the TableName property to the name of the property or field that represents the data that you want to retrieve. When you are connecting to a database table, the name of the property is usually the same as the name of the table. When you are connecting to an in-memory data collection, set the TableName property to the name of the property or field that returns the data collection.

You can assign a property that returns any type to the TableName property for retrieval operations. If the object that is represented by the property does not implement IEnumerable, the LinqDataSource control will automatically wrap the object in an instance of an IEnumerable object.

To enable automatic update, insert, or delete operations, the class that is assigned to the ContextTypeName property must derive from DataContext and the property that is assigned to the TableName property must derive from Table<TEntity>.

For information about how to select data from an instance of a class, see the Result property.

The following example shows two LinqDataSource controls. In one LinqDataSource control, the TableName property is set to a property in a class. That property returns an array of strings. In the other LinqDataSource control, the TableName property is set to a property that represents a database table.


<!-- Retrieve and display data from array of string values -->
<asp:LinqDataSource 
    ContextTypeName="MovieLibrary" 
    TableName="AvailableGenres" 
    ID="LinqDataSource1" 
    runat="server">
</asp:LinqDataSource>
<asp:DropDownList 
    DataSourceID="LinqDataSource1"
    runat="server" 
    ID="DropDownList1">
</asp:DropDownList>

<!-- Retrieve and display data from database -->
<asp:LinqDataSource 
    ContextTypeName="ExampleDataContext" 
    TableName="Movies" 
    Select="Title"
    ID="LinqDataSource2" 
    runat="server">
</asp:LinqDataSource>
<asp:DropDownList 
    DataSourceID="LinqDataSource2"
    runat="server" 
    ID="DropDownList2">
</asp:DropDownList>


The class named ExampleDataContext that represents the database table is not shown in this example. For this example to work, you must create this class by adding a LINQ to SQL class named Example.dbml and dragging a table named Movie onto the O/R Designer. A class named ExampleDataContext with a property named Movies is generated.

The following example shows the class named MovieLibrary that is referenced in the LinqDataSource control.


public class MovieLibrary
{
    string[] _availableGenres = { "Comedy", "Drama", "Romance" };

    public MovieLibrary()
    {
    }

    public string[] AvailableGenres
    {
        get
        {
            return _availableGenres;
        }
    }
}


.NET Framework

Supported in: 4, 3.5

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft