Post New Web Links

Dynamic Data. Multiple Custom Pages For The Same Table

Posted By: Posted Date: October 18, 2010 Points: 0 Category :ASP.Net

Hello,

I've just started out my first project using Dynamic Data and I've been running into a series of problems. Dynamic Data doesn't seem to be swimming in documentation. Anyway, my setup is:

Visual Studio 2010
.net 4.0
Dynamic Data Domain Service Web Application Project Template (I have the RIA Services for ASP .net installed)
using an Entity Data Model
using a DomainService class
ASP .net Membership

There are a couple of things I am trying to achieve:

I have my scaffolding turned on for all the tables. I am using the RequiresRole attribute in order to restric access to some tables. I have understood how you can create a Custom Page Template for a certain table, no problems there. I would like to be able to use the default PageTemplates for lets say the Administrator role and the Custom Page Templates for another role; the idea would be that the Administrator would be able to edit anything in the DB, but the restricted user would receive a Custom Page with only a few actions available. Long story short: is there a way to access both the standard and custom templates?
Related to question number 1: Can I have multiple Custom Page Templates for the same table? I saw someone asking

View Complete Post

More Related Resource Links

Custom display name for a table in dynamic data.

I know this has been asked before but I am working in VB and don't know C#. I want to display a custom name for my tables on a dynamic data page. So far I have located the name of the object in my LinqSQL data context which is SectionTable. When displayed I want SectionTable to appear as Section.

I know something should go in the namechange class, but I don't know what! I have got this far:

Imports Microsoft.VisualBasic

Imports System.ComponentModel.DataAnnotations

<MetadataType(GetType(namechange))>

Partial Public Class SectionTable

End Class

Public Class namechange

End Class

Thanks in advance.

How do you create a custom BDC data field that allows for multiple selected values?

I need help creating a custom data field using the BDC column as a base. We need to allow for multiple selected values instead of just a single one. I can't find anything on the net which shows how to do this.

Customizing pages with Asp.Net Dynamic Data Domain Service Web Applications?

Hola, It used to be so easy creating new folder under CustomPages with the (Entity/Table name) and copying on it all base default PageTemplates (Details, Insert, Edit, List and ListDetails) and you will get access to those pages only for the specific table (this was the default automatic behavior of the Dynamic Data framework) When it comes to be using Asp.Net Dynamic Data Domain Service Web Applications it seems that we need to learn a new way of doing this because it is just simply different and you got a lot of errors when compiling your application if you do this the old way? What might be the new way, uh? HOW DO WE DO THIS NOW ... I MEAN ... CREATING DEFAULT CUSTOM PAGES FOR SPECIFIC TABLES (Details, Insert, Edit, List and ListDetails) with Asp.Net Dynamic Data Domain Service Web Applications? The problem arises when the definition for your newly created classes is absent from the automatically generated code when you created your domain service !!!!! . If you simply copy the PageTemplates as they are, you got a duplicated error message because the new .designer file (automatically generated) conains the definition of the class you are copying (not the newer one) so even if you rename your .aspx file the result is not what you would normally expect (the .designer class is not regenerated after renaming). The .designer file keeps the domain service definition and if y

Custom component Table name dynamic table name

Hi All How to i call the table dynamiclly in to C# class library. I can able to call the columns names.. but i unable to call the table name.. please suggest it Example: IDTSOutputColumn100 column = output.OutputColumnCollection[x]; columnInfos[x] = new ColumnInfo(); columnInfos[x].columnName = column.Name; columnInfos[x].Column_reference = column.CustomPropertyCollection[ "Column_reference"].Value.ToString(); columnInfos[x].bufferColumnIndex = BufferManager.FindColumnByLineageID(input.Buffer, column.LineageID); columnInfos[x].lineageID = column.LineageID; geting the columns names .. how to i get table name...?? Regards Ram

how to read a custom dynamic data meta data attribute in a field template

All --Please help.I need to know how to read a custom dynamic data meta data attribute in a field template.I know how to do it in a page template because I have a handle to the meta table on the page.However, I do not know how to get a handle to the meta column at run time in a field template.Can you help?Please advise.Thank you.-- Mark Kamoski

How to submit data to a SQL Server database table from a custom page ?

Using SPD, I have created a custom page. It has a form with ASP.NET controls textbox, radio buttons, dropdown, submit button etc., Also, I created a Database connection (to the SQLServer database table) under Database Connections. But not sure how to connect this form to the database connection so that when form data is submitted, the data will be inserted into the table.

Entities Data Models with multiple Categories using a membership table

(Using SQL Server 2008 and ASP.NET MVC2) I have a simple business table and a category table. I have a 3rd table to map business to category, a many-to-many relationship. the Map table contains a BusinessID and CategoryID. I'm lost as to how I can load the categories into my Business View Model using the entities model.Without incorporating categories, my code looks like this: var businessList = from b in entitiesDB.Businesses select new Models.BusinessViewModel { BusinessID = b.BusinessID, Name = b.Name } with Business View Model defined as: public class BusinessViewModel { [ScaffoldColumn(false)] public Guid BusinessID { get; set; } public string Name { get; set; } public List<Models.CategoryViewModel> Categories { get; set; } } but if i want to populate the Categories with the mapped categories, how would one do that?Thanks in advance for any help!

Data Flows in SSIS - Mapping Multiple source tables to Destination table Newb question

Hi I am new to SSIS and had a basic question. I have around 30+ tables in a db that needs to be migrated to a newer schema in the DB. The data flow task seems to be ideally suited for my requirement. My question is do I need to create 30+ different data flow tasks for this which will get executed one after the other or is there a better way to migrate large number of tables. Also how are referential constraints taken care of during such migration. Thanks and Regards, Ganesh Ranganathan

Ganesh Ranganathan
[Please mark the post as answer if it answers your question]
blog.ganeshzone.net

Custom Form Field in Collect Data Action doesnot capture multiple users.

I have a situation where the department head dynamically assigns the reviewers depending on the document that is uploaded. To capture the reviewers I added a Collect Data Action and a "Reviewers" form field, with type "Person/Group" and checked the following properties

1. Allow selection od People and Groups, 2. Choose from all users and more importantly 3. Allow multiple users

Although I am able to enter multiple users in the form, I am able to retrieve only the first user I entered and the rest just.. disappear!

Auto udating data in multiple table through trigger.

table a(

sno IDENTITY int(1),

name varchar(5),

roll_no numeric(5)

sum more columns

)

table b(

sno IDENTITY int(1),

name varchar(5),

sum more columns

)

table c(

sno IDENTITY int(1),

roll_no numeric(5)

)

Could any one kindly tell me how can i do it.

whenever data is entered in table a the values of name and roll_no to be automatically filled in table b and table c with use of trigger.

how to add multiple rows in a data table against a button click event

how to add multiple rows in a data table against a button click event, and then show it in a gridview

How to insert dynamic data into an XML or HTML format table

Hi there,

I have a technical problem as the title described. I need to achieve this by SSIS that means the destination file could be XML or HTML. However, before inserting dynamic data from source, an XML or HTML format table must be predefined. In the final destination file, the predefined table and dynamic data will be both output.

Can anybody give some suggestions or reference links regarding to this? Appreciate it.

dbschenker

Showing data from more than one table in Custome PageTemplate Using dynamic data

I want to display data from more than one table in one of my custom page template of my ASP.NET Dynamic data web app.

The query would be something like the one given below:

CREATE VIEW [dbo].[EmployeeDetail_V]
AS
SELECT Emp.EmployeeID, Emp.FirstName, Emp.LastName,
Emp.MailID, Dept.Name, Desig.Designation
From Employee Emp
INNER JOIN Department Dept ON Emp.DepartmentID = Dept.DepartmentID
INNER JOIN Designation Desig ON Emp.DesignationID = Desig.DesignationID

I know, I can do this using sql views but I want that user should also be able to edit the records also.

Is there a framework or step to do this using VS 2010?

Dynamic Data, Multiple Tables in one page?

Hi there,

So I have a Dynamic Data Project with a few custom pages that are not the standard list/insert/update pages. So I created my custom page, Process.aspx. It's a regular web form with a dynamic data manager, plus a LINQDATASOURCE. That works fine. However, inside of my main formview I'm going to have a subformview. So I set up a second LINQDATASOURCE, but it seems when I try and use Dynamic Data Controls inside of my sub form view, it can't seem to find the MetaTable, even though I set the subformview up with its own data source. Can I have two dynamic data managers somehow, one for each data source? I don't think there's a way to associate a dynamic data manager to a specific data source, as far as I can tell.

Or, can I do something like :

<asp:DynamicControl runat="server" DataField="Client.SubField" />

Any insight is appreciated!

Combining view-only data and Dynamic Data on insert/edit pages

Hello all, here's a problem I've been trying to figure out an elegant solution for, but so far I'm coming up blank. I have a situation where I'd like to display view-only data and Dynamic Data together on the same page (without creating custom insert.aspx and edit.aspx pages). I've been playing around with using a SQL view, so that it returns me both my view-only fields and my updateable fields as well. I'm having issues with the insert side of things, the edit page works quite well, and I know I'm going to have to create custom delete logic. The major drawback to using a SQL view though is that to get it to behave you have to 'hack' the .edmx file, and I'm not sure I want to do that. So I guess what I'm asking is that has anyone had any success with this, or should I just bite the bullet and create custom pages for the situation of having view-only data and Dynamic Data on the same page? For the record I'm using the Release Candidate version of VS, and my website is an "ASP.NET Dynamic Entities Web Site". Thanks!

Creating Custom Page in Dynamic Data Application

To create a custom page I copied the List.Ascx file from the Page templates to DynamicData\CustomPage\"MytableName"

I keep getting the follwing errors mainly in list.aspx.designer

"The type 'L2SDynamicData.List' already contains a definition for GridView1"

"The type 'L2SDynamicData.List' already contains a definition for table1"

"The type 'L2SDynamicData.List' already contains a definition for HeadContent"

"The type 'L2SDynamicData.List' already contains a definition for DynamicDataManager1"

"The type 'L2SDynamicData.List' already contains a definition for UpdatePanel1"

There are about 32 of these error types

Creating Custom Page in Dynamic Data Application

To create a custom page I copied the List.Ascx file from the Page templates to DynamicData\CustomPage\"MytableName"

I keep getting the follwing errors mainly in list.aspx.designer

"The type 'L2SDynamicData.List' already contains a definition for GridView1"

"The type 'L2SDynamicData.List' already contains a definition for table1"

"The type 'L2SDynamicData.List' already contains a definition for HeadContent"

"The type 'L2SDynamicData.List' already contains a definition for DynamicDataManager1"

"The type 'L2SDynamicData.List' already contains a definition for UpdatePanel1"

There are about 32 of these error types


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All