I want to display my forum in a category wise like
I want to display this as a category wise,forum name is displayed more than once how to solve this,please any one can suggest me,i added this in a table and also i added title id for each forum,
Pls any one can tell me to solve this problem
Title User Last Post
Software Forum
Java
it is a complicated language nandhu 12/27/2010 12:09:43 PM
Software Forum
about unit testing
I dont know the definition of unit testing,any one suggest me
vishnu 1/13/2011 12:15:00 AM
Hardware Forum
network
in network i dont know the diff between hub and router,pls any one can explain me vani 12/27/2010 1:11:04 PM
Hardware Forum
cddrive
24x readspeed 4x write speed brand lg, tray is jamming what is the solution vani 12/27/2010 1:27:13 PM
i use this coding
while (rdr.Read())
{
Response.Write("
string str = rdr["title"].ToString();
string user = rdr["owner"].ToString();
Response.Write(String.Format("
{1}
Response.Write("
}
krithika muthukrishnanPosted Jan 24, 2011, 6:25 AM
hi,
here i used two table one for question and other for category like hardware forum ,software forum etc,titleid based on forum like software forum titleid is 1,its going on,
select topic1.title,topic1.titleid,topic1.suggestion,topic1.owner,topic1.date ,titlename.category from topic1 INNER JOIN titlename ON topic1.titleid=titlename.titleid
using this query i already sorted based on titleid
Suthish NairPosted Jan 24, 2011, 6:10 AM
Sort your rows from DB itself by category wise.