or
<telerik:RadPanelBar ID="RadPanelBar1" Runat="server" ExpandMode="FullExpandedItem" Height="700px" Width="280px"> <Items> <%--<!-- DEFAULT TABS FOR EITHER FMS OR POLICYHOLDER -->--%> <telerik:RadPanelItem Expanded="true" text="Favorites" Visible="true"> <ContentTemplate> <telerik:RadTreeView ID="_rtvwFavorites" runat="server" DataSourceID="XmlDataSource4" CheckBoxes="True" CheckChildNodes="True" TriStateCheckBoxes="False" > <DataBindings> <telerik:RadTreeNodeBinding DataMember="Node" TextField="Text" ExpandedField="Expanded" Checked="True" ValueField="ID"></telerik:RadTreeNodeBinding> </DataBindings> </telerik:RadTreeView> <asp:XmlDataSource ID="XmlDataSource4" runat="server" DataFile="~/Common/FavoritesTree.xml" XPath="/Favorites/Node"></asp:XmlDataSource> </ContentTemplate> </telerik:RadPanelItem> <telerik:RadPanelItem Text="Credit Union" Visible="true"> <ContentTemplate> <telerik:RadTreeView ID="_rtvwCreditUnion" runat="server" DataSourceID="XmlDataSource3" CheckBoxes="True" CheckChildNodes="True" TriStateCheckBoxes="False" > <DataBindings> <telerik:RadTreeNodeBinding DataMember="Node" TextField="Text" ExpandedField="Expanded" ValueField="ID"></telerik:RadTreeNodeBinding> </DataBindings> </telerik:RadTreeView> <asp:XmlDataSource ID="XmlDataSource3" runat="server" DataFile="~/Common/CuInfoTree.xml" XPath="/CUInfo/Node"></asp:XmlDataSource> </ContentTemplate> </telerik:RadPanelItem> <telerik:RadPanelItem Text="Financial" Visible="true"> <ContentTemplate> <telerik:RadTreeView ID="_rtvwFinancialList" Runat="server" DataSourceID="XmlDataSource1" CheckBoxes="True" CheckChildNodes="True" TriStateCheckBoxes="False" > <DataBindings> <telerik:RadTreeNodeBinding DataMember="Node" TextField="Text" ExpandedField="Expanded" ValueField="ID"></telerik:RadTreeNodeBinding> </DataBindings> </telerik:RadTreeView> <asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/Common/FinancialTree.xml" XPath="/Financial/Node"></asp:XmlDataSource> </ContentTemplate> </telerik:RadPanelItem> <telerik:RadPanelItem Text="Ratio" Visible="True"> <ContentTemplate> <telerik:RadTreeView ID="_rtvwRatioList" Runat="server" DataSourceID="_RatioListData" CheckBoxes="True" CheckChildNodes="True" TriStateCheckBoxes="False" Visible="True"> <DataBindings> <telerik:RadTreeNodeBinding DataMember="Node" TextField="Text" ExpandedField="Expanded" ValueField="ID"></telerik:RadTreeNodeBinding> </DataBindings> </telerik:RadTreeView> <asp:XmlDataSource ID="_RatioListData" runat="server" DataFile="~/Common/RatioTree.xml" XPath="/Ratio/Node"></asp:XmlDataSource> </ContentTemplate> </telerik:RadPanelItem> <%--<!-- END DEFAULT TABS --> </Items> </telerik:RadPanelBar>DateTime startDate = DateTime.Parse("2013-10-01");uxBookOrderGrid.MasterTableView.FilterExpression = "(([StatusDescription] LIKE \'%Approved%\') AND ([TimeStamp] >= '" + startDate.ToString("g") + "'))";uxBookOrderGrid.Rebind();<telerik:GridDateTimeColumn DataFormatString="{0:g}" DataType="System.DateTime" FilterControlWidth="90%" HeaderText="Date" DataField="TimeStamp" UniqueName="TimeStamp" /><telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="uxStaffList"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="uxStaffList" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings></telerik:RadAjaxManager><cc1:IbsRadGridList ID="uxStaffList" runat="server" Factory="StaffFactory" AllowPaging="true" PageSize="20" DeleteButtonVisible="false"> <MasterTableView DataKeyNames="StaffId"> <EditFormSettings UserControlName="StaffEditControl.ascx" PopUpSettings-Width="940px" CaptionDataField="FullName"></EditFormSettings> </MasterTableView></cc1:IbsRadGridList> ... <div class="control-group"> <asp:Label ID="BirthDateLabel" runat="server" CssClass="control-label" AssociatedControlID="uxBirthDate">Birthday</asp:Label> <div class="controls"> <telerik:RadDatePicker ID="uxBirthdate" runat="server" MinDate="1/1/1913" ClientEvents-OnPopupOpening="setDefaultBirthDate"></telerik:RadDatePicker> </div> </div> ...<script type="text/javascript"> function setDefaultBirthDate(sender, e) { if (sender.isEmpty()) { var d = new Date(); d.setFullYear(d.getFullYear() - 21); sender.set_selectedDate(d); } }</script>
<Columns> <telerik:GridNumericColumn DataField="CarID" DataType="System.Int32" HeaderText="ID" SortExpression="CarID" UniqueName="CarID" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" HeaderStyle-Width="100" ItemStyle-Width="100" FilterControlWidth="60" ReadOnly="false"/> <telerik:GridBoundColumn DataField="CarMake" DataType="System.String" HeaderText="Car Make" SortExpression="CarMake" UniqueName="CarMake" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" HeaderStyle-Width="120" ItemStyle-Width="120" FilterControlWidth="80" /> <telerik:GridBoundColumn DataField="CarModel" DataType="System.String" HeaderText="Car Model" SortExpression="CarModel" UniqueName="CarModel" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" HeaderStyle-Width="120" ItemStyle-Width="120" FilterControlWidth="80" /> <telerik:GridBoundColumn DataField="CarTrim" DataType="System.String" HeaderText="Car Trim" SortExpression="CarTrim" UniqueName="CarTrim" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" HeaderStyle-Width="200" ItemStyle-Width="200" FilterControlWidth="160"/> <telerik:GridNumericColumn DataField="CarYear" DataType="System.Int32" HeaderText="Car Year" SortExpression="CarYear" UniqueName="CarYear" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" HeaderStyle-Width="100" ItemStyle-Width="100" FilterControlWidth="60" /></Columns>Case "Save" For Each editedItem As GridEditableItem In RadGridViewExcelGridTest.EditItems Dim newValues As Hashtable = New Hashtable 'The GridTableView will fill the values from all editable columns in the hash e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem) SqlDataSourceExcelGridTest.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure SqlDataSourceExcelGridTest.UpdateCommand = "spExcelGridTestUpdateTable" SqlDataSourceExcelGridTest.UpdateParameters.Add(New Parameter("CarID", DbType.Int32)) SqlDataSourceExcelGridTest.UpdateParameters.Add(New Parameter("CarMake", DbType.String)) SqlDataSourceExcelGridTest.UpdateParameters.Add(New Parameter("CarModel", DbType.String)) SqlDataSourceExcelGridTest.UpdateParameters.Add(New Parameter("CarTrim", DbType.String)) SqlDataSourceExcelGridTest.UpdateParameters.Add(New Parameter("CarYear", DbType.Int32)) SqlDataSourceExcelGridTest.Update() editedItem.Edit = False NextALTER PROCEDURE [dbo].[spExcelGridTestUpdateTable] -- Add the parameters for the stored procedure here @CarID int, @CarMake varchar(100), @CarModel varchar(100), @CarTrim varchar (100), @CarYear intASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; UPDATE [dbo].[TestTable_Cars] SET CarMake=@CarMake, CarModel=@CarModel, CarTrim=@CarTrim, CarYear=@CarYear WHERE CarID=@CarIDENDSqlDataSourceExcelGridTest.UpdateParameters.Clear()
<telerik:RadGrid ID="HealthCheckStatus" runat="server" AllowPaging="false" AllowFilteringByColumn="true" AllowSorting="true" ViewStateMode="Enabled"> <MasterTableView CommandItemDisplay="Top"> <NoRecordsTemplate> <div class="no-records"> No records to display. </div> </NoRecordsTemplate> <Columns> <telerik:GridBoundColumn DataField="Name" HeaderText="Database Name" /> <telerik:GridBoundColumn DataField="Status" HeaderText="Status" /> <telerik:GridBoundColumn DataField="CopyQueueLength" HeaderText="Copy Queue Length" /> <telerik:GridBoundColumn DataField="ReplayQueueLength" HeaderText="Replay Queue Length" /> <telerik:GridDateTimeColumn DataField="LastInspectionLogTime" HeaderText="Last Inspection Log Time" /> <telerik:GridBoundColumn DataField="ContentIndexState" HeaderText="Content Index State" /> </Columns> <CommandItemSettings ShowAddNewRecordButton="false" ShowExportToExcelButton="true" ShowExportToCsvButton="true" ShowRefreshButton="false" /> </MasterTableView> <ExportSettings Excel-Format="ExcelML" HideStructureColumns="true" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true" /></telerik:RadGrid>Protected Sub HealthCheckStatus_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles HealthCheckStatus.NeedDataSource Dim queues As Collection(Of PSObject) = PSExchange( _ "get-mailboxdatabasecopystatus * | sort CopyQueueLength -descending | sort Name") HealthCheckStatus.DataSource = queuesEnd Sub