需要代码以查看所有已回答和未回答的问题 [英] Need code to see All answered and unanswered Quetions

问题描述

朋友需要代码以查看与codeProject网站相同的所有已回答和未回答的报价.

Friends Need code to see All answered and unanswered Quetions as same as that of codeProject site.

推荐答案

您好，

您必须为此要求设计好的数据库.

我为此设计了一个数据库...

Hi,

you''ve to design good database for this requirement.

I designed one database for it try this...

  The tableName QuestionsTab
 columns are qid(int),quest,ans,views

And AnswerTab table contains columns aid,ans,qid.

这仅是出于想法.请在您的实现中实现.

编写查询以通过以下查询来检索未回答的问题.

this is just for idea only .implement this with your implementation.

write query for retrieving unanswered questions by following query.

select * from QuestionsTab where ans<1

希望您对我的回答感到满意.

最好的

I hope you satisfied with my answer.

All the Best

这篇关于需要代码以查看所有已回答和未回答的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！