Questions tagged [dynamic-data-site]

9 questions
2
votes
4 answers

'row_number' is not a recognized function name. Incorrect syntax near the keyword 'AS'

I've created a simple project with an SQL Server database with dozens of tables and plenty of indices but nothing really complicated. No triggers, no stored procedures, no additional "database magic". The code is written in C#, using the Entity…
Wim ten Brink
  • 25,901
  • 20
  • 83
  • 149
1
vote
0 answers

Url Rewriting Dynamically according value in my database

I have successfully Developed a Dynamic web site in Asp.net. I have Renamed the default URL as Follows. routes.Add(new DynamicDataRoute("Dashboard.aspx") { Action = PageAction.List, ViewName = "ListDetails", …
user3859356
  • 679
  • 1
  • 7
  • 14
0
votes
2 answers

Entities and Dynamic Data Site: references between tables

I have two tables: CREATE TABLE [dbo].[Context] ( [Identity] int IDENTITY (1, 1) NOT NULL, [Naam] nvarchar (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Code] nvarchar (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, …
Wim ten Brink
  • 25,901
  • 20
  • 83
  • 149
0
votes
3 answers

Preventing empty strings becoming NULL in asp.net dynamic-data

I have a standard ASP.NET 4 Dynamic Data site (using Linq to SQL). In my SQL-Server database I have hundreds of varchar fields that are set to NOT NULL, but have a default value of an empty string. They should never be NULL, but they may have an…
Peter Hahndorf
  • 10,767
  • 4
  • 42
  • 58
0
votes
0 answers

Show data column instead of foreign key in dynamic data site

I am using asp.net dynamic data site. I have enabled scaffolding for all tables. It also displays foreign key. I want to display a data column instead of foreign key from the…
Waqar Janjua
  • 6,113
  • 2
  • 26
  • 36
0
votes
0 answers

how to add asp:dynamic control Value in textbox

I have dynamic control and a Text Box on client side inside update panel which reads data from database
salman m
  • 33
  • 7
0
votes
1 answer

How to avoid duplicate records insertion in asp.net dynamic data scaffolding?

How to create a common utility method for handling avoid duplicate records insertion before inserted into sql server database in asp.net dynamic data scaffolding?
0
votes
1 answer

Dynamic Data website - filtering the rows of child table with parent table value

I have created the application of Linq to Sql dynamic data site. I have many tables with the relational structure. For example: tblSite, tblSiteImage, tblSiteAdvertisement, tblGenericCategory, tblEntityType etc. tblSite is my parent table for all…
Vijay Pawar
  • 13
  • 1
  • 3
0
votes
2 answers

Adding "Export to XML" to Dynamic Data Site

Am working on a business layer for a complex web application and am temporary using the Dynamic Data Site functionality to allow data to be entered into the many tables that I need to maintain. I don't want to spend too much time on this DDS since…
Wim ten Brink
  • 25,901
  • 20
  • 83
  • 149