What is the common way to show archives in weblog?

[DanielXIX]

i want to create my own blog in c# and i m starting to design sql tables and
i want to show my archive posts in that way,
e.g
Juli 2006(2) here 2 is the total post of blog articles in July.
Agust 2006(10)
September 2006(34)
Oktober 2006(23)
and so on...




Here is my blog table...

create table tblBlogg (
LId int IDENTITY(1,1) primary key,
LUserId int not null,
LCategoryId int null,
LCaption nvarchar(50) null,
LBody ntext null,
LTime datetime not null default(getdate()),
LMonth as datename(m,Ltime),
LYear as datename(yy,Ltime),
LIsActive bit null
)
--Question 1)In Lmonth it comes with month name in english,how can i change to german in sqlserver 2000, or i have to do in c# function?
--Question 2)do i need LMonth and LYear columns ? What is the common way? is Ltime column enough for that? for example, c# datetime functions may accomplish this task.

Any help greatly appreaciated.

Daniel..

 

[tperri]

1) I think you would use localization in C#, but I'm not experienced with it, so I can't give you a detailed answer.

2) You don't need any field but a DateTime field. You can extract the month, day, year, day of week, etc from that in your C# as needed.

 

[DanielXIX]

thanx for ur reply.