content views & comments

Question

if i post one content in website that can be approved by admin.after admin approval it will be visible in website. it is okay but here i need to save the count of views of that content and need to post comments for that.

how to proceed for read the count views and post a comment and reply for that comment.

if anyone knows please help me guys.....how to proceed

Joginder Banger · Answer

it's easy way used to repeater control . try the following link... http://www.aspdotnet-suresh.com/2012/01/repeater-control-example-in-aspnet.html

Sarath Kumar · Answer

Thanks for your reply, actually here my main concern is comments and reply for content. can you help me on that.

Joginder Banger · Answer

HI sarath Kumar, You need add more column in the table like that show the comment after admin approve. Admin Approve Problem : Question id ApproveComment NOTE :- Take the column Boolean type. 1 yes 2 NO 3 Yes Select * from questionTable where ApproveComment="yes" Count the View: you question post any one page like www.example.com/question/C# call here sql query on the page load event Make the view count table questionID count 1 10 2 20 3 30 update tablenemae set count+=1 where questionID i hope your problem almost solved.