update Ajax rating control, update comments

Question

I am trying to update the value of ajaxrating control and comments in the database`

`  <asp:GridView ID="GridView1" runat="server"  AutoGenerateColumns="false" DataKeyNames="id"
           onrowdatabound="GridView1_RowDataBound" >
        <Columns>
        <asp:BoundField  HeaderText="PurchasedPID"  DataField="PurchasedPID"/>
         <asp:BoundField  HeaderText="DatetimePurchased" DataField="orderdate" />
        <asp:BoundField  HeaderText="MMBName" DataField="MMBName" />
        <asp:TemplateField HeaderText="Rating">
        <ItemTemplate>
                    <asp:Rating  RatingDirection="LeftToRightTopToBottom" Visible="true" AutoPostBack="true"
                      ID="Rating2" runat="server" MaxRating="5"  

StarCssClass="star_rating" EmptyStarCssClass="star_empty" 
                          FilledStarCssClass="star_filled" WaitingStarCssClass="star_saved" CurrentRating='<%# Bind("Rating") %>'
                          OnChanged="Rating2_Changed" >
                        </asp:Rating>
                        </ItemTemplate>
                 </asp:TemplateField>

                 <asp:TemplateField HeaderText="Comments">
                 <ItemTemplate>
                 <asp:TextBox ID="TextBox1" runat="server" Text= '<%# Bind("Comments") %>' multiline="true">
                </asp:TextBox>
                 </ItemTemplate>
                 </asp:TemplateField>

                 <asp:TemplateField HeaderText="Action">
                 <ItemTemplate>
                <asp:LinkButton ID="LinkButton1" runat="server">Submit</asp:LinkButton>  
                 </ItemTemplate>
                 </asp:TemplateField>
    </Columns>
                       </asp:GridView>

So I added the following rowcommand event on of the members suggestion.

  protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Submit")
            {
                GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
                Int32 Id = Convert.ToInt32(e.CommandArgument);
                int ratingScore = ((AjaxControlToolkit.Rating)row.FindControl("Rating2")).CurrentRating;
                TextBox TextComments = row.FindControl("TextBox1") as TextBox;
                string comments = TextComments.Text;
                objBLL.UpdateRating(ratingScore, Id,comments);
            }

But here instead of getting the new rating, it is inserting the CurrentRating in the table.

  int ratingScore = ((AjaxControlToolkit.Rating)row.FindControl("Rating2")).CurrentRating;

I think its because of this CurrentRating here. Any idea how to get the value of updated rating? Or should i use an additional Rating_changed event to update the rate, and then a row command event to update the comments

Thanks Sun

Answer 1

The easiest way to bind the your DataKey/ItemID to the Tag attribute of the Rating control

<asp:Rating  RatingDirection="LeftToRightTopToBottom" Visible="true" 
     AutoPostBack="true"
     ID="Rating2" runat="server" MaxRating="5" **Tag='<%# Bind("id")%>'** 
     StarCssClass="star_rating" EmptyStarCssClass="star_empty" 
     FilledStarCssClass="star_filled" WaitingStarCssClass="star_saved"
     CurrentRating='<%# Bind("Rating") %>'
     OnChanged="Rating2_Changed" >
                    </asp:Rating>

Event Handler

protected void Rating2_Changed(object sender, AjaxControlToolkit.RatingEventArgs e)
    {
         Rating r = sender as Rating;
         int id = Convert.ToInt32(r.Tag);
         objBLL.UpdateRating(Convert.ToInt32(e.Value),id)
 }

Answer 2

You can use GridView1_RowCommand to update rating score in the DB. e.g.

 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "Rating")
    {
        GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
        Int32 Id = Convert.ToInt32(e.CommandArgument);
        ratingScore = ((AjaxControlToolkit.Rating)row.FindControl("Rating2")).CurrentRating;
    }
}

Set CommandName="Rating" to your linkbutton

<asp:TemplateField HeaderText="Action">
                <ItemTemplate>
                    <asp:LinkButton ID="LinkButton1" runat="server" CommandName="Rating">Submit</asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>