create 5 star rating and show on page in c#

Question

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

Ananth G · Answer

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; } }

Amit Singh · Answer

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 · Answer

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

Khaja Moizuddin · Answer

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

Devendra Kumar · Answer

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 Kumar · Answer

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 Mohapatra · Answer

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

Devendra Kumar · Answer

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 · Answer

Ok. So what is the problem here?