Output according to Tag Name

See more:

C#3.0

C#

ASP.NET

C#4.0

Hello,

Good Moring to all.

I am again with new problem

there are four tables.

1. tblQuestion

columns
i. QuestionID
ii. Question


2. tblAnswerChoice

Columns
i. AnswerChoiceID
ii. QuestionID
ii. AnswerChoice


3. tblTag

Columns
i. TagID
ii. Tag

4. tblTagQuestion

columns
i.TagQuestionID
ii.QuestionID
iii. TagID

I have one search button which search the all tags stored in the database and show all the question and answer choices of the question related to that tag.

Main problem is that tag is stored in tblTag, Question is stored in tblQuestion and answer choices are stored in tblAnswerChoice.

now the problem is that I want to show the Question and Choices according to there Tag Name. Mainly my requirement is to show Question and AnswerChoice which are of same Tag Name. But the Tag Name is sotored in the tblTag.
To the show the desired output I have to use all the four tables but how.

Thnaks,
Deepak