asp.net c# gridview sorting by an AJAX rating control

Question

I have added an Ajax rating control to my Gridview as below:

  <asp:BoundField DataField="Wrms_QueryId" HeaderText="Warms_QueryId" ReadOnly="True" SortExpression="Wrms_QueryId" />
            <asp:TemplateField HeaderText="Favourites">
                <ItemTemplate>
                    <asp:Rating ID="Rating1" runat="server" AutoPostBack="true"  CurrentRating='<%# Bind("num") %>' MaxRating="3" RatingAlign="Horizontal"
                        RatingDirection="LeftToRightTopToBottom" StarCssClass="ratingStar" WaitingStarCssClass="savedRatingStar"
                        FilledStarCssClass="filledRatingStar" EmptyStarCssClass="emptyRatingStar" Tag='<%# Bind("Wrms_QueryId")%>' OnChanged="Rating1_Changed">
                    </asp:Rating>
                </ItemTemplate>
            </asp:TemplateField>

and in .cs

 protected void Rating1_Changed(object sender, EventArgs e)
{
    Rating ra= (Rating)sender; 
    GridViewRow gr=(GridViewRow) ra.Parent.Parent;          

    // table update required?

    Rating r = sender as Rating;
     int id = Convert.ToInt32(r.Tag);
     int lf = Convert.ToInt32(r.CurrentRating);
     string strSQL2 = "UPDATE [dbo].[wrms_config_m] set QueryId = " + lf + " where  Wrms_QueryId = " + id;
     ExecuteSQLUpdate(strSQL2);


}

but I don't know how to add sorting to the rating column. Normally I would just add SortExpression="####" but this doesn't seem to be supported for the rating column.

I have looked through lots of forums and can't find an answer. any help would be gratefully received please.

thanks

I'm not familiar with this control, but if you want the grid to re-sort itself on the change, wouldn't you have to rebind the grid? And if the "current rating" is bound to "num", shouldn't "num" be the SortExpression for the BoundColumn? — Ann L.
– Ann L., Commented Nov 6, 2012 at 20:30
thanks Ann L. You may be right regarding the rebind but as this is an Ajax control doesn't appear to be needed. The sort Expression and allow sorting properties just don't appear to be supported or make any difference to this control. — d20gdx
– d20gdx, Commented Nov 7, 2012 at 17:01

steve · Accepted Answer · 2012-11-29 14:50:58Z

1

Ok, resolved this myself. I was adding the sort to the wrong line. needed to be on

<asp:TemplateField HeaderText="Favourites" SortExpression="num">

answered Nov 29, 2012 at 14:50

steve

111 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

asp.net c# gridview sorting by an AJAX rating control

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related