How to Bind Sql DataSource using code?

Question

I have sql dataSource which i have binded with gridview.

where i have column name Rate where i am using ajax rating through that i am updating value in to data base and i also want to show that value after updation.

but its not showing updatede value untill page refresh.

<ItemTemplate>
    <table border="0" cellpadding="0" cellspacing="0" width="auto">
        <tr style="width:150px;" valign="top" >
            <td style="height:30px;">
            <asp:Label ID="lblTotalRate" runat="server" 
                    Text='<%#DataBinder.Eval(Container.DataItem, "TotalRate")%>'></asp:Label>

            </td>
        </tr>   
        <tr style="width:150px;" valign="top" >
            <td style="height:30px;">
                <asp:UpdatePanel ID="updtpnlTweet" runat="server">
                    <ContentTemplate>
                        <cc1:Rating ID="rateTweet" runat="server" CurrentRating='<%# Bind("Rating") %>' 
                            EmptyStarCssClass="empatyStarRating" FilledStarCssClass="filledStarRating" 
                            MaxRating="5" onchanged="rateTweet_Changed" StarCssClass="ratingStar" 
                            WaitingStarCssClass="savedStarRating">
                        </cc1:Rating>
                    </ContentTemplate>
                </asp:UpdatePanel>
            </td>
        </tr>
    </table>
</ItemTemplate>

Dewfy · Accepted Answer · 2010-01-22 10:09:40Z

1

This example miss code that forces UpdatePanel be changed. By default it would intercept any child posyback events. So just set Rating's AutoPostBack="true"

answered Jan 22, 2010 at 10:09

Dewfy

23.8k13 gold badges78 silver badges126 bronze badges

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

2 Comments

Pankaj Mishra Over a year ago

there is not such property in rating

Dewfy Over a year ago

@Pankaj Mishra Hmm, may be we are talking about different controls, but asp.net/ajax/ajaxcontroltoolkit/samples/Rating/Rating.aspx this control contains this property!

Collectives™ on Stack Overflow

How to Bind Sql DataSource using code?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related