Hello,

We have a RadGrid which is displaying some jobs.  It has 3 columns:  Job name, Run Time and Status.  In the ItemDataBound event of the RadGrid, we have a case statement which changes the text value of Run Time depending on the status of the job.  If the job is scheduled to run in the future, its next run date is shown in the Run Time column.  However, if the job is either running or pending, the job's last modified date is shown in the Run Time column. 

The problem that we have now is that we would like to sort by the value in the Run Time column, but since the Run Time column does not have one underlying datasource field, the sorting is not working correctly.  Is there a way to sort by the text value in the column and not by an underlying datasource field? 

If anyone also has an alternate idea, I'd welcome that as well; it's always possible that I'm overlooking a better solution.  :)  Thanks in advance for any help that anyone can give.

Regards,
John

I just migrated to 2011 version, and I cannot find where to add the select button.

I have a master table and a child table. I used to be able to add a select button/link at master table and would show related records in child table when clicked. Can you tell me how to do that in 2011?

Thanks

Bil


here is my aspx

<%

@ Page Language="VB" AutoEventWireup="false" CodeFile="SchedulingOptions.aspx.vb" Inherits="SchedulingOptions" %>

 

<%

@ 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>

 

 

<style type="text/css">

 

 

#form1

 

{

 

text-align: center;

 

}

 

</style>

 

</

 

head>

 

<

 

body>

 

 

<form id="form1" runat="server">

 

 

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

 

 

</telerik:RadScriptManager>

 

 

<div style="text-align: left">

 

 

 

<br />

 

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:5ConnectionString1 %>"

 

 

DeleteCommand="DELETE FROM [s_ServiceScheduling] WHERE [ServiceID] = @ServiceID"

 

 

InsertCommand="INSERT INTO [s_ServiceScheduling] ([Online_RequestsID], [Service], [Service_Description], [Display_Order], [PreBookMaxTime], [PrebookMaxTimeUnits], [PrebookMinTime], [PrebookMikTimeUnits], [CancelMaxTime], [CancelMaxTimeUnits], [AllowCancel], [PrePaymentRequired], [Service_Type], [Servicee_Title], [Server_Title], [Booking_Title], [BaseAddress], [BaseCity], [BaseState], [BaseZipCode], [Active]) VALUES (@Online_RequestsID, @Service, @Service_Description, @Display_Order, @PreBookMaxTime, @PrebookMaxTimeUnits, @PrebookMinTime, @PrebookMikTimeUnits, @CancelMaxTime, @CancelMaxTimeUnits, @AllowCancel, @PrePaymentRequired, @Service_Type, @Servicee_Title, @Server_Title, @Booking_Title, @BaseAddress, @BaseCity, @BaseState, @BaseZipCode, @Active)"

 

 

ProviderName="<%$ ConnectionStrings:5ConnectionString1.ProviderName %>"

 

 

SelectCommand="SELECT [ServiceID], [Online_RequestsID], [Service], [Service_Description], [Display_Order], [PreBookMaxTime], [PrebookMaxTimeUnits], [PrebookMinTime], [PrebookMikTimeUnits], [CancelMaxTime], [CancelMaxTimeUnits], [AllowCancel], [PrePaymentRequired], [Service_Type], [Servicee_Title], [Server_Title], [Booking_Title], [BaseAddress], [BaseCity], [BaseState], [BaseZipCode], [Active] FROM [s_ServiceScheduling]"

 

 

UpdateCommand="UPDATE [s_ServiceScheduling] SET [Online_RequestsID] = @Online_RequestsID, [Service] = @Service, [Service_Description] = @Service_Description, [Display_Order] = @Display_Order, [PreBookMaxTime] = @PreBookMaxTime, [PrebookMaxTimeUnits] = @PrebookMaxTimeUnits, [PrebookMinTime] = @PrebookMinTime, [PrebookMikTimeUnits] = @PrebookMikTimeUnits, [CancelMaxTime] = @CancelMaxTime, [CancelMaxTimeUnits] = @CancelMaxTimeUnits, [AllowCancel] = @AllowCancel, [PrePaymentRequired] = @PrePaymentRequired, [Service_Type] = @Service_Type, [Servicee_Title] = @Servicee_Title, [Server_Title] = @Server_Title, [Booking_Title] = @Booking_Title, [BaseAddress] = @BaseAddress, [BaseCity] = @BaseCity, [BaseState] = @BaseState, [BaseZipCode] = @BaseZipCode, [Active] = @Active WHERE [ServiceID] = @ServiceID">

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

</DeleteParameters>

 

 

<InsertParameters>

 

 

<asp:Parameter Name="Online_RequestsID" Type="Int32" />

 

 

<asp:Parameter Name="Service" Type="String" />

 

 

<asp:Parameter Name="Service_Description" Type="String" />

 

 

<asp:Parameter Name="Display_Order" Type="Int32" />

 

 

<asp:Parameter Name="PreBookMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="PrebookMinTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMikTimeUnits" Type="String" />

 

 

<asp:Parameter Name="CancelMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="CancelMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="AllowCancel" Type="Boolean" />

 

 

<asp:Parameter Name="PrePaymentRequired" Type="Boolean" />

 

 

<asp:Parameter Name="Service_Type" Type="String" />

 

 

<asp:Parameter Name="Servicee_Title" Type="String" />

 

 

<asp:Parameter Name="Server_Title" Type="String" />

 

 

<asp:Parameter Name="Booking_Title" Type="String" />

 

 

<asp:Parameter Name="BaseAddress" Type="String" />

 

 

<asp:Parameter Name="BaseCity" Type="String" />

 

 

<asp:Parameter Name="BaseState" Type="String" />

 

 

<asp:Parameter Name="BaseZipCode" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

</InsertParameters>

 

 

<UpdateParameters>

 

 

<asp:Parameter Name="Online_RequestsID" Type="Int32" />

 

 

<asp:Parameter Name="Service" Type="String" />

 

 

<asp:Parameter Name="Service_Description" Type="String" />

 

 

<asp:Parameter Name="Display_Order" Type="Int32" />

 

 

<asp:Parameter Name="PreBookMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="PrebookMinTime" Type="Int32" />

 

 

<asp:Parameter Name="PrebookMikTimeUnits" Type="String" />

 

 

<asp:Parameter Name="CancelMaxTime" Type="Int32" />

 

 

<asp:Parameter Name="CancelMaxTimeUnits" Type="String" />

 

 

<asp:Parameter Name="AllowCancel" Type="Boolean" />

 

 

<asp:Parameter Name="PrePaymentRequired" Type="Boolean" />

 

 

<asp:Parameter Name="Service_Type" Type="String" />

 

 

<asp:Parameter Name="Servicee_Title" Type="String" />

 

 

<asp:Parameter Name="Server_Title" Type="String" />

 

 

<asp:Parameter Name="Booking_Title" Type="String" />

 

 

<asp:Parameter Name="BaseAddress" Type="String" />

 

 

<asp:Parameter Name="BaseCity" Type="String" />

 

 

<asp:Parameter Name="BaseState" Type="String" />

 

 

<asp:Parameter Name="BaseZipCode" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

</UpdateParameters>

 

 

</asp:SqlDataSource>

 

 

<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True"

 

 

AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowSorting="True"

 

 

AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"

 

 

AutoGenerateHierarchy="True" CellSpacing="0" DataSourceID="SqlDataSource1"

 

 

GridLines="None">

 

<

 

HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

 

<

 

MasterTableView AllowAutomaticDeletes="False" AllowAutomaticInserts="False"

 

 

AllowAutomaticUpdates="False" AllowSorting="False" AutoGenerateColumns="False"

 

 

CommandItemDisplay="Top" DataKeyNames="ServiceID" DataSourceID="SqlDataSource1">

 

<

 

CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

 

<

 

RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

 

</

 

RowIndicatorColumn>

 

<

 

ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

 

</

 

ExpandCollapseColumn>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="ServiceID" DataType="System.Int32"

 

 

FilterControlAltText="Filter ServiceID column" HeaderText="ServiceID"

 

 

ReadOnly="True" SortExpression="ServiceID" UniqueName="ServiceID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Online_RequestsID" DataType="System.Int32"

 

 

FilterControlAltText="Filter Online_RequestsID column"

 

 

HeaderText="Online_RequestsID" SortExpression="Online_RequestsID"

 

 

UniqueName="Online_RequestsID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Service"

 

 

FilterControlAltText="Filter Service column" HeaderText="Service"

 

 

SortExpression="Service" UniqueName="Service">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Service_Description"

 

 

FilterControlAltText="Filter Service_Description column"

 

 

HeaderText="Service_Description" SortExpression="Service_Description"

 

 

UniqueName="Service_Description">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Display_Order" DataType="System.Int32"

 

 

FilterControlAltText="Filter Display_Order column" HeaderText="Display_Order"

 

 

SortExpression="Display_Order" UniqueName="Display_Order">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PreBookMaxTime" DataType="System.Int32"

 

 

FilterControlAltText="Filter PreBookMaxTime column" HeaderText="PreBookMaxTime"

 

 

SortExpression="PreBookMaxTime" UniqueName="PreBookMaxTime">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PrebookMaxTimeUnits"

 

 

FilterControlAltText="Filter PrebookMaxTimeUnits column"

 

 

HeaderText="PrebookMaxTimeUnits" SortExpression="PrebookMaxTimeUnits"

 

 

UniqueName="PrebookMaxTimeUnits">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PrebookMinTime" DataType="System.Int32"

 

 

FilterControlAltText="Filter PrebookMinTime column" HeaderText="PrebookMinTime"

 

 

SortExpression="PrebookMinTime" UniqueName="PrebookMinTime">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PrebookMikTimeUnits"

 

 

FilterControlAltText="Filter PrebookMikTimeUnits column"

 

 

HeaderText="PrebookMikTimeUnits" SortExpression="PrebookMikTimeUnits"

 

 

UniqueName="PrebookMikTimeUnits">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="CancelMaxTime" DataType="System.Int32"

 

 

FilterControlAltText="Filter CancelMaxTime column" HeaderText="CancelMaxTime"

 

 

SortExpression="CancelMaxTime" UniqueName="CancelMaxTime">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="CancelMaxTimeUnits"

 

 

FilterControlAltText="Filter CancelMaxTimeUnits column"

 

 

HeaderText="CancelMaxTimeUnits" SortExpression="CancelMaxTimeUnits"

 

 

UniqueName="CancelMaxTimeUnits">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="AllowCancel" DataType="System.Boolean"

 

 

FilterControlAltText="Filter AllowCancel column" HeaderText="AllowCancel"

 

 

SortExpression="AllowCancel" UniqueName="AllowCancel">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridCheckBoxColumn DataField="PrePaymentRequired"

 

 

DataType="System.Boolean"

 

 

FilterControlAltText="Filter PrePaymentRequired column"

 

 

HeaderText="PrePaymentRequired" SortExpression="PrePaymentRequired"

 

 

UniqueName="PrePaymentRequired">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridBoundColumn DataField="Service_Type"

 

 

FilterControlAltText="Filter Service_Type column" HeaderText="Service_Type"

 

 

SortExpression="Service_Type" UniqueName="Service_Type">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Servicee_Title"

 

 

FilterControlAltText="Filter Servicee_Title column" HeaderText="Servicee_Title"

 

 

SortExpression="Servicee_Title" UniqueName="Servicee_Title">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Server_Title"

 

 

FilterControlAltText="Filter Server_Title column" HeaderText="Server_Title"

 

 

SortExpression="Server_Title" UniqueName="Server_Title">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Booking_Title"

 

 

FilterControlAltText="Filter Booking_Title column" HeaderText="Booking_Title"

 

 

SortExpression="Booking_Title" UniqueName="Booking_Title">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseAddress"

 

 

FilterControlAltText="Filter BaseAddress column" HeaderText="BaseAddress"

 

 

SortExpression="BaseAddress" UniqueName="BaseAddress">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseCity"

 

 

FilterControlAltText="Filter BaseCity column" HeaderText="BaseCity"

 

 

SortExpression="BaseCity" UniqueName="BaseCity">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseState"

 

 

FilterControlAltText="Filter BaseState column" HeaderText="BaseState"

 

 

SortExpression="BaseState" UniqueName="BaseState">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="BaseZipCode"

 

 

FilterControlAltText="Filter BaseZipCode column" HeaderText="BaseZipCode"

 

 

SortExpression="BaseZipCode" UniqueName="BaseZipCode">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="Active" DataType="System.Boolean"

 

 

FilterControlAltText="Filter Active column" HeaderText="Active"

 

 

SortExpression="Active" UniqueName="Active">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridButtonColumn FilterControlAltText="Filter column column"

 

 

UniqueName="column">

 

 

</telerik:GridButtonColumn>

 

 

<telerik:GridHyperLinkColumn FilterControlAltText="Filter column1 column"

 

 

UniqueName="column1">

 

 

</telerik:GridHyperLinkColumn>

 

 

</Columns>

 

<

 

EditFormSettings>

 

<

 

EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

 

</

 

EditFormSettings>

 

</

 

MasterTableView>

 

 

<ClientSettings>

 

 

<Selecting AllowRowSelect="True" />

 

 

</ClientSettings>

 

<

 

FilterMenu EnableImageSprites="False"></FilterMenu>

 

 

</telerik:RadGrid>

 

 

<br />

 

 

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"

 

 

DataKeyNames="ServerID" DataSourceID="SqlDataSource2"

 

 

EmptyDataText="There are no data records to display.">

 

 

<Columns>

 

 

<asp:BoundField DataField="ServerID" HeaderText="ServerID" ReadOnly="True"

 

 

SortExpression="ServerID" />

 

 

<asp:BoundField DataField="UserID" HeaderText="UserID"

 

 

SortExpression="UserID" />

 

 

<asp:BoundField DataField="UserName" HeaderText="UserName"

 

 

SortExpression="UserName" />

 

 

<asp:BoundField DataField="First_Name" HeaderText="First_Name"

 

 

SortExpression="First_Name" />

 

 

<asp:BoundField DataField="MI" HeaderText="MI" SortExpression="MI" />

 

 

<asp:BoundField DataField="Last_Name" HeaderText="Last_Name"

 

 

SortExpression="Last_Name" />

 

 

<asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />

 

 

<asp:BoundField DataField="Password" HeaderText="Password"

 

 

SortExpression="Password" />

 

 

<asp:BoundField DataField="Role" HeaderText="Role" SortExpression="Role" />

 

 

<asp:CheckBoxField DataField="Active" HeaderText="Active"

 

 

SortExpression="Active" />

 

 

</Columns>

 

 

</asp:GridView>

 

 

<asp:SqlDataSource ID="SqlDataSource2" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:5ConnectionString1 %>"

 

 

DeleteCommand="DELETE FROM [s_ServiceServers] WHERE [ServerID] = @ServerID"

 

 

InsertCommand="INSERT INTO [s_ServiceServers] ([UserID], [UserName], [First_Name], [MI], [Last_Name], [email], [Password], [Role], [Active]) VALUES (@UserID, @UserName, @First_Name, @MI, @Last_Name, @email, @Password, @Role, @Active)"

 

 

ProviderName="<%$ ConnectionStrings:5ConnectionString1.ProviderName %>"

 

 

SelectCommand="SELECT [ServerID], [UserID], [UserName], [First_Name], [MI], [Last_Name], [email], [Password], [Role], [Active] FROM [s_ServiceServers]"

 

 

UpdateCommand="UPDATE [s_ServiceServers] SET [UserID] = @UserID, [UserName] = @UserName, [First_Name] = @First_Name, [MI] = @MI, [Last_Name] = @Last_Name, [email] = @email, [Password] = @Password, [Role] = @Role, [Active] = @Active WHERE [ServerID] = @ServerID">

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="ServerID" Type="Int32" />

 

 

</DeleteParameters>

 

 

<InsertParameters>

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="UserName" Type="String" />

 

 

<asp:Parameter Name="First_Name" Type="String" />

 

 

<asp:Parameter Name="MI" Type="String" />

 

 

<asp:Parameter Name="Last_Name" Type="String" />

 

 

<asp:Parameter Name="email" Type="String" />

 

 

<asp:Parameter Name="Password" Type="String" />

 

 

<asp:Parameter Name="Role" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

</InsertParameters>

 

 

<UpdateParameters>

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="UserName" Type="String" />

 

 

<asp:Parameter Name="First_Name" Type="String" />

 

 

<asp:Parameter Name="MI" Type="String" />

 

 

<asp:Parameter Name="Last_Name" Type="String" />

 

 

<asp:Parameter Name="email" Type="String" />

 

 

<asp:Parameter Name="Password" Type="String" />

 

 

<asp:Parameter Name="Role" Type="String" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

<asp:Parameter Name="ServerID" Type="Int32" />

 

 

</UpdateParameters>

 

 

</asp:SqlDataSource>

 

 

<br />

 

 

<asp:SqlDataSource ID="SqlDataSource3" runat="server"

 

 

ConnectionString="<%$ ConnectionStrings:5ConnectionString1 %>"

 

 

DeleteCommand="DELETE FROM [s_ServiceAvailability] WHERE [AvailabilityID] = @AvailabilityID"

 

 

InsertCommand="INSERT INTO [s_ServiceAvailability] ([ServiceID], [UserID], [Category], [Description], [Availability], [Recurrence], [Day], [During], [From1], [To1], [Starting], [Ending], [Active]) VALUES (@ServiceID, @UserID, @Category, @Description, @Availability, @Recurrence, @Day, @During, @From1, @To1, @Starting, @Ending, @Active)"

 

 

ProviderName="<%$ ConnectionStrings:5ConnectionString1.ProviderName %>"

 

 

SelectCommand="SELECT [AvailabilityID], [ServiceID], [UserID], [Category], [Description], [Availability], [Recurrence], [Day], [During], [From1], [To1], [Starting], [Ending], [Active] FROM [s_ServiceAvailability] WHERE ([ServiceID] = @ServiceID)"

 

 

UpdateCommand="UPDATE [s_ServiceAvailability] SET [ServiceID] = @ServiceID, [UserID] = @UserID, [Category] = @Category, [Description] = @Description, [Availability] = @Availability, [Recurrence] = @Recurrence, [Day] = @Day, [During] = @During, [From1] = @From1, [To1] = @To1, [Starting] = @Starting, [Ending] = @Ending, [Active] = @Active WHERE [AvailabilityID] = @AvailabilityID">

 

 

<SelectParameters>

 

 

<asp:ControlParameter ControlID="RadGrid1" Name="ServiceID"

 

 

PropertyName="SelectedValue" Type="Int32" />

 

 

</SelectParameters>

 

 

<DeleteParameters>

 

 

<asp:Parameter Name="AvailabilityID" Type="Int32" />

 

 

</DeleteParameters>

 

 

<InsertParameters>

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="Category" Type="String" />

 

 

<asp:Parameter Name="Description" Type="String" />

 

 

<asp:Parameter Name="Availability" Type="Boolean" />

 

 

<asp:Parameter Name="Recurrence" Type="String" />

 

 

<asp:Parameter Name="Day" Type="String" />

 

 

<asp:Parameter Name="During" Type="String" />

 

 

<asp:Parameter DbType="Time" Name="From1" />

 

 

<asp:Parameter DbType="Time" Name="To1" />

 

 

<asp:Parameter Name="Starting" Type="DateTime" />

 

 

<asp:Parameter Name="Ending" Type="DateTime" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

</InsertParameters>

 

 

<UpdateParameters>

 

 

<asp:Parameter Name="ServiceID" Type="Int32" />

 

 

<asp:Parameter Name="UserID" Type="Int32" />

 

 

<asp:Parameter Name="Category" Type="String" />

 

 

<asp:Parameter Name="Description" Type="String" />

 

 

<asp:Parameter Name="Availability" Type="Boolean" />

 

 

<asp:Parameter Name="Recurrence" Type="String" />

 

 

<asp:Parameter Name="Day" Type="String" />

 

 

<asp:Parameter Name="During" Type="String" />

 

 

<asp:Parameter DbType="Time" Name="From1" />

 

 

<asp:Parameter DbType="Time" Name="To1" />

 

 

<asp:Parameter Name="Starting" Type="DateTime" />

 

 

<asp:Parameter Name="Ending" Type="DateTime" />

 

 

<asp:Parameter Name="Active" Type="Boolean" />

 

 

<asp:Parameter Name="AvailabilityID" Type="Int32" />

 

 

</UpdateParameters>

 

 

</asp:SqlDataSource>

 

 

<telerik:RadGrid ID="RadGrid2" runat="server" CellSpacing="0"

 

 

DataSourceID="SqlDataSource3" GridLines="None">

 

<

 

HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

 

<

 

MasterTableView AutoGenerateColumns="False" DataKeyNames="AvailabilityID"

 

 

DataSourceID="SqlDataSource3">

 

<

 

CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

 

<

 

RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

 

<

 

HeaderStyle Width="20px"></HeaderStyle>

 

</

 

RowIndicatorColumn>

 

<

 

ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

 

<

 

HeaderStyle Width="20px"></HeaderStyle>

 

</

 

ExpandCollapseColumn>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="AvailabilityID" DataType="System.Int32"

 

 

FilterControlAltText="Filter AvailabilityID column" HeaderText="AvailabilityID"

 

 

ReadOnly="True" SortExpression="AvailabilityID" UniqueName="AvailabilityID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="ServiceID" DataType="System.Int32"

 

 

FilterControlAltText="Filter ServiceID column" HeaderText="ServiceID"

 

 

SortExpression="ServiceID" UniqueName="ServiceID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="UserID" DataType="System.Int32"

 

 

FilterControlAltText="Filter UserID column" HeaderText="UserID"

 

 

SortExpression="UserID" UniqueName="UserID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Category"

 

 

FilterControlAltText="Filter Category column" HeaderText="Category"

 

 

SortExpression="Category" UniqueName="Category">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Description"

 

 

FilterControlAltText="Filter Description column" HeaderText="Description"

 

 

SortExpression="Description" UniqueName="Description">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="Availability" DataType="System.Boolean"

 

 

FilterControlAltText="Filter Availability column" HeaderText="Availability"

 

 

SortExpression="Availability" UniqueName="Availability">

 

 

</telerik:GridCheckBoxColumn>

 

 

<telerik:GridBoundColumn DataField="Recurrence"

 

 

FilterControlAltText="Filter Recurrence column" HeaderText="Recurrence"

 

 

SortExpression="Recurrence" UniqueName="Recurrence">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Day"

 

 

FilterControlAltText="Filter Day column" HeaderText="Day" SortExpression="Day"

 

 

UniqueName="Day">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="During"

 

 

FilterControlAltText="Filter During column" HeaderText="During"

 

 

SortExpression="During" UniqueName="During">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="From1" DataType="System.TimeSpan"

 

 

FilterControlAltText="Filter From1 column" HeaderText="From1"

 

 

SortExpression="From1" UniqueName="From1">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="To1" DataType="System.TimeSpan"

 

 

FilterControlAltText="Filter To1 column" HeaderText="To1" SortExpression="To1"

 

 

UniqueName="To1">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Starting" DataType="System.DateTime"

 

 

FilterControlAltText="Filter Starting column" HeaderText="Starting"

 

 

SortExpression="Starting" UniqueName="Starting">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Ending" DataType="System.DateTime"

 

 

FilterControlAltText="Filter Ending column" HeaderText="Ending"

 

 

SortExpression="Ending" UniqueName="Ending">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridCheckBoxColumn DataField="Active" DataType="System.Boolean"

 

 

FilterControlAltText="Filter Active column" HeaderText="Active"

 

 

SortExpression="Active" UniqueName="Active">

 

 

</telerik:GridCheckBoxColumn>

 

 

</Columns>

 

<

 

EditFormSettings>

 

<

 

EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

 

</

 

EditFormSettings>

 

</

 

MasterTableView>

 

<

 

FilterMenu EnableImageSprites="False"></FilterMenu>

 

 

</telerik:RadGrid>

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

<br />

 

 

 

</div>

 

 

<telerik:RadTabStrip ID="RadTabStrip1" runat="server" Height="22px"

 

 

MultiPageID="RadMultiPage1" SelectedIndex="0" Width="980px">

 

 

<Tabs>

 

 

<telerik:RadTab runat="server" PageViewID="RadPageView1" Text="General Options"

 

 

BackColor="#FFC0C0" Selected="True">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" PageViewID="RadPageView2"

 

 

Text="Scheduling Option">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Servers">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Availability">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Cancelations">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Steps">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Fees">

 

 

</telerik:RadTab>

 

 

<telerik:RadTab runat="server" Text="Services">

 

 

</telerik:RadTab>

 

 

</Tabs>

 

 

</telerik:RadTabStrip>

 

 

<telerik:RadMultiPage ID="RadMultiPage1" Runat="server" BorderStyle="Solid"

 

 

BorderWidth="1px" SelectedIndex="0" Width="980px">

 

 

<telerik:RadPageView ID="RadPageView1" runat="server" Height="269px"

 

 

Width="980px" BackColor="#D4D5C4">

 

 

<br />

 

 

<table align="left" cellpadding="5">

 

 

<tr>

 

 

<td style="text-align: right">

 

 

<asp:Label ID="Label12" runat="server"

 

 

Text="Generally this type of service is called"></asp:Label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox9" runat="server" Width="380px">Appointment</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

<tr>

 

 

<td style="text-align: right">

 

 

<asp:Label ID="Label13" runat="server"

 

 

Text="The receiver of the service is called">

 

 

</asp:label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox10" runat="server" Width="380px">Patient</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

<tr>

 

 

<td>

 

 

<asp:Label ID="Label14" runat="server"

 

 

Text="The person rendering the service is called"></asp:Label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox11" runat="server" Width="380px">Doctor</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

<tr>

 

 

<td style="text-align: right">

 

 

<asp:Label ID="Label15" runat="server" Text="The request process is called"></asp:Label>

 

 

</td>

 

 

<td>

 

 

<asp:TextBox ID="TextBox12" runat="server" Width="380px">Booking</asp:TextBox>

 

 

</td>

 

 

</tr>

 

 

</table>

 

 

</telerik:RadPageView>

 

 

<telerik:RadPageView ID="RadPageView2" runat="server" Height="296px"

 

 

Width="980px" BackColor="#D4D5C4">

 

 

<br />

 

 

<br />

 

 

<br />

 

 

</telerik:RadPageView>

 

 

<telerik:RadPageView ID="RadPageView3" runat="server" Height="272px"

 

 

Width="416px">

 

 

</telerik:RadPageView>

 

 

</telerik:RadMultiPage>

 

 

</form>

 

</

 

body>

 

</

 

html>

 

l

I have a hierarchical grid that has many top level rows, each top level row can be expanded to display 1-many child level rows. My question is the "Client edit with batch server Update" supported at the detail level (child level). Also the demo for "Client edit with batch server Update" requires a double click in the cell to edit. Can all the rows in a particular column be set to edit when the child rows are displayed.

The Attached image is a sample of what I'm doing and I would like to edit the values in the second column (Value1-n) in batch on the client.

Is there a sample available that would demonstrate this functionality.

Thanks

Marc 

I have a scheduler hooked up to a SQL datasource, it shows the appointments fine but when I try and create or edit an appointment the dropdown pickers for the Start Date / Time do not appear, instead I have to use the arrow keys to scroll up and down to set them.

Do I have to set this functionality somewhere?

I am going through the Apress book and examples but I can't see anything about it.




 

Hi All,

  I have two listboxes. I can transfer the items from left listbox to right side listbox. I just don't want the items that are moved from left listbox to right listbox to be removed from the left listbox.

I mean all the items that I am originally displaying in the left listbox should keep displaying even if i transfer the items from left listbox to right listbox.


Is it possible to accomplish this.

Any help will be appreciated.

hi, hello i have 10 items and each one 1 RadPanel. 

When I raise the click event on the server side and onIntemClick a grid is bind inside it. everything works fine.

When I have many panels bar open the page becomes very long. When I click to expand the Panel Bar, the Page  move for a moment at the beginning and then it is repositioned on the panel giving a curious effect "Table Tennis". The URL appears a strange # as Mypage.aspx #. This does not occur WITHOUT the RadAjaxPAnel as with the Full post back you can not see the effect of expansion.

this does not happen if the size of the panel bars does not exceed the length of the page.  How can we remove this "swap" of the page?

Hi,
I want to know if there is a way to see all threads posted by myself. Thanks.

Hi, 

I am currently using Combobox to select records to edit in the FormView. 

I want to know if there are any way for me to create next/previous button and possibly first/last button

I tried different methods such as selectedvalue, selectedindex, selectitem, but it's not working


Any help would be greatly appreciated. 

Hello,

  I have a grid in my Page. In the first column i set an image using Item Template . i want to display a tooltip for this Image . The Tooltip should be in 200x200 size. I set the ImageID as TargetControl ID of this ToolTIp.. It didnt work. The ToolTip is not displayed.

I am using radScheduler in a typical web form page with server side binding to a generic list. I use timeline view only.
In client side's "OnClientAppointmentResizeEnd" javascript event I need to change the subject of the appointment to the new duration. It will help the user to clearly see the change she did.
I am using the following code.
The above works well with web service binding and the user can see the subject of the appoinment changes to the new duration as she resizes the appointment. But this does not work (appointment subject change is not visible) with server side binding.
Any ideas apart from using AppointmentUpdate server side event?
Thanks and regards
Kushil