Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
230 views
how to Hide the Row Field Column,

In Rad grid we use Display=false ,is there any function for hiding the Pivot grid Row Field Column.

In my project i want to display the row fields in some order for that i use a Row Number column  but this rownumer column of Row field shold be hidden.
Shinu
Top achievements
Rank 2
 answered on 05 Nov 2013
1 answer
92 views
Hi, 

I think I found a bug with my q2 2013 controls, where if I programmatically remove some items from the list by setting its property to visible = false, the navigation breaks also. It navigates to the index of the items it thinks should be there. 

<telerik:RadTileList ID="tllReporting" runat="server" Skin="FriskaMetro" EnableEmbeddedSkins="False"
        Height="500px">
        <Groups>
            <%--Sales--%>
            <telerik:TileGroup>
                <Tiles>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/CombinedSales.aspx" Shape="Square" Name="tileSalesCombined">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Combined Sales</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the combined retail and catering sales for period
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/ProductsSoldReport.aspx" Shape="Square" Name="tileSalesProductsSold">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Product <br />Sales</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the total number of products sold in a period
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/SalesPOReceiptsReport.aspx" Shape="Wide" Name="tileSalesPOReceipts">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Paid Out Receipts</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the paid out cash receipts per store
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/SalesSummaryReport.aspx" Shape="Square"
                        Name="tileSalesSalesSummary">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Sales Summary</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the value of the sales in a period per store
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
   </Tiles>
            </telerik:TileGroup>
        </Groups>
    </telerik:RadTileList>

Thenn I set the visible property as such: 

foreach (RadBaseTile tile in tllReporting.GetAllTiles())
            {
                tile.Visible = Authentication.HasUserPageAccess("~/Reporting/"+tile.NavigateUrl);
            }
Is this a bug?

Many thanks!
Gabor
Stanimir
Telerik team
 answered on 05 Nov 2013
1 answer
62 views
ComboBox - Grid Filtered by Combo with Checkboxes
===============================================================

Does anyone know how to modify the demo below to enable checkboxes [CheckBoxes="true" EnableCheckAllItemsCheckBox="true"]
and be able to filter the RadGrid for the multiple selected/checked items in the RadComboBox? In the demo below, it only filters the grid for the ONE selected item.

Demo - ComboBox - Grid Filtered by Combo:
http://demos.telerik.com/aspnet-ajax/controls/examples/integration/gridcomboajax/defaultcs.aspx?product=combobox

Shinu
Top achievements
Rank 2
 answered on 05 Nov 2013
4 answers
200 views
Hello all

I have the following RadGrid, where i have an EditForm template for editing and inserting, well, the Update command is working fine, however, when using SelectedValue in the DropDownList the insert form will not show when i click add new record, and when i remove the SelectedValue property, the insert form shows but wont work when i insert data, i double checked my sql statement for inserting and it works fine.

Any suggestions?

    <telerik:RadGrid ID="GridStaff"  runat="server" ShowStatusBar="True" 
        OnItemCommand="GridStaff_ItemCommand" OnItemUpdated="GridStaff_ItemUpdated"
        OnItemCreated="GridStaff_ItemCreated"
        OnUpdateCommand="GridStaff_UpdateCommand" OnItemInserted="GridStaff_ItemInserted"
        OnInsertCommand="GridStaff_InsertCommand" OnPreRender="GridStaff_PreRender"
    AutoGenerateColumns="False" PageSize="20" AllowSorting="True" AllowAutomaticInserts="True"
    AllowPaging="True" DataSourceID="SqlDataSourceStaff" AllowAutomaticDeletes="true"
        OnItemDataBound="GridStaff_ItemDataBound"
    AllowAutomaticUpdates="True" Width="835px" FilterType="CheckedList" AllowFilteringByColumn="True"
                GridLines="None" CellSpacing="0">
                <ExportSettings>
                    <Pdf>
                        <PageHeader>
                            <LeftCell Text="" />
                            <MiddleCell Text="" />
                            <RightCell Text="" />
                        </PageHeader>
                        <PageFooter>
                            <LeftCell Text="" />
                            <MiddleCell Text="" />
                            <RightCell Text="" />
                        </PageFooter>
                    </Pdf>
                </ExportSettings>
                 
                <MasterTableView DataSourceID="SqlDataSourceStaff" InsertItemDisplay="Top" InsertItemPageIndexAction="ShowItemOnFirstPage" DataKeyNames="UserID" EditMode="EditForms" AutoGenerateColumns="false" AllowMultiColumnSorting="False" Width="100%" CommandItemDisplay="Top" Name="admStaff">
                <CommandItemSettings ShowAddNewRecordButton="true" AddNewRecordText="Add New Staff Member" ShowExportToPdfButton="true" />
                    <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"
                        Visible="True">
                    </RowIndicatorColumn>
                    <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"
                        Visible="True">
                    </ExpandCollapseColumn>
                <Columns>
                <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">
                <HeaderStyle Width="20px">
                </HeaderStyle>
                </telerik:GridEditCommandColumn>
                <telerik:GridBoundColumn SortExpression="UserID" ShowFilterIcon="false" AllowFiltering="false" HeaderText="#" HeaderButtonType="TextButton" DataField="UserID" UniqueName="UserID" MaxLength="7">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn SortExpression="EnglishName" HeaderText="Name" HeaderButtonType="TextButton" DataField="EnglishName" UniqueName="EnglishName" MaxLength="40">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn SortExpression="Subject" HeaderText="Subject" HeaderButtonType="TextButton" DataField="SubEn" UniqueName="Subject">
                </telerik:GridBoundColumn>
                 
                <telerik:GridBoundColumn SortExpression="DepEn" HeaderText="Department" HeaderButtonType="TextButton" DataField="DepartID" UniqueName="DepEn">
                </telerik:GridBoundColumn>
                 
                <telerik:GridTemplateColumn HeaderText="Load/Week" UniqueName="TLoad" AllowFiltering="false" >
                <ItemStyle Width="20px" />
                    <ItemTemplate>
                        <asp:Label ID="lblTeacherLoad" runat="server"></asp:Label>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                 
                <telerik:GridBoundColumn SortExpression="PhoneNumber" HeaderText="PhoneNumber" HeaderButtonType="TextButton" AllowFiltering="false" DataField="PhoneNumber" UniqueName="PhoneNumber">
                </telerik:GridBoundColumn>
                 
                <telerik:GridTemplateColumn HeaderText="MSG" UniqueName="SendMSG" AllowFiltering="false" >
                <ItemStyle Width="20px" />
                    <ItemTemplate>
                        <asp:ImageButton ID="img_SendMSG" runat="server" CommandName="SendMsgToStaff" ImageUrl="~/images/sendmsgicon.png" CommandArgument='<%# Bind("UserID") %>' Width="20px" Height="20px" />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridTemplateColumn HeaderText="SMS" UniqueName="SendSMS" AllowFiltering="false" >
                <ItemStyle Width="20px" />
                    <ItemTemplate>
                        <asp:ImageButton ID="img_SendSMS" runat="server" CommandName="SendSmsToStaff" ImageUrl="~/images/sendsmsicon.png" CommandArgument='<%# Bind("UserID") %>' Width="20px" Height="20px" />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                </Columns>
                 
                <EditFormSettings EditFormType="Template" PopUpSettings-Modal="true">
                         
                         
                        <FormTemplate>
                        <div class="register">
                         
                            
                        
                           <div class="divClass">
         
         
        <fieldset class="rowPersonalEn">
            <legend>Personal Details
            </legend>
            <p>
                <label>User ID
                </label>
                 
                <asp:TextBox ID="txtUserID" CssClass="long" Text='<%# Bind("UserID") %>' Enabled="false" runat="server"></asp:TextBox>
            </p>
            <p>
                <label>First Name
                </label>
                 
                <asp:TextBox ID="txtFirstNameEn" CssClass="long" Text='<%# Bind("FirstNameEn") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Second Name
                </label>
                 
                <asp:TextBox ID="txtSecondNameEn" CssClass="long" Text='<%# Bind("SecondNameEn") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Family Name
                </label>
                 
                <asp:TextBox ID="txtFamilyNameEn" CssClass="long" Text='<%# Bind("FamilyNameEn") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Date of Birth
                </label>
                 
                <asp:TextBox ID="txtDOB" CssClass="long" Text='<%# Bind("DOB") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Nationality
                </label>
                 
                <asp:DropDownList ID="ddlNationality" runat="server">
                </asp:DropDownList>
            </p>
            <p>
                <label>ID No.
                </label>
                 
                <asp:TextBox ID="txtIDNo" CssClass="long" Text='<%# Bind("IDNo") %>' runat="server"></asp:TextBox>
                 
            </p>
            <p>
                <label>Mobile
                </label>
                 
                <asp:TextBox ID="txtMobile" CssClass="long" Text='<%# Bind("PhoneNumber") %>' runat="server"></asp:TextBox>
                 
            </p>
            <p>
                <label>Email
                </label>
                 
                <asp:TextBox ID="txtEmail" CssClass="long" Text='<%# Bind("Email") %>' runat="server"></asp:TextBox>
                 
            </p>
            <p>
                <label>Notes
                </label>
                 
                <asp:TextBox ID="txtNotes" TextMode="MultiLine" Text='<%# Bind("Notes") %>' CssClass="multi" runat="server"></asp:TextBox>
                 
            </p>
        </fieldset>
        <fieldset class="rowPersonalAr">
            <legend>المعلومات الشخصية</legend>
            <p style="text-align:left">
                 
                <asp:TextBox ID="txtFirstNameAr" CssClass="long" Text='<%# Bind("FirstNameAr") %>' runat="server"></asp:TextBox>
                <label>الاسم الأول
                </label>
            </p>
           <p>
                 
                <asp:TextBox ID="txtSecondNameAr" CssClass="long" Text='<%# Bind("SecondNameAr") %>' runat="server"></asp:TextBox>
                <label>الاسم الثاني
                </label>
            </p>
            <p>
                 
                <asp:TextBox ID="txtFamilyNameAr" CssClass="long" Text='<%# Bind("FamilyNameAr") %>' runat="server"></asp:TextBox>
                <label>العائلة
                </label>
            </p>
        </fieldset>
         
        <fieldset class="rowAcademical">
            <legend>Academical Information
            </legend>
            <p>
                <label>Degree</label>
                <asp:DropDownList ID="ddlAcademicDegree" runat="server" DataSourceID="DataSourceAD" DataTextField="ADEn" DataValueField="ADID" AppendDataBoundItems="true" >
                    <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                <label>Experience
                </label>
                 
                <asp:TextBox ID="txtExp" CssClass="long" Text='<%# Bind("YearsOfExp") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>College/Uni.
                </label>
                 
                <asp:TextBox ID="txtUniv" CssClass="long" Text='<%# Bind("CollegeName") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                 <label>Department</label>
                <asp:DropDownList ID="ddlDept" runat="server" DataSourceID="DataSourceDepartments"  DataTextField="DepartmentEn" DataValueField="DepartmentID" AppendDataBoundItems="true" >
                                       
                                            <asp:ListItem Selected="True" Text="Select" Value="0" >
                                            </asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                 <label>Stage</label>
                <asp:DropDownList ID="ddlStage" runat="server" DataSourceID="DataSourceStages" DataTextField="StageEn" DataValueField="StageID"  AppendDataBoundItems="true">
                      <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                 <label>Subject</label>
                <asp:DropDownList ID="ddlSubject" runat="server" DataSourceID="DataSourceSubjects"  DataTextField="SubEn" DataValueField="SubID" AppendDataBoundItems="true">
                    <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                 <label>Hired Date</label>
                <asp:TextBox ID="txtHireDate" CssClass="long" Text='<%# Bind("HiredDate") %>' runat="server"></asp:TextBox>
            </p>
        </fieldset>
        <div>
         <asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
                                runat="server" CommandName="Update">
                            </asp:Button
                                 <asp:Button ID="btnCancel" Text="Close" runat="server" CausesValidation="False"
                                CommandName="Cancel"></asp:Button>
        </div>
 
        </div>
         
         </div>
                        </FormTemplate>
                    </EditFormSettings>
                    <BatchEditingSettings EditType="Cell" />
                    <PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox" />
                </MasterTableView>
                <PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox" />
                <FilterMenu EnableImageSprites="False">
                </FilterMenu>
                </telerik:RadGrid>
 
<asp:SqlDataSource ID="SqlDataSourceStaff" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT usr.*, usr.FirstNameEn+' '+usr.FamilyNameEn AS EnglishName, dept.DepEn AS DepartID,dept.DepID AS DeparID,sub.SubEn,sub.SubID, ad.ADEn,st.StageEn FROM AttUsers usr,AttStages st, AttAcademicalDegrees ad, AttDepartments dept, AttSubjects sub WHERE st.StageID=usr.Stage AND ad.ADID=usr.AcademicalDegree AND sub.SubID=usr.Subject AND usr.Department=dept.DepID"
      UpdateCommand="UPDATE AttUsers SET [FirstNameEn]=@FirstNameEn, [FirstNameAr]=@FirstNameAr, [SecondNameEn]=@SecondNameEn,[SecondNameAr]=@SecondNameAr,[FamilyNameEn]=@FamilyNameEn,[FamilyNameAr]=@FamilyNameAr,[DOB]=@DOB,[IDNo]=IDNo,[PhoneNumber]=@PhoneNumber,[Email]=@Email,[Notes]=@Notes,[YearsOfExp]=@YearsOfExp,[CollegeName]=@CollegeName,[Department]=@DeparID,[Subject]=@Subject,[AcademicalDegree]=@AcademicalDegree,[Stage]=@Stage,[HiredDate]=@HiredDate WHERE UserID=@UserID"
      InsertCommand="INSERT INTO AttUsers (FirstNameAr,SecondNameAr,FamilyNameAr,FirstNameEn,SecondNameEn,FamilyNameEn,DOB,IDNo,PhoneNumber,Email,Notes,YearsOfExp,CollegeName,Department,Subject,AcademicalDegree,Stage,HiredDate) VALUES (@FirstNameAr,@SecondNameAr,@FamilyNameAr,@FirstNameEn,@SecondNameEn,@FamilyNameEn,@DOB,@IDNo,@PhoneNumber,@Email,@Notes,@YearsOfExp,@CollegeName,@DeparID,@Subject,@AcademicalDegree,@Stage,@HiredDate)">
        <UpdateParameters>
            <asp:Parameter Name="UserID" Type="String"></asp:Parameter>
            <asp:Parameter Name="FirstNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FirstNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="DOB" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="IDNo" Type="String"></asp:Parameter>
            <asp:Parameter Name="PhoneNumber" Type="String"></asp:Parameter>
            <asp:Parameter Name="Email" Type="String"></asp:Parameter>
            <asp:Parameter Name="Notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="YearsOfExp" Type="String"></asp:Parameter>
            <asp:Parameter Name="CollegeName" Type="String"></asp:Parameter>
            <asp:Parameter Name="DeparID" Type="String"></asp:Parameter>
            <asp:Parameter Name="Subject" Type="String"></asp:Parameter>
             
            <asp:Parameter Name="AcademicalDegree" Type="String"></asp:Parameter>
            <asp:Parameter Name="HiredDate" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="Stage" Type="String" />
        </UpdateParameters>
        <InsertParameters>
             
            <asp:Parameter Name="FirstNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FirstNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="DOB" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="IDNo" Type="String"></asp:Parameter>
            <asp:Parameter Name="PhoneNumber" Type="String"></asp:Parameter>
            <asp:Parameter Name="Email" Type="String"></asp:Parameter>
            <asp:Parameter Name="Notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="YearsOfExp" Type="String"></asp:Parameter>
            <asp:Parameter Name="CollegeName" Type="String"></asp:Parameter>
            <asp:Parameter Name="DeparID" Type="String"></asp:Parameter>
            <asp:Parameter Name="Subject" Type="String"></asp:Parameter>
            <asp:Parameter Name="Stage" Type="String"></asp:Parameter>
            <asp:Parameter Name="AcademicalDegree" Type="String"></asp:Parameter>
            <asp:Parameter Name="HiredDate" Type="DateTime"></asp:Parameter>
        </InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceDepartments" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT DepEn AS DepartmentEn, DepID AS DepartmentID FROM AttDepartments ORDER BY DepID ASC">
    
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceSubjects" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT SubEn, SubID FROM AttSubjects ORDER BY SubID ASC">
    
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceAD" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT ADID, ADEn FROM AttAcademicalDegrees ORDER BY ADID ASC">
    
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceStages" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT StageID, StageEn FROM AttStages ORDER BY StageID ASC">
    
</asp:SqlDataSource>
Princy
Top achievements
Rank 2
 answered on 05 Nov 2013
1 answer
94 views
Hi,

I want to create a radial gauge with gauge inside gauge. There is a big outer radial gauge and there are two small radial gauge and I want to place these two gauges horizontally inside the big radial gauge around its center. I was trying but cant get the desired placement of controls. Can someone offer help?

Thankyou
Katya
Shinu
Top achievements
Rank 2
 answered on 05 Nov 2013
1 answer
92 views
Hi,

How can I create a radial gauge with its scale displayed as a full circle? Please see the attached pic to get a clear understanding.

Thankyou
Katya
Shinu
Top achievements
Rank 2
 answered on 05 Nov 2013
9 answers
1.0K+ views
I have a Telerik Grid that has a checkbox in each column that will show whether or not each item in the Grid is active. The DropDownList has values from the database, and depending on which value is selected, the checkboxes will turn on or off.

Ex: I choose Category A from the DropDownList and the first record in the Grid will have a checked box to show that record is associated with Category A.

<telerik:RadDropDownList ID="MarketDropDownList" runat="server" DefaultMessage="--Select Market--" Width="200px" DataSourceID="ddlDataSource" DataTextField="MarketName" DataValueField="MarketID">
</telerik:RadDropDownList>
<asp:SqlDataSource ID="ddlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DBConnectingString %>" SelectCommand="Select DISTINCT MarketID, MarketName FROM vPanel_Market">
</asp:SqlDataSource>
 <telerik:RadGrid ID="radProductsGrid" runat="server" AllowPaging="true"
 AllowSorting="true" AutoGenerateColumns="false" GridLines="None"
 OnNeedDataSource="radProductsGrid_NeedDataSource"
 OnSortCommand="radProductsGrid_SortCommand" PageSize="100"
 ShowGroupPanel="false" Skin="Default">
<MasterTableView AllowCustomSorting="true" AllowMultiColumnSorting="false"
AllowNaturalSort="false" AllowSorting="true" AutoGenerateColumns="false"
Width="100%">
<Columns>
<telerik:GridTemplateColumn AllowFiltering="true" HeaderText="Product ID"
ReadOnly="true" UniqueName="productid">
<HeaderTemplate>
<asp:CheckBox ID="headerCheck" runat="server"
onClick="javascript:SelectDeselectAllCheckboxes(this);" />
</HeaderTemplate>
<ItemTemplate>
 <%--this checkbox will populate based off of selected value in dropdown --%>
<asp:CheckBox ID="ProductInMarket" runat="server" />
            <asp:HiddenField ID="ProductID" runat="server" Value="ProductID" />
</ItemTemplate>
<ItemStyle VerticalAlign="Middle" Width="60px" />
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn AllowFiltering="true" DataField="ItemNumber"
HeaderText="Item Number" ReadOnly="true" SortExpression="ItemNumber"
 UniqueName="ItemNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn AllowFiltering="true" DataField="ProductName"
HeaderText="Product Name" ReadOnly="true" SortExpression="ProductName"
UniqueName="ProductName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn AllowFiltering="true" DataField="CategoryName"
HeaderText="Category Name" ReadOnly="true" SortExpression="CategoryName"
UniqueName="CategoryName">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>


Princy
Top achievements
Rank 2
 answered on 05 Nov 2013
9 answers
388 views
Hi,
I am evaluating the Telerik RadScheduler .
All most all our requirements are available in this except TimeSlot Horizental.
I am facing some problems.

1.

Depending up on appointmetn start time and end time i have to change the colors.
Ex: Appointments End Time lessthan the current time i have to show those appoinments in blue color
Appoinments Start Time greater than the current time i have to show those appoinments in green color.

While page loading and

RadScheduler1_AppointmentDelete

  appointments are showing in the defined colors using

RadScheduler1_AppointmentDataBound

but when i am changing the start time and end time using drag and drop with in the scheduler

 

RadScheduler1_AppointmentUpdate is calling and the color is not changing depending upon the above example logic.
and when ever this event is calling RadScheduler1_AppointmentDataBound is not calling  


 

 

protected void RadScheduler1_AppointmentUpdate(object sender, AppointmentUpdateEventArgs e)

 

{

int

 

id = (int)e.ModifiedAppointment.ID;

 

 

string duration = e.ModifiedAppointment.Duration.ToString();

 

 

string starttime = e.ModifiedAppointment.Start.TimeOfDay.ToString();

 

 

string endtime = e.ModifiedAppointment.End.TimeOfDay.ToString();

 

 

string date = e.ModifiedAppointment.Start.ToShortDateString();

 

 

int resourceId = (int)e.ModifiedAppointment.Resources.GetResourceByType("Chair").Key;

 

ScheduleUpdate(id, starttime, endtime, duration, date, resourceId);

 

 

//Change the appointment colors which are already closed i.e appointmetn end time less than the current time.

 

 

 

 

 

 

if (Convert.ToDateTime(e.ModifiedAppointment.End) < Convert.ToDateTime(DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString()))

 

{

e.Appointment.BackColor = System.Drawing.

Color.Gray;

 

e.Appointment.ForeColor = System.Drawing.

Color.White;

 

}

 

//Change the appointment colors which are not started i.e appointmetn start time greater than the current time.

 

 

 

 

 

 

else if (Convert.ToDateTime(e.ModifiedAppointment.Start) > Convert.ToDateTime(DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString()))

 

{

e.Appointment.BackColor = System.Drawing.

Color.Yellow;

 

e.Appointment.ForeColor = System.Drawing.

Color.Blue;

 

}

 

else

 

 

 

 

 

{

e.Appointment.BackColor = System.Drawing.

Color.Green;

 

e.Appointment.ForeColor = System.Drawing.

Color.White;

 

}

 

RadScheduler1.Rebind();

 

 

RadGrid1.Columns[3].Visible = true;

 

RadToolTipManager2.TargetControls.Clear();

RadGrid1.Rebind();

RadGrid1.Columns[3].Visible =

false;

 

RadAjaxManager1.AjaxSettings.AddAjaxSetting(RadScheduler1, RadScheduler1);

 

 

RadAjaxManager1.AjaxSettings.AddAjaxSetting(RadScheduler1, RadToolTipManager1);

 

 

 

}


2.
How to restrict the users to resize the appoinments with out customizing. Is there any inbuilt property in scheduler control.
3.

 

 

ShowHoursColumn="False"

 

I set the property of the scheduler but its showing the vertical line . I want to remove that line. Is there any way to remove that line from GUI.

4.
In Hours Column time (08:00) is showing top of the TimeLabelSpan but i want to set to middle of the TimeLabelSpan.

5.
I added some contextMenuItems to the appointments and when ever i click on contextMenuItem its opening a new browser.
But i want to open the contextMenuItem windows as popups.
Is there any inbuilt feature to achieve this.

6.How to change the color of 2 timeslots (30 mints) after the each Appointment End Time to RED color.

7. In

 

RadScheduler1_AppointmentUpdate

Event i am getting the below error and data is updating correctly.

 

Sys.WebForms.PageRequestMangerServerErrorException: Procedure or function UpdateDetails has too many arguments specified.
How rosolve the above error.
Code:

 

IDataSource

 

dataSource = SchedulerDataSource;

 

 

DataSourceView view = dataSource.GetView("DefaultView");

 

 

IDictionary keys = new OrderedDictionary();

 

 

IOrderedDictionary data = new OrderedDictionary();

 

data.Add(

"UPStartTime", starttime);

 

data.Add(

"UPEndTime", endtime);

 

data.Add(

"UPDuration", duration);

 

data.Add(

"UPUpdatedBy", "242675");

 

data.Add(

"UPDate", date);

 

data.Add(

"UPChairId", resourceId);

 

data.Add(

"UPAppointmentID", id);

 

 

int j = data.Count;

 

view.Update(keys, data ,

new OrderedDictionary(), OnDataSourceOperationComplete);

 

 

I tried to resolve using the  onupdating="SchedulerDataSource_Updating" event to remove the extra Parameters added by VS.

 

 

 

8.

 

TimeSlotContextMenus are showing when user click on resources. How to restirct it.

 

 

9.
In RadGrid there are 5 columns and i want to give sorting feature to only 2 columns in that grid but in the front end users are able to 
sort using all the columns. How to restrict some columns for sorting by clicking on the grid columns. 

 

 

<SortExpressions>

 

 

 

<telerik:GridSortExpression FieldName="TeammateName" SortOrder="Ascending" />

 

 

 

<telerik:GridSortExpression FieldName="Role" SortOrder="Ascending" />

 

 

 

</SortExpressions>

10.Please go through the attached screen and the questions about the attached screen shot are
   

 

1. How to remove the blue color in b/t the two schedulers.

2. Whenever I click on New Appointment its showing like below.

3. Whenever we are moving the appointments we are getting the below java script error.



 

 

 



Please Give any suggestions ASAP.
Please suggest any reference links for all the above points.
Thanks in advance.





Ivan Zhekov
Telerik team
 answered on 04 Nov 2013
1 answer
92 views
Hello
Inside my user control there is a formview with radTooltips assigned to each control; there is both edit and insert modes. Each works as the code is almost identical, and each is done in a pop-up window.

however if we are in insert-mode and save this switches my formview to edit-mode without closing the pop-up. Then the edit-mode tooltips all show up blank (a small blue rectangle shape). The radTooltip control is in its own user control. The tips load from the database.
I don't use a tooltip manager on ajax managers as I haven't had the need.

I understand that the tooltips need to be loaded/initiated when I call to change to edit mode. Is there a way to load the tips without requiring the users to close the edit window?

thanks
Adam King
Top achievements
Rank 1
 answered on 04 Nov 2013
1 answer
82 views
Implemented tooltips on scheduler based on your demo.  Issue im having is when you move to the next month, the tooltips do not get created. It seems like the tooltips are only being created for the initial months view.

Please help!
Boyan Dimitrov
Telerik team
 answered on 04 Nov 2013
Narrow your results
Selected tags
Tags
+? more
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?