Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 1.0 > C#
|
C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 6th, 2006, 03:45 PM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default What is the common way to show archives in weblog?

i want to create my own blogin c# and i m starting to design sql tables and
   i want to show months 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 my blog table...

create table tblWeblog (
    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,Logtime),
    LYear as datename(yy,Logtime),
    LIsActive bit null
)
--Question 1)In Lmonth it comes with month name in english,how can i change to german in sqlserver 2000, or do 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..
 
Old July 6th, 2006, 11:23 PM
Wrox Technical Editor
 
Join Date: Dec 2005
Posts: 271
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Daniel,

There are already a number or blogs (weblogs) created for the .NET Framework.
dasBlog, Community Server 2.0, Drupal, and .Text are just a couple of the popular choices. You may want to consider using one of these applications rather than re-inventing the wheel.

- Adam Kahtava [http://adam.kahtava.com]
 
Old July 7th, 2006, 07:45 AM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Adam,thanx for ur reply.
u r right .But i want to create my own blog and it isnt hard to do,i think.
as i said i just wondering which is the common way to handling datetime functions in sql server or in visual studio platform .which is the best and effective way .

Thanx

 Daniel..

 
Old July 7th, 2006, 06:18 PM
Wrox Technical Editor
 
Join Date: Dec 2005
Posts: 271
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If your question is SQL specific you should post it in an SQL forum.

Have you researched how others are building blogs? If not be sure to check out some tutorials.
An XML based (we)blog with RSS feed: http://www.codeproject.com/soap/weblog.asp


- Adam Kahtava [http://adam.kahtava.com]





Similar Threads
Thread Thread Starter Forum Replies Last Post
Common value scandalous Excel VBA 1 December 21st, 2007 11:01 PM
Getting data from WipZip archives elansolutionsltd Access VBA 1 November 20th, 2004 01:47 PM
Common question, not so common answer? flyin ADO.NET 5 March 24th, 2004 06:50 PM
excluding archives of a folder thomaz C# 4 March 8th, 2004 09:09 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.