create 5 star rating and show on page in c#

Devendra Kumar

9y5.7k.NET

hello friends i wants to create client review on my website

there user put own review with ratting and i want show there ratting on my page..

thanks

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Khaja Moizuddin9y ago
http://www.c-sharpcorner.com/forums/how-to-create-star-rating-using-asp-netc-sharp2 http://www.dotnetawesome.com/2013/12/how-to-implement-5-star-rating-system-inside-gridview.html https://www.codeproject.com/articles/9117/c-star-rating-control http://stackoverflow.com/questions/9195561/create-a-5-star-rating-control-with-hover-images-without-javascript http://stackoverflow.com/questions/37221576/wilson-score-for-1-5-star-rating-in-c-sharp http://stackoverflow.com/questions/19632358/star-rating-in-asp-net Hope this helps you
Ananth G9y ago
Add ajax toolkit
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using AjaxControlToolkit;

add above code to above namespace

<cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
cc1:ToolkitScriptManager>
<cc1:Rating ID="Rating1" AutoPostBack="true" OnChanged="OnRatingChanged" runat="server"
    StarCssClass="Star" WaitingStarCssClass="WaitingStar" EmptyStarCssClass="Star"
    FilledStarCssClass="FilledStar">
cc1:Rating>
<br />
<asp:Label ID="lblRatingStatus" runat="server" Text="">asp:Label>
protected void OnRatingChanged(object sender, RatingEventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("INSERT INTO UserRatings VALUES(@Rating)"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.AddWithValue("@Rating", e.Value);
                cmd.Connection = con;
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
    }
    Response.Redirect(Request.Url.AbsoluteUri);
}


protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = this.GetData("SELECT ISNULL(AVG(Rating), 0) AverageRating, COUNT(Rating) RatingCount FROM UserRatings");
        Rating1.CurrentRating = Convert.ToInt32(dt.Rows[0]["AverageRating"]);
        lblRatingStatus.Text = string.Format("{0} Users have rated. Average Rating {1}", dt.Rows[0]["RatingCount"], dt.Rows[0]["AverageRating"]);
    }
}

private DataTable GetData(string query)
{
    DataTable dt = new DataTable();
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(query))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                sda.Fill(dt);
            }
        }
        return dt;
    }
}
Devendra Kumar9y ago
Manas Mohapatra sir thanks for rply

i want show client review with there ratting

like:

show there review and show rating star with image
Devendra Kumar9y ago
hello amit singh sir thanks, for rply

i want user rating show with there comment

like:

nice prodcudt and there rating like 4 so view 4 star image..

thanks
Manas Mohapatra9y ago
Follow below links that may help you:

http://www.aspsnippets.com/Articles/ASPNet-AJAX-Rating-Extender-Control-Database-Example-How-to-save-and-display-Average-Rating-value-from-database.aspx

https://www.codeproject.com/articles/8570/a-rating-system-to-rate-your-online-articles-and-d

http://www.dotnetfunda.com/articles/show/2828/developing-a-star-rating-in-aspnet-mvc
Amit Kumar Singh9y ago
hey,

refer this

1.http://www.codeproject.com/Tips/503495/Simple-rating-control-using-jQuery
2.http://www.aspdotnet-suresh.com/2011/05/ajax-rating-control-sample-with.html
3.http://www.aspsnippets.com/Articles/ASPNet-AJAX-Rating-Control-Example.aspx
Salman Beg9y ago
Hi.
Please refer this article and implement the same and you can modify simply as per your requirement,

http://www.aspsnippets.com/Articles/Using-jQuery-Star-Rating-in-ASPNet.aspx
http://www.dotnetawesome.com/2013/12/how-to-implement-5-star-rating-system-inside-gridview.html

thanks
Devendra Kumar9y ago
Suvendu Shekhar Giri, thanks for rply

problem is that when user put there review like it put 4 and that is insert into database

and that how show there result with for star. thanks
Suvendu Shekhar Giri9y ago
Ok. So what is the problem here?

create 5 star rating and show on page in c#

Manas Mohapatra sir thanks for rply

Suvendu Shekhar Giri, thanks for rply problem is that when user put there review like it put 4 and that is insert into database and that how show there result with for star. thanks

Suvendu Shekhar Giri, thanks for rply

problem is that when user put there review like it put 4 and that is insert into database

and that how show there result with for star. thanks