I want to find last writer in my forum page

Question

0.00/5 (No votes)

See more:

I have 2 tables.Their names are PersonelForumKonuBaslik(PersonelForumSubjectTitle) and PersonelForumCevap(PersonelForumAnswer)

sql><br

PersonelForumCevap(PersonelForumAnswer)
PersonelForumId 	                                int	
PersonelForumCevapId(PersonelForumAnswerId)Primarykey   int                                
PersonelForumCevapYanit(PersonelForumTitleAnswer)	nvarchar(500)	
PersonelForumSonCevapYazan(PersonelForumLastWriter)	nvarchar(50)

88 14 Ben çok üzüldüm merve
87 15 Bence iyi birisi merve
87 16 bencede berke
88 17 bende katılıyorum sana berke

my stored procedure is,

C#

select  A.PersonelForumId,
PersonelForumKonuBaslik,
PersonelForumBaslatan,
B.PersonelForumSonCevapYazan,
from PersonelForumKonuBaslik as A 
inner join PersonelForumCevap as B 
on B.PersonelForumId=A.PersonelForumId

This result
forumId PersonelForumTitle PersonelForumTitleStartWriter PersonelForumTitleAnswer
88 Recai Hocanın gidişi hamit merve
87 Hulya Hoca hakkkında ahmet merve
87 Hulya Hoca hakkkında ahmet berke
88 Recai Hocanın gidişi hamit berke

I want to last writer in webform page. i want to this result how can i do that?

forumId PersonelForumTitle PersonelForumTitleStartWriter PersonelForumTitleAnswer
88 Recai Hocanın gidişi hamit merve
87 Hulya Hoca hakkkında ahmet berke

Posted 11-Jun-11 0:38am

Ccsnow

Updated 12-Jun-11 3:52am

Kim Togo

v2

Add a Solution

Comments

Kim Togo 12-Jun-11 9:54am

Please use "Improve question" or "Add Comment" under Solution.

Ccsnow 12-Jun-11 16:35pm

<pre lang="msil">Personel KonuBaslik Tablom

PersonelForumId int P.key
PersonelForumUrl nvarchar(50)
PersonelForumKonuBaslik nvarchar(256)
PersonelForumKonuIcerik nvarchar(500)
PersonelForumBaslatan nvarchar(50)
PersonelForumSonYazanSaat datetime

Include Personel KonuBaslik

90 Resimlerim/dosya.gif HUlya hoca hakknda iyi birisi bence hamit 2011-06-12 17:58:18.000
91 Resimlerim/dosya.gif recai hoca hakknda nasl birisi sizce ahmet 2011-06-12 21:08:05.000

PersonelForumCevapTablom

PersonelForumId F.KEY int
PersonelForumCevapId P.KEY int
PersonelForumCevapUrl nvarchar(50)
PersonelForumCevapYanit nvarchar(500)
PersonelForumSonCevapYazan nvarchar(50)
Tarih datetime

Include PersonelForumCevapTablom

90 30 Resimlerim/yorum.gif yorum1 merve 2011-06-12 17:59:00.000
90 31 Resimlerim/yorum.gif yorum2 merve 2011-06-12 18:22:10.000
90 32 Resimlerim/yorum.gif yorum3 merve 2011-06-12 18:22:14.000
90 37 Resimlerim/yorum.gif ..... merve 2011-06-12 18:22:44.000
91 43 Resimlerim/yorum.gif iyiii a hmet 2011-06-12 21:08:12.000

ı have 2 titles but if i wanna to add title ı can do that.Number of title is not static.
My stored procedure is

ALTER proc [dbo].[ForumSon]
AS
SELECT A.PersonelForumId ,PersonelForumUrl,PersonelForumKonuBaslik,PersonelForumBaslatan,B.PersonelForumSonCevapYazan,B.Tarih from PersonelForumKonuBaslik as A inner join PersonelForumCevap as B on B.PersonelForumId=A.PersonelForumId order by B.Tarih desc

F.Id URL Title starter lastwriter date
91 Resimlerim/dosya.gif recai hoca hakkında ahmet ahmet 2011-06-12 21:08:12.000
90 Resimlerim/dosya.gif Hulya hoca hakkında hamit merve 2011-06-12 18:23:33.000
90 Resimlerim/dosya.gif Hulya hoca hakkında hamit merve 2011-06-12 18:23:29.000

i wanna to show this;
F.Id URL Title starter lastwriter date
91 Resimlerim/dosya.gif recai hoca hakkında ahmet ahmet 2011-06-12 21:08:12.000
90 Resimlerim/dosya.gif Hulya hoca hakkında hamit merve 2011-06-12 18:23:33.000

My STORED PROCEDURE IS

ALTER proc [dbo].[ForumSon]
AS
SELECT A.PersonelForumId ,PersonelForumUrl,PersonelForumKonuBaslik,PersonelForumBaslatan,B.PersonelForumSonCevapYazan,B.Tarih from PersonelForumKonuBaslik as A inner join PersonelForumCevap as B on B.PersonelForumId=A.PersonelForumId order by B.Tarih desc</pre>

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-06-11T01:11:00

Solution 1

I would add a DateTime column to the PersonelForumCevap table to hold the date and time the answer was posted, and use SORT in the stored procedure to return the latest. Anything else relies on the database internals.

Posted 11-Jun-11 1:11am

OriginalGriff