ASP.NET Dynamic Data

The filter control 'CategoryFilter' does not support this operation because it is associated with an unsupported column 'Name'.

levalencia — Fri, 05 Sep 2008 21:15:36 GMT

I tried this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.DynamicData;
using System.Xml.Linq;
using System.Web;
using System.Web.Security;
using System.Data;
using System.ComponentModel.DataAnnotations;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.ComponentModel;
using Microsoft.Web.DynamicData;

namespace Sodexo.Entities
{
    [MetadataType(typeof(AssetMetaData))]
    public partial class Asset
    {

    }

    [DisplayName("Activo")]
    public class AssetMetaData
    {
        public object Id { get; set; }


        [DisplayName("Nombre Activo")]
        [Filter(FilterControl = "AutoComplete")]
        [Required(ErrorMessage = "Este campo es Requerido")]
        public object Name { get; set; }

        [Required(ErrorMessage = "Este campo es Requerido")]
        [DisplayName("Descripción Activo")]

        public object Description { get; set; }

        [Required(ErrorMessage = "Este campo es Requerido")]
        [DisplayName("Marca")]
        public object Brand { get; set; }

        [Required(ErrorMessage = "Este campo es Requerido")]
        [DisplayName("Modelo")]
        public object Model { get; set; }

        [Required(ErrorMessage = "Este campo es Requerido")]
        [DisplayName("Serial")]
        public object Serial { get; set; }

        [Required(ErrorMessage = "Este campo es Requerido")]
        [DisplayName("Ubicación")]
        public object Location { get; set; }

        [DisplayName("Sucursal")]
        public object Branch { get; set; }

        [Required(ErrorMessage = "Este campo es Requerido")]
        [DisplayName("Capacidad")]
        public object Capacity { get; set; }

        [DisplayName("Tipo de Servicio")]
        public object ServiceType { get; set; }
    }
}

But I got an error on debuggin time

The filter control 'CategoryFilter' does not support this operation because it is associated with an unsupported column 'Name'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The filter control 'CategoryFilter' does not support this operation because it is associated with an unsupported column 'Name'.

Source Error:

Line 32:     protected void Page_Init(object sender, EventArgs e) {
Line 33:         if (!Page.IsPostBack) {
Line 34:             PopulateListControl(DropDownList1);
Line 35:
Line 36:             // Set the initial value if there is one

Does it make sense??

Please help!!

Thank you veyr much!

Modify Default.aspx to list recent changes

kisyv — Sun, 15 Nov 2009 17:28:09 GMT

Im playing with DD Linq-to-SQL and started thinking of having a "recent 10 DVDs in my collection" list in the Default.apsx

What is the easiest way to do this?

Dynamic data controls: default values on Insert-page

epb1 — Thu, 19 Nov 2009 13:16:30 GMT

I use dynamic data controls. When I load the Insert.aspx page I want to be able to set some default values, so the user won't have to enter these when inserting a new item. How can I do that? By altering the DetailsView control on the page? How?

How to search grid results based on user provided values?

jfaigan — Mon, 06 Oct 2008 23:54:41 GMT

I would like a user to be able to enter some criteria in a search box and then have them click on a search button to filter the data using a "contains" logic and not an exact match.

Anyone know if this is possible?

I have downloaded the DynamicFilterRepeater and that works well, but you end up with one search box per colulmn...I would like to have one search box that columns could subscribe to and that would be filtered automatically.

Not sure how to go about doing something like that...I'm still quite new to DD and I am still trying to get a grasp on the basic stuff.

Regards,
Joel.

Defining the Binding objects property name

kwcoffee1 — Thu, 19 Nov 2009 23:54:31 GMT

Hi,

Your help is greatly appreciated. The following code snippet displays the
Object Data OK... but if I try to update the edited fields SeqNum or Title I
get the following error message:

Could not find a property named 'SeqNum' on the type specified by the
DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.

How do I define the Binding objects property names ??

<asp:GridView ID="GridView1" Runat="server" DataSourceID="ObjectDataSource1"
    AutoGenerateColumns="False" Width="100%" DataKeyNames="PicID" />
    <Columns>
        <asp:templatefield HeaderText="Sequence" ItemStyle-Width="50px" >
<itemtemplate>
                <%#Eval("SeqNum")%>
</itemtemplate>
<edititemtemplate>
                <asp:TextBox ID="txtSeq" runat="server"
                     Text='<%#Bind("SeqNum")%>' />
                <asp:RequiredFieldValidator
                     ID="RequiredFieldValidator1" runat="server"
                     ControlToValidate="txtSeq"
                     Text="require" />
</edititemtemplate>
<itemstyle verticalalign="middle" width="50px" />
            </asp:templatefield>
        <asp:templatefield HeaderText="Title">
<itemtemplate>
                <%#Eval("Title")%>
</itemtemplate>
             <edititemtemplate>
                <asp:TextBox ID="txtTitle" runat="server"
                     Text='<%#Bind("Title")%>' Width="300px" />
</edititemtemplate>
<itemstyle verticalalign="middle" width="50%" />
       </asp:templatefield>
   </Columns>

<asp:ObjectDataSource ID="ObjectDataSource1"
    TypeName="BOL.Pics"
    DataObjectTypeName="BOL.Pics"
    SelectMethod="GetPics"
    UpdateMethod="Update"
    DeleteMethod="Delete"
    Runat="server" >
    <UpdateParameters>
        <asp:Parameter Name="PicID", Type="Int32" />
        <asp:Parameter Name="SeqNum", Type="Int32" />
        <asp:Parameter Name="Title" />
    </UpdateParameters>
    <DeleteParameters>
        <asp:Parameter Name="PicID", Type="Int32" />
        <asp:QueryStringParameter QueryStringField="AptID" Type="Int32"
Name="AptId" />
    </DeleteParameters>
    <SelectParameters>
        <asp:QueryStringParameter QueryStringField="AptID" Type="Int32"
Name="AptId" />
    </SelectParameters>
</asp:ObjectDataSource>

namespace BOL
{
     public class Pics
    {
        private readonly string _conString;

        public Pics()
        {
            _conString = ConfigurationManager.
                ConnectionStrings["MyDataConnectionString"].ConnectionString;
        }

        public static void DeletePicsByApt(int AptID)
        {
            DBAccess db = new DBAccess(false);
            db.CommandText = "DELETE FROM pics " +
                "WHERE AptId='" + AptID.ToString() + "'";
        }

        public SqlDataReader GetPics(int AptID)
        {
            // Create Command
            SqlConnection con = new SqlConnection(_conString);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "SELECT * FROM pics " +
                "WHERE AptId=@AptID " +
                "ORDER BY SeqNum ASC";

            // Add Parameters
            cmd.Parameters.AddWithValue("@AptId", AptID);

            // Execute Comand
            con.Open();
            return cmd.ExecuteReader(CommandBehavior.CloseConnection);
        }

        public void Update(int PicID, int SeqNum, String Title)
        {
            // Create Command
            SqlConnection con = new SqlConnection(_conString);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "UPDATE pics SET " +
                "SeqNum=@SeqNum, " +
                "Title=@Title " +
                "WHERE PicID=@PicID";

            // Add Parameters
            cmd.Parameters.AddWithValue("@PicID", PicID);
            cmd.Parameters.AddWithValue("@SeqNum", SeqNum);
            cmd.Parameters.AddWithValue("@Title", Title);

            // Execute Command
            using (con)
            {
                con.Open();
                cmd.ExecuteNonQuery();
            }
         }

How to filter out certain FK fields

steddyman — Fri, 20 Nov 2009 11:18:52 GMT

I have a requirement to extend the standard FK Edit functionality to remove FK entries that have an Active column with a value of 0.

So the example data structure is:

id - PK

Name - Name of FK entry

Active - 0 or 1 - If 1 Display in drop down else do not display

I also want these entries to be shown in full in the standard Dynamic Data site, but not shown on my custom ASP.NET pages using DD.

My understanding of what I would need to do is:

1. Create a new version of ForeignKey_Edit that filters out entries where Active==0. Call this FilteredKey_Edit

2. On the Custom Pages, use the UIHint parameter in the DD field to remove those entries

What I can't understand is how to do step 1. Looking at ForeignKey_Edit.ascx.cs there is no obvious way to remove columns base on this extra field.

Thanks

Need help specifying MetaData at runtime

xaeryan — Fri, 13 Nov 2009 14:24:51 GMT

I am trying to dynamically generate Meta Data at runtime. It seems the InMemoryMetadataManager can do so, however I'm having difficulty using and understanding it.

The examples I've seen are poor in that it doesn't really say what's all that different about this method. What's the difference between putting a range on a partial class (the classic way) and a range using InMemoryMetadataManager in the global.asax (as seen in the example)?

What I would rather, I think, is a setup where I create a class that inherits from InMemoryMetadataManager. In that InMemoryMetadataManager class, I'd like a method that (and this is the key) uses some current attributes of the model (like what TABLE name, COLUMN name, CURRENT KEYs, etc.) to lookup metadata from a metadata reference table. It appears this example (http://lecanutechnotes.blogspot.com/2009/01/i-read-article-from-marcin-on-asp.html) might be part of what I need, but it's a standalone class that is just called during global.asax startup, not a ProviderImplementation.

Matt or Steve's example of a custom meta provider is sorta what I need, but add the ability to use the column/table/current key in order to lookup multiple metadata fields and apply them.
(http://mattberseth.com/blog/2008/08/dynamic_data_and_custom_metada.html)
(http://csharpbits.notaclue.net/2008/10/dynamic-data-custom-metadata-providers.html)

Does this make any sense?

Getting Boolean_Edit to trigger a page event when changed

steddyman — Wed, 18 Nov 2009 13:29:54 GMT

My Dynamic Data application is making use of asp:DynamicControl fields to show columns from the database.

I have a field which a checkbox (Boolean data type) that when enabled, I want it to automatically enable an associated textbox, but when disabled it should disable the textbox.

With standard ASP.NET controls I could just use AutoPostBack and trigger my code in the code behind.

I can't understand how I can do this for a DynamicControl that does not contain that property.

Thanks

DD gridview export

hughgallagher — Wed, 18 Nov 2009 10:18:42 GMT

Hi,

I need to export the DD generated datagrid to Excel and PDF format. Just not sure how thats done....

One to one relationship(Class Table Inheritance)

isvaljek — Wed, 18 Nov 2009 08:49:25 GMT

Is it possible to setup dynamic data website so that it displays a table join between general_product_info and specific_product_info tables(tblProducts 1-1 tblGloves).

I'm reffering to this setup: http://martinfowler.com/eaaCatalog/classTableInheritance.html

Currently, in the list view, it lists products and there's a linkbutton column to the gloves table and that breaks the deal because it allows users to insert multiple gloves under one product item(and that's disallowed by unique index idProd in gloves table)

tblProducts

-idProd [PK]

-name

...

tblGloves

-idGlove [PK]

-idProd [Unique IX, FK]

...

Entity Template - can't find control within it

xaeryan — Mon, 16 Nov 2009 14:40:06 GMT

I customized my EntityTemplate to include an extra row above the existing row as follows:

<asp:EntityTemplate runat="server" ID="EntityTemplate1">
    <ItemTemplate>
        <tr runat="server" id="trTop">
            <td colspan="2"><asp:Label ID="lblSummary" runat="server" OnInit="Summary_Init" /></td>
        </tr>
        <tr class="td">
            <td class="DDLightHeader">
                <asp:Label runat="server" OnInit="Label_Init" OnPreRender="Label_PreRender" />
            </td>
            <td>
                <asp:DynamicControl runat="server" ID="DynamicControl" Mode="Edit" OnInit="DynamicControl_Init" />
            </td>
        </tr>
    </ItemTemplate>
</asp:EntityTemplate>

I want to hide the TableRow "trTop" in the above example progmatically based on a custom metadata attribute. I can easily get the custom meta attrib (True/False), but for some reason can't seem to get access to "trTop". I've tried all of the following with no success:

Protected Sub EntityTemplate1_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles EntityTemplate1.PreRender
        Dim tr As HtmlTableRow = DirectCast(EntityTemplate1.FindControl("trTop"), HtmlTableRow)
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim tr As HtmlTableRow = DirectCast(EntityTemplate1.FindControl("trTop"), HtmlTableRow)
    End Sub

    Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRender
        Dim tr As HtmlTableRow = DirectCast(EntityTemplate1.FindControl("trTop"), HtmlTableRow)
    End Sub

What am I doing wrong in this seemingly simple example?

Mapping custom SQL types to a FieldTemplate

xaeryan — Wed, 18 Nov 2009 20:29:11 GMT

Perhaps I've missed this in the intro videos, but I can't seem to figure it out...

We've created a custom SQL (user defined) type called Phone, which is nothing more than a varchar of specific length.

How can I tell Dynamic Data to map the Phone user defined type to my own Phone.ascx FieldTemplate?

I wish to avoid coding manual Metadata, as that partially defeats the purpose of making the SQL user defined type. I want the DD schema analysis to take care of this mapping for me.

Same Primary Key creates error in Filters.

freeborn5 — Fri, 28 Aug 2009 21:09:26 GMT

I am having an issue that seems to only happlen when I run my Dynamic Data Application in combined-page mode ie: ListDetails.aspx not List.aspx.

I have 4 tables with a one to one relationships and all 4 tables have the same name for the primary key.

I can bring up the individual records without issue the error is thrown when I navigate back to the parent (in terms of the dbml Association).

The error I get is

'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

I have read that there is a bug with the DataContext being cached by Dynamic Data but I think it is the simmalar name of the primary Keys.

If anyone has seen this as well please chime in

New field template type how to use javascript

minority2000uk — Tue, 17 Nov 2009 09:05:10 GMT

I maybe dumb but I am trying to create a new field template type which is basically a textbox with a calendar popup for selecting a date.

I was planning on using a standard textbox with the JQuery UI calendar however I cannot for the life of me figure out how to get a js function to fire when the edit or new buttons are pressed so that I can enable the Jquery UI against the textbox.

I basically incorporated the JS on load function into my new template and thought it would fire but it did not is there some way to fire this off when the template is loaded onto the screen?

also where is the best place to store the Jquery files would it be with the master pages, which I have not got at this point.

THanks

Mino

Externalize navigation links between entities?

xaeryan — Wed, 30 Sep 2009 20:10:08 GMT

In Dynamic Data, the navigation links (for example, to a related table) are displayed inline with the databound control (example: as a row in the FormView for Edit.aspx).

Is there any easy way to externalize these? We typically have a navigation map on the left side (in a menu-style control), so I'd like to put those links there instead. Any ideas how this can be accomplished?

Table_Metadata class inheritance - Does not seem to work.

jashmead — Tue, 16 Sep 2008 16:25:25 GMT

I have a single table that I provide to the end user, but i provide 3 'views' into this table based on a filter. In my DataContext, I have the same table, ProductWatch, defined multiple times. ProductWatch is the base table, without filter... then I have my 'view' tables, which are the same table, but renamed... For this example, we have a StopSellList table.

I have partial classes defined for these 2 tables like this:

#region    =======================   ProductWatch Table   =======================
	[ScaffoldTable(true)]
	[MetadataType(typeof(ProductWatch_Metadata))]
	[DisplayName("All Product Watches")]
	public partial class ProductWatch
	{
	}

	#endregion =======================   ProductWatch Table   =======================


	#region    =======================   StopSellList Table   =======================
	[ScaffoldTable(true)]
	[MetadataType(typeof(StopSellList_Metadata))]
	[DisplayName("Stop Sell Products")]
	public partial class StopSellList : ProductWatch
	{
		
	}


	#endregion =======================   StopSellList Table   =======================

And my Metadata classes defined like this:

	#region    ======================   ProductWatch_Metadata   =====================
		public class ProductWatch_Metadata
		{
			public object ProductWatchID;
			public object EnabledFlag;
	
			[Required(ErrorMessage = "Product Watch Type is REQuired!!")]
			public object ProductWatchType;
	
			[UIHint("TextLabel", "HTML", "Width", "75px")]
			public object ItemCode;
	
			[UIHint("TextLabel", null, "Width", "240px")]
			public object Description;
	
			/// <summary>
			/// Override in SubTables to change display name.
			/// </summary>
			[DisplayFormat(DataFormatString = "{0:MM-dd-yyyy}")]
			[UIHint("Calendar")]
			public virtual object StartDate { get; set; }
	
			/// <summary>
			/// Override in SubTables to change display name.
			/// </summary>
			[DisplayFormat(DataFormatString = "{0:MM-dd-yyyy}")]
			[UIHint("Calendar")]
			public virtual object EndDate { get; set; }
	
			[DisplayFormat(DataFormatString = "{0:MM-dd-yyyy}")]
			[UIHint("Calendar")]
			public object DisplayEndDate;
	
			[ScaffoldColumn(false)]
			public object CreatedBy;
	
			[ScaffoldColumn(false)]
			public object CreatedDate;
	
			[ScaffoldColumn(false)]
			public object LastUpdatedBy;
	
			[ScaffoldColumn(false)]
			public object LastUpdatedDate;
		}
	
		#endregion ======================   ProductWatch_Metadata   =====================
	
		public class StopSellList_Metadata : ProductWatch_Metadata
		{
			[DisplayFormat(DataFormatString = "{0:MM-dd-yyyy}")]
			[UIHint("Calendar")]
			[DisplayName("Stopsell Date")]
			public override object StartDate { get; set; }
	
			[DisplayFormat(DataFormatString = "{0:MM-dd-yyyy}")]
			[UIHint("Calendar")]
			[DisplayName("Est. Restock Date")]
			public override object EndDate { get; set; }
	}

Note that the StopSellList_Metadata class inherits from ProductWatch_Metadata. Again, these are the same underlying sql table, so the fields are the same.

I am just trying to display the Heading of StartDate and EndDate to be different for the StopSellList table. That's why I tried to define the [DisplayName()] attribute on the StopSellList columns.

This Doesn't work. The override properties are not used at all. In looking deeper, I realized that the GridView for these Columns uses asp:TemplateField for all columns... So, What is going on? How do I tell the GridView to use the DisplayName() attribute for column heading? I thought it was automatic. If I specify HeaderText="StartDate" then it shows StartDate, if I remove that property, then the column heading is Blank.

Here are some of the Columns in my GridView <Columns> definition.

	
<asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="StartDate" SortExpression="StartDate">
		<EditItemTemplate>
			<asp:DynamicControl ID="DynamicControl3" runat="server" DataField="StartDate" Mode="Edit" />
		</EditItemTemplate>
		<ItemTemplate>
			<asp:DynamicControl ID="DynamicControl3" runat="server" DataField="StartDate" Mode="ReadOnly" />
		</ItemTemplate>
		<HeaderStyle Width="50px" />
		<FooterTemplate>
			<asp:DynamicControl ID="DynamicControl11" runat="server" DataField="StartDate" Mode="Insert" />
		</FooterTemplate>
</asp:TemplateField>

<asp:TemplateField ConvertEmptyStringToNull="False" SortExpression="EndDate">
		<EditItemTemplate>
			<asp:DynamicControl ID="DynamicControl4" runat="server" DataField="EndDate" Mode="Edit" />
		</EditItemTemplate>
		<ItemTemplate>
			<asp:DynamicControl ID="DynamicControl4" runat="server" DataField="EndDate" Mode="ReadOnly" />
		</ItemTemplate>
		<HeaderStyle Width="50px" />
		<FooterTemplate>
			<asp:DynamicControl ID="DynamicControl12" runat="server" DataField="EndDate" Mode="Insert" />
		</FooterTemplate>
</asp:TemplateField>

Thanks,

-j

problem in field template for manytomany

prasadrmarathe — Mon, 16 Nov 2009 06:31:25 GMT

Hi,

I have refered the following for m2m field template

http://blogs.msdn.com/davidebb/archive/2008/10/25/a-many-to-many-field-template-for-dynamic-data.aspx

However this is not of my use as my junction table has few other columns and therefore the junction table appears on the EDMX

Can you point me to some exapmle which has a junction table with few other fields.

I am working on Linq to Entities.

The below link is for LinqToSQL

http://www.codeproject.com/KB/webforms/DynamicDataManyToManyFld.aspx

Please suggest.

Thanks,

Prasad M.

LinqDataSource.Update() a GridView with a SET operation , How do I do it ?

steve_mew — Fri, 13 Nov 2009 07:19:43 GMT

LinqDataSource.Update() a GridView with a SET operation

I have a Dynamic Data Website with a GridView..
I wish to be able to update one column within the GridView Data Set. (Multiple Rows)

How do I do it efficiently ?
I can't find any examples that are set based, they seem to be all siting single column examples.

Can anyone point me to an example ?

Many Thanks

s

Dynamic Data Web Site formatting the frontend of a customised ListDetails.aspx page

kennymac — Sun, 15 Nov 2009 16:23:52 GMT

Hi,

I know you can change columns (show and hide) etc. But what I can’t find is how to change the columns layout.

I have a table called Sud it has the following columns

SudID

Row1Name

Row1aValue

Row1bValue

Row1cValue

Row1dValue

Row2Name

Row2aValue

Row2bValue

Row2cValue

Row2dValue

Row3Name

Row3aValue

.......

Row5Name

......

Row5dValue

I have copied and moved ListDetails.aspx page into its own folder under the path DynamicData/CustomPages/Suds/ and this works.

The problem I have is in the way it displays the data which is not conducive to reading the data.

The table is to big for the screen and reads as following

Row1Name Row1aValue..Row1dValue Row2Name Row2aValue..Row5dValue (so it reads across). I need to change the format to make it easy to read.

(record 1) Edit/Delete/Select Row1Name Row1aValue Row1bValue Row1cValue Row1dValue

Row2Name Row2aValue Row2bValue Row2cValue Row2dValue

Row3Name Row3aValue Row3bValue Row3cValue Row3dValue

Row4Name Row4aValue Row4bValue Row4cValue Row4dValue

Row5Name Row5aValue Row5bValue Row5cValue Row5dValue

(record 2) Edit/Delete/Select Row1Name Row1aValue Row1bValue Row1cValue Row1dValue

Row2Name Row2aValue Row2bValue Row2cValue Row2dValue

Row3Name Row3aValue Row3bValue Row3cValue Row3dValue

Row4Name Row4aValue Row4bValue Row4cValue Row4dValue

Row5Name Row5aValue Row5bValue Row5cValue Row5dValue

And so on .........

Does anyone know how to do this can be done. I have look everywhere and cannot find out how to format it so that it looks like the above layout. I get errors when I try to insert tables in to try and format the look.

Thanks

Can Dynamic Data use Access mdb as datasource ?

hkbeer — Sun, 15 Nov 2009 08:09:50 GMT

I am very eager to use Dynamic data but all documents shows using LINQ to SQL.

Can Dynamic Data use Access mdb as datasource ?

Pls help... thanks

Error Message for simple data-binding Linq query

likwidmack — Thu, 12 Nov 2009 23:37:40 GMT

I'm working with Asp.net 3.5 Dynamic Data with Linq to SQL and I am getting an error with a simple query

Error 1 Overload resolution failed because no accessible 'New' accepts this number of arguments.

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Dim dc As New RecipesDataContext()

        Dim query = From m In dc.IngCatGrps _
                   Select m

        System.Diagnostics.Debug.WriteLine(query)

        Me.GridView1.DataSource = query
        Me.GridView1.DataBind()


    End Sub

--For "Dim dc As New RecipesDataContext()"

any reasons why?

What's the best way to create new or alter "Action" functionality

dwainew — Wed, 11 Nov 2009 20:31:41 GMT

For instance. I want a new "Copy" action in addition to "Insert New"

This would use the current data row as the template (using the initial Edit functionality) but ultimately create a new row after "update".

I would think this would involve creating a new Action Path and editing the Page Templates .cs to perform the required action, but I'm stumpped where to start.

Any help would be appreciated.

Customizing the FilterRepeater dropdown section of a dynamic page

klca — Wed, 11 Nov 2009 06:08:56 GMT

I will gladly appreciate your consideration and understanding for my lack of proper English writing and composition. I am a Spanish speaker.

"How to customize the FilterRepeater dropdown section of a dynamic page with descriptions instead of key values?"

I am trying to start a new development of an inventory system and I have more than a 100 tables which are fully correlated among them by means of using referential integrity (multiple foreign keys).

The system will be used by different companies (of the same holding group) but I need to identify behavior and data for each one of them as single entities.

Linq has been very valuable but still got the problem in trying to write most of the queries as to get proper data representing every specific company for every table (datagrid - dataview pair)

I have also had the problem in using multiple data contexts in Linq which makes difficult in trying to recover queries from within dynamic data features (which allows you a single data context). I have mixed both techniques as to get my queries properly written taking advantage of the live validation that you can get using datacontexts and Linq.

Dynamic data solves this but there is so little documentation on how to customize the dynamic web site as to put it into production.

For instance: does anyone knows how to override the "FilterRepeater" section as to replace it with "data content" meaning the "names" of the items instead of the key values as to make the web site more practical.

There is always the issue that you still might want to go further ans use other validation criteria that might be out of the scope of the referential integrity for a tables but which is decisive in making a query because it might be derived from a "higher level" key which hasn't been carried until that level,

Carlos Porras (El Salvador)

Entity Framework DataGrid Binding with Join

ToughBond — Thu, 12 Nov 2009 08:32:16 GMT

I am using the Entity Framework. My datamodel is being accessed via wcf. I am grabbing a collection like this

var inventions = from i in dataEntities.Invention.Include("JoinInventor.Person")

select i;

return inventions.ToList();

When I databind the collection to a grid how do i display jointable data?

<asp:BoundField DataField="Title" /> works for my main table data but how about join data?

Having trouble With Minimal Data Attributes working

pkellner — Sun, 08 Nov 2009 06:47:51 GMT

I've made my own page in the futures DD project release.

To my ObjectDataSource Object I'm returning, I've added the MetadataType attribute and put some attributes on the properties as follows:

  [MetadataType(typeof(MembershipUserWrapper))]
    public class MembershipUserWrapper : MembershipUser
    {

        [DataType(DataType.PhoneNumber)]
        [Required]
        public override string Comment { get; set; }

Then, in my codebehind, I have:

   public partial class ObjectDataSourceSample : System.Web.UI.Page {
        protected void Page_Init() {
            // Extension method syntax
            ProductsList.EnableDynamicData(typeof(MembershipUserWrapper));

I create a simple updateable gridview, press the edit button, and the validation does not happen.  What am I missing?

Thanks,