Blog is one of the biggest contributor to the boom of CGM (Consumer Generated Media). Blog system can post articles, links, and allow visitors to leave comments to your posts. Blog can be the ultimate tool to build a web contents.
With ASP.Net, we can make a powerful and simple blog system.
Before we start to code our simple blog system, let's draw some ideas on the board.
2 parts to our simple blog system.
1. is to be able to add new, edit, delete the blog content.
2. is to be able to see blogs.
To do 1 and 2, I have set following tables
| fldBlogID |
int |
Key,Identity |
| fldBlogTitle |
nvarchar(255) |
|
| fldBlogCatagory |
nvarchar(255) |
|
| fldBlogTag |
nvarchar(255) |
|
| fldBlogBody |
nvarchar(Max) |
|
| fldBlogCDate |
datetime |
Date created |
| fldBlogLDate |
datetime |
Date last updated |
| fldBlogOwner |
nvarchar(256) |
Owner's name |
| fldBlogOK |
bit |
If ok publish it |
| fldBlogPublishDate |
datetime |
The date of publish |
| fldBlogParents |
int |
If it's the original post, set to 0 |