or
| <telerik:RadGrid |
| ID="RadGrid1" runat="server" |
| Width="95%" |
| OnNeedDataSource="RadGrid1_NeedDataSource" |
| > |
| <MasterTableView AutoGenerateColumns="false"> |
| <Columns> |
| <telerik:GridBoundColumn DataField="id" Visible="false" ReadOnly="true"></telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="symbol" HeaderText="Symbol" ReadOnly="true" ></telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="buyprice" HeaderText="Buy Price" DataType="System.Decimal" DataFormatString="{0:C}" ></telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="totalcost" HeaderText="Total Cost" DataType="System.Decimal" DataFormatString="{0:C}" ></telerik:GridBoundColumn> |
| <telerik:GridButtonColumn ConfirmText="Are you sure?" ConfirmDialogType="Classic" ButtonType="ImageButton" ImageUrl="/images/delete.gif"CommandName="Delete"> |
| </telerik:GridButtonColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e) |
| { |
| string XMLFilePath = getXMLPath(); |
| DataSet ds = new DataSet(); |
| ds.ReadXml(XMLFilePath); |
| DataView dv = new DataView(ds.Tables[0]); |
| dv.Sort = "datecalculated DESC"; |
| RadGrid1.DataSource = dv; |
| } |
| <?xml version="1.0" encoding="utf-8"?> |
| <calculations> |
| <calculation id="1" symbol="SYM1" buyprice="3.4" totalcost="831.483" datecalculated="06/30/2010" /> |
| <calculation id="2" symbol="SYM2" buyprice="10.74" totalcost="1088" datecalculated="06/17/2010" /> |
| </calculations> |
Do While RS.Read If RS(0) = 1 Then Dim Node As New RadTreeNode Node.Text = (RS(2) & " " & RS(3) & " (" & RS(1) & ")") Node.Value = RS(1) Node.Checkable = True RadTreeView1.Nodes.Add(Node) Else Dim foundNode As RadTreeNode = RadTreeView1.FindNodeByValue(RS(5)) If foundNode IsNot Nothing Then Dim Node As New RadTreeNode Node.Text = (RS(2) & " " & RS(3) & " (" & RS(1) & ")") Node.Value = RS(1) Node.Checkable = False foundNode.Nodes.Add(Node) End If End IfImports Telerik.Web.UIPartial Class Hierarchy_Compression Inherits System.Web.UI.Page Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click Dim Compression As IList(Of RadTreeNode) = RadTreeView1.CheckedNodes For Each node As RadTreeNode In Compression If node.Checked = True Then Response.Write(node.Value) End If Next End SubEnd Class<%@ Page Language="C#" AutoEventWireup="true" %><script runat="server"> protected void Page_Load(object sender, EventArgs e) { for (int i = 0; i < 10; i++) { rcb1.Items.Add(new RadComboBoxItem(i.ToString(), i.ToString())); } } protected void btnSubmit_Click(object sender, EventArgs e) { ltlMessage.Text = DateTime.Now.ToString() + " - Postback Fired."; } </script><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="rsm1" runat="server"></telerik:RadScriptManager> <div> <asp:Panel ID="pnlSubmit" runat="server" DefaultButton="btnSubmit"> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br /> <telerik:RadTextBox ID="txtText" runat="server"></telerik:RadTextBox><br /> <telerik:RadDatePicker ID="rdp1" runat="server"></telerik:RadDatePicker><br /> <telerik:RadTimePicker ID="rtp1" runat="server"></telerik:RadTimePicker><br /> <telerik:RadComboBox ID="rcb1" runat="server" AllowCustomText="true"> </telerik:RadComboBox><br /> <telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server"> </telerik:RadNumericTextBox><br /> <telerik:RadMaskedTextBox ID="RadMaskedTextBox1" runat="server" Mask="####"> </telerik:RadMaskedTextBox><br /> <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click"></asp:Button> <br /> <asp:Literal ID="ltlMessage" runat="server"></asp:Literal> </asp:Panel> </div> </form> </body></html>sectionRowIndex is always -1. It is not working for IE*. Any other suggestion?
http://www.telerik.com/community/code-library/aspnet-ajax/grid/move-rows-up-down-using-radgrid-for-asp-net-ajax-prometheus.aspxCreate Proc test
as
DECLARE @query VARCHAR(4000)
DECLARE @years VARCHAR(2000)
SELECT @years = STUFF((SELECT DISTINCT
'],[' + ltrim(Dyear)
FROM Product2
ORDER BY '],[' + ltrim(Dyear)
FOR XML PATH('')
), 1, 2, '') + ']'
SET @query =
'SELECT * FROM
(
SELECT prodId,Dyear,amount
FROM Product2
)t
PIVOT (SUM(amount) FOR Dyear
IN ('+@years+')) AS pvt'
EXECUTE (@query)