tags:

views:

79

answers:

4

[ Edited Version ]

Note : I don't want to use open source CMS , and want to write my own here , This is a Designing Question

[ The question at first wasn't vague like this , because I wrote a numbered , styled , step-by-step question , but I don't know why the site didn't add the question , I shocked ! , and this question is a vague , simple version of it for a test or maybe a path to follow , ]

Here I explain the question in other form , Really I want to target both , first the idea ( the general algorithm ) and second the more detailed & advanced loot into this case ,

I want to make a site with articles that offered , something like DeveloperFusion.com 's Articles section Some Info

database : Sql Server

Unicode : yes

Pictures : Yes

Styles : yes

Steps & Issues

  1. After inserting a new article via a web editor , How to store the new item e.g : add that as a new record in the articles table in a html formatted version with using Server.HtmlEncode method

2a. In this way , what should be the data format NCLOB - Text - NVarChar(Max) or ...

2b. I dont know is this a common pattern or silly one , but instead of passing it to a database make a webpage with the name of the desired page and add the article-contents to it

3.the way that the client can reach the address e.g domain.com/articles/6643/ if the storage option be SQL how can we pass the code of this article & show that as a webpage

this question isn't for getting code , is specially for knowing the strategy , algorithm and format

+2  A: 

Writing a web application.

(Seriously, how broad is this question?)

annakata
LOL! A vague question **should** get a vague answer.
Cerebrus
@annakata ,I wrote a new version , hope it makes the question clear , thanks
Sypress
A: 

As annakata stated your question is very broad in scope. It appears from the tags you've specified that your after some kind of cms solution. Maybe have a look at this question for a selection of open source options which may fit your needs:

Which CMS to choose?

Andy Rose
+1  A: 

The question at first wasn't vague like this , because I wrote a numbered , styled , step-by-step question , but I don't know why the site didn't add the question , I shocked ! , and this question is a vague , simple version of it for a test or maybe a path to follow ,

Here I explain the question in other form , Really I want to target both , first the idea ( the general algorithm ) and second the more detailed & advanced loot into this case ,

I want to make a site with articles that offered , something like DeveloperFusion.com 's Articles section

Some Info

database : Sql Server

Unicode : yes

Pictures : Yes

Styles : yes

Steps & Issues

  1. After inserting a new article via a web editor , How to store the new item e.g : add that as a new record in the articles table in a html formatted version with using Server.HtmlEncode method

2a. In this way , what should be the data format NCLOB - Text - NVarChar(Max) or ...

2b. I dont know is this a common pattern or silly one , but instead of passing it to a database make a webpage with the name of the desired page and add the article-contents to it

3.the way that the client can reach the address e.g domain.com/articles/6643/ if the storage option be SQL how can we pass the code of this article & show that as a webpage

this question isn't for getting code , is specially for knowing the strategy , algorithm and format

Sypress
You should edit your original question, and not add an answer -- if that original question wasn't articulated correctly.
George Stocker
+1  A: 

Seems like you need a CMS solution, Why not try existing open source CMS solutions like Dotnet Nuke or Umbraco?

Chances are that, they have the features (and much more) you are looking for.

amazedsaint
Sypress