.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

Can a Dynamic Data page update a View?

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

Hi,

I just started working with Dynamic Data (asp.net 4, VS 2010 express, C#) and have tried to simplify the displaying/not displaying of columns by using a simple, single table, updatable SQL view.  Adding and displaying the view work and the in-line edit and update controls are there and seem functional but I can't access any of the columns.

Does DD not support updatable views or have I missed something?

Thanks, 




View Complete Post


More Related Resource Links

Disable filtering on a Dynamic Data list view.

  

I have an entity set of NotificationTemplates, and each one of these has a collection of zero-many SmsTemplate entities. When editing or viewing a NotificationTemplate, I have a link to View SMS Templates. That link takes me to a List view for the SmsTemplates entity set, filtered for the NotificationTemplate I was viewing.

How can I prevent the user changing this filter to show SmsTemplates for another NotificationTemplate? That is, I want the filter, but it must be read only. The drop-down just mustn't drop down, it must just display the name of the NotificationTemplate that these SmsTemplates belong to. To view SmsTemplates for another NotificationTemplate, the user must click View SMS Templates from that other template.


This was originally asked by myself on SatckOverflow at: http://stackoverflow.com/questions/3514373/disable-filtering-on-a-dynamic-data-list-view



Add page numbers for paging in data view web part

  

Hello all,

Has anyone found a solution that will allow me to have page numbers for paging in a data view web part. For instance, if I have 40 items/rows and I set the paging to display 10 items, I'd like the paging to show 1 2 3 4 rather than showing 1-10 and having to click next over and over to get to a specific item.

I found this article, but it is for 2003 and doesn't seem to apply to 2007 or if it does I am not able to really figure out how.

http://blogs.msdn.com/b/cjwalker/archive/2005/05/28/422826.aspx

Please help!

Thanks in advance.

S


making page work after DB update in Form View

  
I could really use some help with this issue. I have a DropDown that allows the selection of a Category Code. The selection populates a Gridview with details of records matching the Category Code. I have only enabled the Select option on the Gridview, which when clicked populates a Formview in Edit Mode with the full record information. When editing is complete and the Update link is clicked, I can not get the page to properly reload/postback. When another Category Code is selected from the Drop Down the Gridview does not report a list of records.   Any help would be greatly appreciated.   Thanks,              

How to pass page column value to data view parameters

  
Hi All, I have a page library with custom column, lets call it "FormCourseId". On that page I have data view which retrieves data from custom list filtered by page column "FormCourseId". In parameter wizard creates the following tag <ParameterBinding Name="ListCourseId" Location="Form(FormCourseId)" DefaultValue=""/> Then I try to use that parameter in XSLT of data view as a filter creteria.  <xsl:param name="CourseId"></xsl:param> It does not work for me. If I change data view parameter source from Form to Query String and pass parameter as url one it works fine. What is wrong with page column parameter binding? May be if FormCourseId column is not presented in form layout as a field(I do not need to show that field in user form of the page) it could not be treated as form parameter?

unable to update data to databse from grid view

  

I have two tables in my database

using "innerconnect" i have show table content in grid view as      INV_NO            INV_DT        DN_NO       DN_DT   LR_NO        LR_DT .

where LR_NO is null .

I want to update it from grid view plz help




TABLES









here  DN_NO  and INV_NO are primary keys

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace amar
{
    public partial class Form2 : Form
    {
        SqlConnection con;
        SqlDataAdapter da1,da2;
        SqlCommandBuilder cb;
    &nb

Would like to hide Formview's "Update/Cancel" and make data changes when new page is selected

  

I have a Formview that is only showing a question, and two checkboxes (True / False).  It's cumbersome for the client to have to click "Update" every time they click a checkbox.

Is there a way to have Formview update the data when the page is changed, or form is closed?  (I see those events, but know how to force data to update from in them).

The application is testing individuals, so 95% of the time the person navigating through the forms will be updating data.

 

Thanks!


Data View Web Part, update to Data Source / adding new list to existing data source

  

Hi all,

I have four Lists with identical columns :

List 1
List 2
List 3
List 4

I had to merge them, hence i created a data source ( Linked Source ) and merged these lists in SPD. I have used a data view webpart to display some columns from the merged lists data source and everything was working fine.

But now i have a new List : List 5 which also has the same columns like the other four lists and i need to update the data soure such that it is merged list of 5 lists not 4.

i updated the datasource property of the linked source to merge this new list as well. However the contents of List 5 dont appear in the data view webpart. 

Am i missing something here ? 

I dont want recreate the data view web part from scratch eachtime , because in future there might be List 6 , List 7 as well ... 


Dynamic Data Field template edits - Tooltip text, Dynamic Data Page template edits - field sort

  

I have an ASP.net website build in VB 2010 web dev pro using 4.0 framework.  Its a dynamic data site and I am having some trouble formating some of the field and page canned templates.

Q1: Field Templates - the tooltip code (TextBox1.ToolTip = Column.Description) is within the ascx.vp pages for each of the field templates.  Where can I update each columns description (as the code references) so the tooptip will be column/field specific.  If its not as straight forward as that, I was trying to write an if/else statement because the tooltip code is set at the field type level (decimal, date, etc) and I want it to be column specific.  example;

if column.value = Financial Impact

then  TextBox1.ToolTip = "enter financial impact in whole dollars"

else TextBox1.ToolTip = "next fields tooltip text"

 

<

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

 

 


Dynamic Data Foreign Key Filter - how to limit the # of dropdowns on the list view

  

Hello,

I have a visual basic website in VS 2010 framework 4, linx to SQL, with scafolding.... and this dataclass has about 10 foreign key fields, of which all 10 are shown in the list view of the website.  I want the ability to exclude those filters from the list view (or exclude some and keep some), but without eliminating them from the edit forms.  Using <scafoldingcolumn("False")> does the trick to remove them entirely but that will also remove them from the grid/list itself, which I don't want, and remove the column from the edit record views, which I don't want either.

Any help would be great!!!!


Update to .NET 3.5 SP1 Released (Dynamic Data Entity Framework Issue Fixed)

  

An update to .NET 3.5 SP1 has been recently released, you can search for KB959209 in the Microsoft Knowledgebase. Here is a direct link to the article: http://support.microsoft.com/kb/959209. This update is important for Dynamic Data users that are using the Entity Framework as it corrects the problem that the RTM version of Dynamic Data had with certain types of relationships with Entity Framework. This can been seen with 1->0..1 and *->1 relationships which may generate error messages like "'System.Web.UI.WebControls.EntityDataSourceWrapper' does not contain a property with the name 'Orders.OrderID'". Download and install this update to correct this issue.


Having trouble filtering data view inserted on DispForm.aspx by field value already on the page.

  
I have a DispForm.aspx page showing, of course, the names and values of fields of an item within a custom list that I have created.

I have inserted a dataview of another custom list onto this page.  Of course, when doing so, SharePoint Designer allows you to create a filter for this view.

I would like to filter this dataview using a value of a field of an item of the FIRST custom list (a value already shown on this page).

I mistakenly thought creating a data view parameter of "Form" source was the solution, but it is not.

Is there a way I can capture data appearing on the page (from the original DispForm) and use this value as a filter?

Any assistance would be most helpful.

Using User Controls as Page Templates in Dynamic Data

  

Hi All,

Recently, I saw an article at:

http://blogs.msdn.com/b/davidebb/archive/2008/11/25/using-user-controls-as-page-templates-in-dynamic-data.aspx

 

However, when I turn on the Select and Update Commands for the gridview, I get the following behaviours:

- Select: Columns disappear, leaving the template column

- Update: Data was not updated to the database.

 

Please kindly assist.

Thank you in advance.

 

Warmest Regards,

leroylll


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

 

 


Get primary key values from insert page and route to details page in a Dynamic Data Domain Service A

  

I finally figured out how to retrieve primary key values from the insert page template that are inserted via defaults in a SQL Server database. I wanted to get the keys so that I could route the user from the insert page template to the details page template (regardless of whether it’s a custom route or not). There are a number of scenarios where separate insert and details pages are desirable, and routing from the insert page back to the list page is not desirable as Dynamic Data does out of the box. Since I could not find an answer to this problem anywhere with significant effort, I decided I would document it for others, I hope you find it useful - it turns out that it's quite simple under 10 lines of code. I also applied the same idea to a Dynamic Data Entities application which works exactly the same except for two minor changes, I have documented it below as well.

For starters, as is documented plenty elsewhere but bears repeating here, you must first annotate your Entity Data Model with ScaffoldColumn = false for identity columns and guids that get assigned with newid() in thedatabase. This tells Dynamic Data not to attempt to pass a null value from the page through to

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

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend