Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Well; creating a CMS is quite time-consuming. I've built a couple of .NET CMS's (and used several) and I can tell you, it's a lot of work to make something usable.</p> <p>You could instead try using an existing free CMS (this would be my recommendation): -</p> <p><a href="http://www.orchardproject.net/" rel="nofollow">http://www.orchardproject.net/</a></p> <p>Or you could try create one yourself: -</p> <ul> <li><p>Create database table(s) designed to hold different types of content, i.e. BlogPost, Product, DynamicPage, etc</p></li> <li><p>Make sure these tables have the kinds of fields you'll need to create content from: -</p></li> </ul> <blockquote> <ul> <li>Title</li> <li>MetaKeywords</li> <li>MetaDescription</li> <li>Precis</li> <li>Content (make this big, like NVARCHAR(MAX))</li> </ul> </blockquote> <ul> <li>Create admin pages that allow an admin user to create, update and delete items in these tables. You could use a WYSiWYG editor such as TinyMCE for the content. For example, your admin pages might be: -</li> </ul> <blockquote> <pre><code> - Blog List - Blog Add/Edit - Product List - Product Add/Edit </code></pre> </blockquote> <ul> <li>Create front-end templates for these tables designed to display their content. These would be along the same lines as the admin pages, except you're displaying them in your public site, not your admin pages, so their page template names might be: -</li> </ul> <blockquote> <ul> <li>Blogs.aspx</li> <li>Blog.aspx</li> <li>Products.aspx</li> <li>Product.aspx</li> </ul> </blockquote> <ul> <li>Figure out how to render menus and a footer from the same content</li> </ul> <p>Sorry if that sounds a bit vague; your content requirements will probably be different and as I said, <em>making</em> a CMS can be quite a lot of work.</p> <p>You could also try googling: -</p> <p><a href="http://www.dotnetfunda.com/forums/show/10041/creating-cms-with-aspnet" rel="nofollow">http://www.dotnetfunda.com/forums/show/10041/creating-cms-with-aspnet</a></p> <p>Hope that helps friend</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat technique should I apply in creating articles in ASP.Net app
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USsh1rts
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat technique should I apply in creating articles in ASP.Net app
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks alot, at least i have seen a guideline needed.. Hopefully, am gonna make something out of
      singulars
      1. PO
      1. USPrince Tegaton
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload