查看表上的SQL DATA [英] View SQL DATA on table

问题描述

大家好

首先，对不起我的英语不好.

我有一个带有评论的评分系统，我可以显示评分，但是如何以一种不错的方式显示所有评论，例如本页

Hi All

First of all, sorry for my bad English.

I have a rating system with comments, I can display rating but how can I display the comments on nice way, all comments, like this page http://www.yelp.com/biz/lazy-bear-san-francisco-3[^] take a look at comment how they list down on such a nice (user) way.

The app is SQL and asp.net (C#)

SQL Database :

ID
RATE
COMENT
DATE
USER

非常简单

谢谢

very simple

Thanks

推荐答案

将您的评论添加到列表视图控件中:

add your comments to a list view control:

<asp:ListView ID="lv" DataSourceID="dsCommnets" runat="server">
    <ItemTemplate>
        <%#Eval("Rate") %>
        <%#Eval("COMENT") %>
        <%#Eval("DATE") %>
        <%#Eval("USER") %>
    </ItemTemplate>
</asp:ListView>

这取决于您的样式风格！
并且如果在数据库中将ID身份放在自动增加上，则将数据源排序在Ascending上.

this is up to you how style this!
and if in database you put ID identity on auto increasement , put datasource sorting on Ascending.

我的建议试试AJX评级

下面的链接可能会为您提供帮助....


http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/Rating/Rating.aspx [ ^ ]

并查看此链接也

AJAX ASP.NET评级控件 [

My Advice Try it for AJX Rating

Below Link may help to you....


http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/Rating/Rating.aspx[^]

and check out this link also

AJAX ASP.NET Rating Control[^]

这篇关于查看表上的SQL DATA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！