Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
77 views
Please consider this request for a new feature to be added to the RadComboBox. We would like to see a property called "Mode" added. It would have two options; Normal and Label. The default value would be Normal as to not break previous implementations.

Use Case:

When using a RadComboBox on a FormView with view/edit/insert/delete functions, there is no easy way to show the selected item text of the RadComboBox in a Label look & feel without complex JavaScript/CSS or adding code. It would be awesome if we could just set a property called Mode="Label" which caused the RadComboBox to display a Label instead of the combobox. It would use the same css as the rest of the labels on the page. When in Label mode, the control presented to the user would not allow the user to change any values, nor see any look & feel of a combobox. The user would see it as a standard label. 

Currently, we have to put both a label and a combobox in our item template of the FormView. Then set combobox visible=false, and add a SelectionChanged event to the combobox (we use binding) which sets the text value of the label. Lot's of work and extra code just so we can show the user the value of the combobox in Label format! We tried the JavaScript/CSS method, but had other issues and was not sure it would interfere with our other CSS changes in the future. 

Thank you for the consideration.
Kalina
Telerik team
 answered on 28 Jun 2011
1 answer
138 views
Hi,

in an scenario with a master page with the Radajaxmanager control and a content page with a grid i never get the Ajaxrequestdelegate event reach, in this case RadAjaxManager1_AjaxRequest, thanks a lot

the code behind of the content page:

       protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                RadAjaxManager AjaxManager = (RadAjaxManager)this.Master.FindControl("RadAjaxManager1");
                //                RadAjaxManager AjaxManager = RadAjaxManager.GetCurrent(Page);
                AjaxManager.AjaxSettings.AddAjaxSetting(AjaxManager, RadGridClientes);
                AjaxManager.AjaxSettings.AddAjaxSetting(RadGridClientes, RadGridClientes);
                AjaxManager.AjaxRequest += new RadAjaxControl.AjaxRequestDelegate(RadAjaxManager1_AjaxRequest);
            }

        }

        protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
        {
            if (e.Argument == "Rebind")
            {
                RadGridClientes.MasterTableView.SortExpressions.Clear();
                RadGridClientes.MasterTableView.GroupByExpressions.Clear();
                RadGridClientes.Rebind();
            }
            else if (e.Argument == "RebindAndNavigate")
            {
                RadGridClientes.MasterTableView.SortExpressions.Clear();
                RadGridClientes.MasterTableView.GroupByExpressions.Clear();
                RadGridClientes.MasterTableView.CurrentPageIndex = RadGridClientes.MasterTableView.PageCount - 1;
                RadGridClientes.Rebind();
            }
        }

in the content page aspx file:


<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">



    <telerik:RadGrid ID="RadGridClientes" runat="server">
    </telerik:RadGrid>

                <telerik:RadButton Text="Cancelar" runat="server" ID="Cancelar" OnClientClicked="refreshGrid">
                </telerik:RadButton>

   <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
    <script type="text/javascript">
        function refreshGrid(arg) {
            if (!arg) {
                $find("<%= RadAjaxManager.GetCurrent(this.Page).ClientID %>").ajaxRequest("Rebind");
            }
            else {
                $find("<%= RadAjaxManager.GetCurrent(this.Page).ClientID %>").ajaxRequest("RebindAndNavigate");
            }
        }
    
    </script>
    </telerik:RadCodeBlock>
</asp:Content>
Genti
Telerik team
 answered on 28 Jun 2011
1 answer
162 views
I have looked at every example I could find on client-side binding the RadGrid with virtual scrolling and I cannot make it work.
I am using the following Javascript code for binding.
var grid = $find("radgrid1");
                    var mtv = grid.get_masterTableView();
                    mtv.set_dataSource(DATA); //data is coming from a JSON object
                    mtv.dataBind();

What usually happens, is that all of the data in my dataObject is loading and since there are a large number of records the browser freezes. I've tried to use the DataBinding events for the client-side and server side, but they never seem to fire.
I can't use a webservice for this issue.

Thanks.
Shinu
Top achievements
Rank 2
 answered on 28 Jun 2011
1 answer
331 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
247 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
610 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
640 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
72 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
152 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
98 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
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?