Creating a forum in ASP.NET
-
Hi, I am trying to create a basic forum in ASP.NET.I would like assistance in regards how i could go about designing a forum from a GUI point of view. How would i go about desiging the forum based on the following tables? I have a 3 tables Members ID Name Username Password Threads ThreadID ThreadTitle ThreadSubject Comments CommentsID ThreadID MemberID Comment The members ID is linked to the members ID in Threads table The thread ID is then linked to a thread ID in the Comments table The member ID is then linked to the member ID in the Comments table. I am using a DataGridView to display the the comments information from the comments table Is it neccessary to have a Comments table and keep the actual comments seperate in regards to design? Should i also put the thread title and username in the comments table? How could i go about designing the forum from "GUI" point of view? I would appreciate if anybody could advise please? Thanks,
-
Hi, I am trying to create a basic forum in ASP.NET.I would like assistance in regards how i could go about designing a forum from a GUI point of view. How would i go about desiging the forum based on the following tables? I have a 3 tables Members ID Name Username Password Threads ThreadID ThreadTitle ThreadSubject Comments CommentsID ThreadID MemberID Comment The members ID is linked to the members ID in Threads table The thread ID is then linked to a thread ID in the Comments table The member ID is then linked to the member ID in the Comments table. I am using a DataGridView to display the the comments information from the comments table Is it neccessary to have a Comments table and keep the actual comments seperate in regards to design? Should i also put the thread title and username in the comments table? How could i go about designing the forum from "GUI" point of view? I would appreciate if anybody could advise please? Thanks,
Eagle32 wrote:
Is it neccessary to have a Comments table and keep the actual comments seperate in regards to design?
From design prospective..Yes... necessary...No! Its about normalization... keeping it separate is good design.
Eagle32 wrote:
Should i also put the thread title and username in the comments table?
No. As said, normalization should be applied while DB designing... Keeping them together would break the Normalization rules and not a good practice.
Eagle32 wrote:
How could i go about designing the forum from "GUI" point of view?
Design the GUI as per your need/usability need. for start, fill few sheets of paper/ppt what looks a good flow, then try to develop accordingly.
-
Hi, I am trying to create a basic forum in ASP.NET.I would like assistance in regards how i could go about designing a forum from a GUI point of view. How would i go about desiging the forum based on the following tables? I have a 3 tables Members ID Name Username Password Threads ThreadID ThreadTitle ThreadSubject Comments CommentsID ThreadID MemberID Comment The members ID is linked to the members ID in Threads table The thread ID is then linked to a thread ID in the Comments table The member ID is then linked to the member ID in the Comments table. I am using a DataGridView to display the the comments information from the comments table Is it neccessary to have a Comments table and keep the actual comments seperate in regards to design? Should i also put the thread title and username in the comments table? How could i go about designing the forum from "GUI" point of view? I would appreciate if anybody could advise please? Thanks,
Check this out before you go and build something for yourself ... http://www.yetanotherforum.net/[^]