Count the records from DB and Display in UI

Posted by Jayashree under C# on 5/23/2011 | Points: 10 | Views : 1584 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I have Question table and Category table.Based on category some 30 questions are there.I need to count the total no of Questions in particular category and display into the UI when Particular user logged in.I m using asp.net with C# code. Help me pls.

jaya

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Lakhwinder.ghuman on: 5/23/2011 [Member] Starter | Points: 25

0	Hi its very simple You can write a query like Select CategoryTable.CategoryId,Count(QuestionTable.QuestionId) as NoOfQuestions from QuestionTable,CategoryTable where QuestionTable.CategoryId=CategoryTable.CategoryId Group By CategoryTable.CategoryId Best Regards Lakhwinder Ghuman Jayashree, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

dowload pdf files from server to local .asp.net mvc (0)New
Get +1-833-445-7444 Verizon Email Customer Support Number (0)New
specific cast is not valid in linq query when compare two tables (0)New
SEO(Search Engine Optimization) (0)New
Dial Hotmail Customer service Number +1-800-518-0963 (0)New
Best Assignment Help Services Provider (0)
How can a video in the website explain the navbar values? (1)
surge arresters price (1)Updated
More ...