or
I have a table named Orders with a field "ChildFirstName". I like to get the total count of each ChildFirstNameand its percentage against total number of table. I create the query for that is
SelectCommand="SELECT [ChildFirstName], [COUNT(ChildFirstName) AS
QuantityOrdered], [(QuantityOrdered * 100 / (SELECT COUNT(*) FROM
Orders)) AS Percentage] FROM [Orders] GROUP BY [ChildFirstName] ORDER BY
[ChildFirstName] DESC"
<Columns> <telerik:GridBoundColumn DataField="ChildFirstName" HeaderText="Child's First Name" SortExpression="ChildFirstName" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" UniqueName="ChildFirstName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="QuantityOrdered" HeaderText="Quantity Ordered" SortExpression="QuantityOrdered" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" UniqueName="QuantityOrdered"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Percentage" HeaderText="Percentage" SortExpression="Percentage" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" UniqueName="Percentage"> </telerik:GridBoundColumn> </Columns> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:freepersonalizedConnectionString %>" SelectCommand="SELECT [ChildFirstName], [COUNT(ChildFirstName) AS QuantityOrdered], [(QuantityOrdered * 100 / (SELECT COUNT(*) FROM Orders)) AS Percentage] FROM [Orders] GROUP BY [ChildFirstName] ORDER BY [ChildFirstName] DESC"> </asp:SqlDataSource>
<head> <title>Now you see it...</title></head><body> <form id="form1" runat="server"> <script type="text/javascript" language="javascript"> function showWindow() { var win = $find("<%= RadWindow1.ClientID %>"); alert(win); // Is NULL after post back win.show(); win.center(); } </script> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <telerik:RadWindowManager ID="RadWindowManager1" runat="server"> <Windows> <telerik:RadWindow ID="RadWindow1" runat="server"> <ContentTemplate> <asp:TextBox ID="tbTest" runat="server" /> </ContentTemplate> </telerik:RadWindow> </Windows> </telerik:RadWindowManager> <input type="button" onclick="showWindow()" value="Client Side" /> <asp:Button ID="btnShowWindow" runat="server" OnClick="btnShowWindow_Click" Text="Postback"/> </form></body></html>protected void btnShowWindow_Click(object sender, EventArgs e){ tbTest.Text = "The window will not appear"; string jScript = "showWindow();"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", jScript, true);}ItemStyle-BackColor
="White" AlternatingItemStyle-BackColor="White"