Data Scaffolding using ASP.NET Dynamic Data

Dynamic Data - Data Encryption - Sorting

2013-05-14T14:51:21.76-04:00

Issue Type: Sorting

I've erected an application with Dynamic data model which ciphers the data from/to the data source. The Field templates in place and the filters do their Job well and good and even the foreign key filters work like a charm. The trouble is with sorting.

The data field from source is an encrypted text and the grid seems to use this to sort the data. Is there ANY way to use the Decrypted text to perform the sort? The Encrypt and Decrypt actions are handled with simple methods.

Dynamic Data DataAnnotations setting dynamically using t4 template

2013-05-16T11:45:53.697-04:00

Hi,

Is there any way to set dynamically the dataannotations according to some values in database?

My requirement is like this:

Display(Name="DispName")]

public string DName{get;set;}

Instead of hardcoding Name="DispName" for Display DataAnnotation, I want to fetch some value from DataBase and fit int the Name attribute. like:

[Display(Name=SomeValueFromDB)]

public string DName{get;set;}

This should be done using t4 template also. Is there any way to accomplish this?

Regards,

Sujith

How to create a custom filter template

2013-05-15T21:02:57.38-04:00

I am building a Student Information System which allows different roles to log in. When a Teacher logs in I want them to be able to access only students in the class that they teach. A Class may have one or more Students. When the Teacher accesses the StudentAttendance "gridview" which does not have a ClassID I want to show only Students who belong to the Class that the Teacher teaches. The StudentAttendance table has the following fields: ID, StudentID, Date, Present, Late. I have a TeacherClass table: ID, TeacherID, ClassID. Also There is a ClassStudent table: ID, ClassID, StudentID, AcademicYear. So via SQL I can easily determine the Students in a specific class taught by a specific Teacher.

Please help.

Dynamic Data: ListDetails.aspx - Entity Data

2012-12-13T08:52:25.633-05:00

Hi,

How do I get the column information, i.e. the actual rows and columns and the data within from the ListDetails.aspx (is it possible from the metatable)?

A Field is AWOL

2013-05-03T09:31:20.233-04:00

The problem is with the HomeWork table the Class does not show although the Subject does.

I have three tables:

1. Class: ID, Name, TeacherID

2. ClassStudent: ID, ClassID, StudentID

3. HomeWork: ID, ClassID, SubjectID, DateGiven, DueDate, Details

A Class may have one or more Students and One or more Studens may be in a Class. A Class can be given one or more items of HomeWork.

Here is the code:

sisDomainService.metadat.cs:

internal sealed class HomeWorkMetadata
		{

			// Metadata classes are not meant to be instantiated.
			private HomeWorkMetadata()
			{
			}
			
			public Class Class { get; set; }

			public long ClassID { get; set; }

			[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:d}")]
			[DisplayName("Given Date")]
			public DateTime DateHWGiven { get; set; }

			[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:d}")]
			[DisplayName("Due Date")]
			public DateTime DueDate { get; set; }

			[DisplayName("Details")]
			public string HomeWorkDetails { get; set; }
			
			[ScaffoldColumn(false)]
			public long ID { get; set; }

			public Subject Subject { get; set; }

			public long SubjectID { get; set; }
		}
	}

sisDomainService.cs:

[RequiresAuthentication]
		[RequiresRole("Clerk","Teacher", "Principal", "Student", "Parent")]
		public IQueryable<HomeWork> GetHomeWork()
		{
			if (this.ServiceContext.User.IsInRole("Student"))
			{
				int intClassID = getClassID();
				return this.ObjectContext.HomeWork.Include("Class").Include("Subject").Where(s => s.ClassID == intClassID).OrderByDescending(s => s.ID);
																		
			}
			if (this.ServiceContext.User.IsInRole("Parent"))
			{
				List<int> intListofStudentIDs = new List<int>();
				intListofStudentIDs = getStudentIDs(getParentID());
				List<int> intListofClassIDs = getClassIDs(intListofStudentIDs);

				return this.ObjectContext.HomeWork.Include("Class").Include("Subject").Where(s => intListofClassIDs.Any(i => i == s.ClassID)).OrderBy(s => s.ClassID);
																	    //Where(s => intListofStudentIDs.Any(i => i == s.StudentID)
			}

			
				return this.ObjectContext.HomeWork.Include("Class").Include("Subject").OrderByDescending(h => h.ID);
			
		}

Please help thank you.

Paging Through a ListView

2012-03-20T08:48:54.573-04:00

Hey,

I'm currently pulling groups of 6 rows from my database with my DataPager looking like this:

<asp:DataPager ID="DataPager1" runat="server" PageSize="4">
                            <Fields>
                                <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />
                                <asp:NumericPagerField />
                                <asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True" ShowNextPageButton="True" ShowPreviousPageButton="True" />
                            </Fields>
                        </asp:DataPager>

When on the first page, it is the front page of my website http://www.darvinkmanwah.com but then when it goes to page 2 of the data the URL does not change. How can I code it where when on page 2 the URL changes to reflect page 2 and so on.

All validation attribute works fine[requierd -Range and other] but the other does not works [ Display and ScaffoldColumn]

2013-05-13T13:36:21.52-04:00

i have Test_DB.edmx file contains 1 table called Tbl_Users

i created partial class to apply my validation and Handel some properties Attribute like Display and ScaffoldColumn

my problem is :

All validation attribute works fine[requierd -Range and other]

but the other does not works [ Display and ScaffoldColumn]

is that any Suggestions

My code is:

[MetadataType(typeof(CUsers))]
public partial class Tbl_Users
{

 }
public partial class CUsers
{
    #region Primitive Properties

    public int UserID { get; set; }


    [Required()]
    [Display(Name = "UserName", ResourceType = typeof(Resources.App_Resource))]
    public String UserName { get; set; }
   
    [Required()]
    [Display(Name = "Password", ResourceType = typeof(Resources.App_Resource))]
    [ScaffoldColumn(false)]
    public String Password { get; set; }

    [Required()]
    [Display(Name = "DOB", ResourceType = typeof(Resources.App_Resource))]
    public DateTime DOB { get; set; }


    #endregion

 

}

Customising data annotations in dynamic data

2013-05-13T08:37:11.96-04:00

have come across a scenerio that to customize DataAnnotations in Dynamic Data Web Application. This is the scenerio:

[Display(Name="DispName")]

public string DName{get;set;}

Instead of hardcoding Name="DispName" for Display DataAnnotation, I want to fetch some value from DataBase and fit int the Name attribute. like:

[Display(Name=SomeValueFromDB)]

public string DName{get;set;}

Is there any way to show the Name attribute of Display DataAnnotation from database instead of hardcoding its value?

Thanks in advance,

Sujith

Custom page with Dynamic Data and Multiple ComboBoxes

2013-04-22T23:00:39.253-04:00

I want to create a custom ASP.Net C# dynamic data page. This page should work (ideally) like this:

It will display a line (a row at a time) of a GridView containing four columns: a Label containig the text of one question, a ComboBox for choosing data, an empty TextBox and a command buttong for saving the data and passing to the next row
The ComboBox will be populated with data coming from an entity (a different entity for each row of the GridView)
After making selection in the ComboBox the selected text should be copied to the TextBox
Afte r saving the data from that row the gridView will display the next row containing the same elements like the firts one BUT populating the ComboBox with values coming from a 2nd entity and so on for every new row

Process will end when all entities pertaining to this process (which will be defined somehow in the code behind of the page) have been used

Then the text contained in all TextBoxes will be concatenated in a single string

Best regards

Carlos N. Porras
(El Salvador)

how to update the domainservice.cs file with a new table

2013-05-12T09:01:08.17-04:00

Users are the most unpredictable species. I am required to add a new table to the project. I have done alot of modifications to the domainservice file is there any way to update the domainservice file?

Dynamic Data using Code First Entity Framework Model

2010-10-20T13:09:58.4-04:00

I have used Dynamic Data before using LinqToEntity where my Entity model used the Data First model and the GUI. Now I am trying to use the Code First model witht he Entity CTP 4. I have my model created and created a new Dynamic Data site. I read that I need to replace the default RegisterContext call:

DefaultModel.RegisterContext(typeof(PriceLoaderContext), new ContextConfiguration() { ScaffoldAllTables = true });

with

DefaultModel.RegisterContext(new DomainModelProvider(typeof(PriceLoaderContext)), new ContextConfiguration() { ScaffoldAllTables = true });

When I search further on DomainModelProvider, I find that it is part of the WCF RIA. Is this correct? Is this what I need for this to work? Has anyone else done this and got it to work?

Thanks,
Fred Gohsman

How to set MaxLength of a textbox asp.net dynamic data

2013-05-07T04:01:36.977-04:00

Hi All,

I have the following dynamic control.

<asp:DynamicControl ID="DynamicControl1" runat="server" DataField="Label" UIHint="Text_Edit" />

The maxlength for this is was intially set to 255 in database as well as in .edmx file.

<Property Name="Label" Type="nvarchar" Nullable="false" MaxLength="255" />(.edmx file).

So the Label textbox was allowing me to enter only 255 characters. When I tried entering more than 255 characters it was cut off.(which is perfect).

Now, I want to increase the MaxLength of the 'Label' text box to 555. I changed the column length in database to 555. Also the edmx file has label MaxLength set to 555.

<Property Name="Label" Type="nvarchar" Nullable="false" MaxLength="555" />(.edmx file).

But it still allows only 255 characters. How can I increase this? I am missing something obvious? Please help.

Thanks,

sreethi

Display link to show related data (Many to Many Field Template)

2011-07-02T19:52:36.317-04:00

Hello,

By default the Many to Many Field Template is displaying a link for each related row. But in my case this looks very confusing because there are too many links shown. So is it possible to display one single link instead? For example if there is a products table there would be a link "Show orders" for each product redirecting to a filtered order table.

Thanks for your help.

Is it possible to add a new table to an existing Dynamic Data project?

2013-05-08T12:31:09.283-04:00

If so how?

Any advice will be appreciated.

VS2010 - Context type in EF dynamic data

2013-04-28T05:29:05.793-04:00

Hi,
I am trying to build a Dynamic Data website with Entity Framework since I have oracle as a back-end database.
I am using Oracle provided ODAC (ODP.NET) as data provider.

Question: What Context should I place in the "YourDataContextType" Global.asax file.

I have used default values for Model Namespace (Model) and entity connection Settings (Entities).
If I replace "YourDataContextType" with "Model" I receive the error "Model is a namespace but is used like a type".
If I replace "YourDataContextType" with "Entities" I receive the error "The type or namespace Entities could not be found"

I am using VS 2010 Prof. version, oracle 11g.
Listed below are snippets of Global.asx and Model.Designer.cs file.

File = Model.Designer.cs
========================

using System;
using System.Data.Objects;
using System.Data.Objects.DataClasses;
using System.Data.EntityClient;
using System.ComponentModel;
using System.Xml.Serialization;
using System.Runtime.Serialization;

[assembly: EdmSchemaAttribute()]
#region EDM Relationship Metadata

[assembly: EdmRelationshipAttribute("Model", "ORDERS_CUSTOMER_ID_FK", "CUSTOMERS", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(Model.CUSTOMER), "ORDERS", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(Model.ORDER), true)]
[assembly: EdmRelationshipAttribute("Model", "ORDER_ITEMS_ORDER_ID_FK", "ORDERS", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(Model.ORDER), "ORDER_ITEMS", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(Model.ORDER_ITEMS), true)]
[assembly: EdmRelationshipAttribute("Model", "ORDER_ITEMS_PRODUCT_ID_FK", "PRODUCT_INFORMATION", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(Model.PRODUCT_INFORMATION), "ORDER_ITEMS", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(Model.ORDER_ITEMS), true)]

#endregion

namespace Model
{
    #region Contexts
    
    /// <summary>
    /// No Metadata Documentation available.
    /// </summary>
    public partial class Entities : ObjectContext
    {
        #region Constructors
    
        /// <summary>
        /// Initializes a new Entities object using the connection string found in the 'Entities' section of the application configuration file.
        /// </summary>
        public Entities() : base("name=Entities", "Entities")
        {
            this.ContextOptions.LazyLoadingEnabled = true;
            OnContextCreated();
        }


file = Global.asax
==================

<%@ Application Language="C#" %>
<%@ Import Namespace="System.ComponentModel.DataAnnotations" %>
<%@ Import Namespace="System.Web.Routing" %>
<%@ Import Namespace="System.Web.DynamicData" %>

<script RunAt="server">
    private static MetaModel s_defaultModel = new MetaModel();
    public static MetaModel DefaultModel {
        get {
            return s_defaultModel;
        }
    }

    public static void RegisterRoutes(RouteCollection routes) {
        //DefaultModel.RegisterContext(typeof(YourDataContextType), new ContextConfiguration() { ScaffoldAllTables = false });

Insert/Update/Delete - Multiple table

2013-05-01T16:52:14.967-04:00

Hi,

I am using ASP.NET Dynamic data. I have an existing data model (*.edmx) created as part of the dynamic data. I have to add another entity which would show data from multiple tables. Example

Entity view - EmployeeDetails:

EmployeeID
EmployeeName
Desigination
Department
AddressLine1
AddressLine2

This gets data all the data from Employee Table and one 2 columns from AddressDetails table.

Employee-Table:

EmployeeID
EmployeeName
Desigination
Department

AddressDetails –Table

EmployeeID
EmployeeName
AddressLine1
AddressLine2
City –allows null
PostCode –allows null

I want to create a EmployeeDetails entity in a single page and let the user to insert/update/delete. How can I achieve it. If I create a view for the EmployeeDetails, I’ll not be able to do insert/update/delete. How can I do..

I am a beginner, so please provide step-by-step guidance.

Thanks in advance

How do I write the predicate to test for more than one value?

2013-04-29T11:31:41.417-04:00

I have:

return this.ObjectContext.StudentGrades.Include("Student").Include("Subject").Where(s => s.StudentID == intStudentID()).OrderBy(s => s.ID);

Which returns one student. However a parent has access to the StudentGrades and may have one or more students enrolled. I can write an SQL query to get the data I want but I do not know how to apply it to the Where clause.

Please help.

VS2012 RTM - Context type is not supported with ASP.NET dynamic data

2012-09-12T14:17:20.71-04:00

Creating a new ASP.NET dynamic date project with VS 2012 RTM.
Add new EF model
fix the RegisterContext line in Global.asx

run debug and get the error.

I beleive Microsoft didn't debug well prior to release with Dynamic data..............

Visibility of DynamicField

2013-04-25T16:44:18.86-04:00

I am having a heck of a time discovering how to manipulate the visible attribute of the DynamicField object within a DetailsView. I use the declarative attribute "Visible" to hide the field and of course when the page is displayed the entire detail row is not visible as I was hoping. What I need is to manipulate the detail row visibility with code-behind for the page. I will also use code-behind in a field template to manipulate the same. What I am considering is abandoning the declarative approach and use code-behind exclusively to set visibility of the rows, but if I understood where to access the correct visibile property with code-behind, the declarative approach would be preferred I think. Is it possible to access the same visible attribute using the syntax DetailsView1.FindFieldTemplate("myFld") and navigating the control hierarchy?

Custom Page Markup:

...
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:DetailsView ID="DetailsView1" runat="server" DataSourceID="DetailsDataSource" DefaultMode="Insert"
                AutoGenerateInsertButton="False" CssClass="detailstable"
                FieldHeaderStyle-CssClass="bold" AutoGenerateRows="false">
                <Fields>
                    <asp:DynamicField DataField="myFld" Visible="false" UIHint="myFldTemplate" />
                </Fields>
            </asp:DetailsView>
...
        </ContentTemplate>
    </asp:UpdatePanel>

Update:

I investigated abandoning the declarative approach entirely relying only on code-behind to manipulate visibility. This was successful, but I am still curious about the declarative approach and how to access this attribute from code-behind. The code to manipulate the detail row visibility uses DetailsView1.FindFieldTemplate("myFld") and traverses control parents to find the DetailsViewRow. The code manipulates the visibility of the detail row from the Load event of the page and also the OnTextChanged event of another control on the same page.

textbox column to drop down

2013-04-25T05:32:23.607-04:00

I have a column 'Indicator' which stores either 'P' or 'D'. I dont want to show a textbox while editing instead a drop down is required.

I know like creating a new table with 'P' & 'D' records and providing a foreign key relationship will display a drop down. But is there any other way without creating a table ? something i can do in the code itself ?

Rakesh