Freigeben über

Tip #61: Did you know… How to create an ASP.Net Dynamic Data Web Site?

  • Artikel

If your web site is heavily data driven then here is a quick and easy way for you to create one without writing much code. All you need is Visual Studio 2008 SP1 or Visual Web Developer 2008 Express SP1 installed on your box.

Dynamic Data Web Sites makes use of a mechanism called Scaffolding. When Scaffolding is enabled it lets ASP.Net go through your data model and generate web pages for your tables. These generated pages have Insert, Delete and Update capabilities for each table.

Here are the steps:

Step 1: Create a Dynamic Data Web Site.

Go to File ->New Web Site  and select Dynamic Data Web Site template. Give it a name and select the location and language to be used. Click Ok button.

New Web Site

Step 2: Add data to your Web Site.

Copy paste pubs.mdf file that you want to use in your App_Data folder.

Step 3: Create a Data model using LINQ to SQL.

Right click on App_code and Add New LINQ to SQL Classes. On selecting the LINQ to SQL Classes the DataClasses.dbml opens up in your O/R Designer.

LINQ to SQL CLasses

Step 4: Drag drop tables to Object Relational Designer.

Now drag drop Authors table on to the O/R Designer from server explorer and save DataClassses.dbml.

DataClasses.dbml

 Step 5: Look what VS has created for you.

Note that there are two files DataClasses.dbml.layout and DataCalsses.designer.vb present under the .dbml file node.

Open DataCalsses.designer.vb, and you can see that there is a Partial Public Class DataClassesDataContext. This file also contains an entity class for Author table (Partial Public Class author).

Step 6: Register the data context in Global.asax file.

Open global.asax page and add the following lines of code in RegisterRoutes method.

VB code:

model.RegisterContext(GetType(AdventureWorksDataContext), _ New ContextConfiguration() With {.ScaffoldAllTables = True})

C# code:

model.RegisterContext(typeof(AdventureWorksDataContext), new ContextConfiguration() { ScaffoldAllTables = true });

Save the file.

Step 7: View the page in Browser

Now you can view default.aspx page using View in Browser. This will show you a link for Authors table.

Click on the table name and you will see a page with data from Authors Table. There is also readymade option for you to Edit, Delete and Insert new data.

AuthorTable 

Try this today and have fun!

Reshmi Mangalore

SDET, Web Development Tools

Comments

  • Anonymous
    May 14, 2009
    PingBack from http://microsoft-sharepoint.simplynetdev.com/tip-61-did-you-know%e2%80%a6-how-to-create-an-aspnet-dynamic-data-web-site/

  • Anonymous
    May 14, 2009
    Thank you for submitting this cool story - Trackback from DotNetShoutout

  • Anonymous
    May 14, 2009
    If your web site is heavily data driven then here is a quick and easy way for you to create one without

  • Anonymous
    May 14, 2009
    Hi, The blog mentions a static approach where the DB, table name etc are know during design time. Can we use Dynamic Data to connect to a DB using runtime Data ? Suppose I am developing an app where I I get Db name, connection paramaeters from a wevsrvice or an XML file, can I use ASP.NET Dynamic data in this scenario??? Or is it necessary that the DB and table structures need to be known during design time?

  • Anonymous
    May 15, 2009
    C#/VS2010 Null is Not Empty VS2010: On Triangles and Performance - It sure looks like the very soon Beta 1 will exhibit some great work on Outlining and Performance Parallel Tasks - new Visual Studio 2010 debugger window ASP.NET Tip #61: Did you know...How

  • Anonymous
    May 18, 2009
    I get am error when I add the following lines of code in the RegisterRoutes method: model.RegisterContext(GetType(AdventureWorksDataContext), _ New ContextConfiguration() With {.ScaffoldAllTables = True}) For "AdventureWorksDataContext", it says that the type is not defined.

  • Anonymous
    May 18, 2009
    Nevermind, my Data context had a different name.

  • Anonymous
    May 18, 2009
    The comment has been removed

  • Anonymous
    June 19, 2009
    Hi I want to know how I can add view or stored procedures to my dynamic data website. I have tried adding tables and views in data model but its not working.

  • Anonymous
    June 01, 2010
    I'm having the same problem as Sara above - except my DataContext is not mismatched. Help? Dave.

  • Anonymous
    June 19, 2011
    Hi I want to know how I can add view or stored procedures to my dynamic data website. I have tried adding tables and views in data model but its not working.

  • Anonymous
    June 19, 2011
    I'm having the same problem as Sara above - except my DataContext is not mismatched. Help?

  • Anonymous
    June 20, 2011
    @imran Please refer to the following link for examples on how to use sprocs with dynamic data forums.asp.net/.../1384041.aspx