Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
320 views
Greetings,

I am working on a project in VS 2010 and decided to install the latest Telerik update. (Telerik.Web.UI_2011_1_519_Dev.zip).  After the install my Telerik toolbox is missing.

Any help is appreciated.
Biliana Ficheva
Telerik team
 answered on 28 Jun 2011
1 answer
229 views
Hi There,

I'm using a RadAsyncUpload Control to upload documents into one of my systems.

The problem is occurring after the User selects a File to be uploaded. Normally, the user selects the file, and eventually the Dot beside the file name becomes green and the file can now be committed to the upload. In some of these cases, the user is prompted to enter a Username/Password after selecting files. After entering their login information, the Prompt disappears then reappears. This continues to happen and in some cases the Dot beside the file name turns Red.

My application is using Windows Authentication, but the prompt would not accept the users' logins. I'm going to go ahead and assume that that isn't the login it is looking for.

Is there a way to disable this on the RadAsyncUpload? Some users have no problems, but some are blocked from adding files.

Best Regards,

Landon
Shinu
Top achievements
Rank 2
 answered on 28 Jun 2011
1 answer
587 views
Dear All,

Please help ...
I have a GridTemplateColumn with Checkbox as below
<telerik:GridTemplateColumn UniqueName="Exist" DataField="Exist" HeaderText="Exist">
                <HeaderStyle Width="37px"/>
                <ItemTemplate>
             <asp:CheckBox id="CheckBox1" checked='<%# IF(Eval("Exist") is DBNull.Value, False, Eval("Exist")) %>' OnCheckedChanged="ToggleRowSelection" AutoPostBack="true" runat="server"></asp:CheckBox>
                </ItemTemplate>
</telerik:GridTemplateColumn>
I have added the following code in grid_ItemDataBound event, because of I want to prompt confirm when user click to Checked/UnChecked
chk.Attributes.Add("onclick", "return confirm('Are you sure?')")

Now this only do OnClick, but not fire OnCheckedChanged event.
Any idea to do both when checkedchanged, Please ?

Thanks and best regards
Naunton
Top achievements
Rank 1
 answered on 28 Jun 2011
2 answers
622 views
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
John
Top achievements
Rank 1
 answered on 27 Jun 2011
1 answer
71 views
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
Marin
Telerik team
 answered on 27 Jun 2011
1 answer
150 views
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 
Marin
Telerik team
 answered on 27 Jun 2011
9 answers
90 views
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.

<telerik:RadScriptManager ID="RadScriptManager" runat="server"></telerik:RadScriptManager>
<div>
 
    <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Height="200px" Width="300px">
 
        <telerik:RadScheduler ID="RadScheduler1" runat="server"
            DataDescriptionField="Description" DataEndField="EndTime"
            DataKeyField="EventsID" DataSourceID="SqlDataSource1"
            DataStartField="StartTime" DataSubjectField="Subject">
        </telerik:RadScheduler>
 
    </telerik:RadAjaxPanel>
 
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:PenDataConnectionString %>"
        SelectCommand="SELECT * FROM [Events]"></asp:SqlDataSource>
 
</div>



 
Plamen
Telerik team
 answered on 27 Jun 2011
2 answers
87 views
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.
Anjali
Top achievements
Rank 1
 answered on 27 Jun 2011
3 answers
308 views
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?

Dimitar Terziev
Telerik team
 answered on 27 Jun 2011
1 answer
69 views
Hi,
I want to know if there is a way to see all threads posted by myself. Thanks.
Atanas
Telerik team
 answered on 27 Jun 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?