Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
181 views

Hi everyone.
I've a problem with my TreeView controls. the problem is;

When I try to bind data from DB to RadTreeView, it gives this error : "This constraint cannot be enabled as not all values have corresponding parent values."

Default.aspx

<body>
    <form id="form1" runat="server">
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MedsConnectionString %>" SelectCommand="sp_MAIN_ACC_TREE" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:Parameter DefaultValue="1" Name="ACC_id_A" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
        </Scripts>
    </telerik:RadScriptManager>
    <script type="text/javascript">
        //Put your JavaScript code here.
    </script>
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
    </telerik:RadAjaxManager>
    <div>

        <telerik:RadTreeView ID="RadTreeView1" Runat="server" DataFieldID="ACC_ID_A" DataFieldParentID="ACC_PARENT_A" DataSourceID="SqlDataSource1" DataTextField="ACC_NAME_A" DataValueField="ACC_ID_A" Height="131px" OnNodeClick="RadTreeView1_NodeClick">
        </telerik:RadTreeView>

    </div>
    </form>
</body>

 DataTable : 

ACC_ID_A           ACC_NAME_A           ACC_PARENT_A

 

 1                            Accounting tree                  NULL

 2                            essential                               1

 3                            Cars                                      2

4                              Ambulance                          3

 

stored procedure : 

ALTER PROCEDURE [dbo].[sp_MAIN_ACC_TREE]
@ACC_id_A as int
AS
BEGIN
with subtree2(ACC_ID_A , ACC_NAME_A , ACC_PARENT_A)
as
(
select * from MAIN_ACC_A where ACC_PARENT_A = @ACC_id_A
union all
select e.ACC_ID_A, e.ACC_NAME_A ,e.ACC_PARENT_A from MAIN_ACC_A
as e inner join subtree2 on subtree2.ACC_ID_A=e.ACC_PARENT_A
)
select * from subtree2
order by ACC_PARENT_A
END

 

I need solve this problem necessary

thanks

Nencho
Telerik team
 answered on 19 Nov 2015
4 answers
109 views

Hi there,
 have set up a Provider for the Scheduler to enable multiple resources…
This part is working well – but am getting lots of error with my recurring appointments (normal ones are fine).  Have modelled my code from the example in the DbScheduleProvider in the Demo project.
If I try to delete a recurring (either series/individual) I get:

Cannot locate the parent of appointment with ID = '15'. Ensure that the parent appointment with ID = '' exists and is loaded.
[InvalidOperationException: Cannot locate the parent of appointment with ID = '15'. Ensure that the parent appointment with ID = '' exists and is loaded.]
  Telerik.Web.UI.Scheduling.AppointmentController.DeleteAppointment(ISchedulerInfo schedulerInfo, Appointment appointmentToDelete, Boolean deleteSeries) +1254
   Telerik.Web.UI.RadScheduler.DeleteAppointment(Appointment appointmentToDelete) +88
   Telerik.Web.UI.RadScheduler.ProcessPostBackCommand(SchedulerPostBackEvent postBack) +1440
   Telerik.Web.UI.RadScheduler.RaisePostBackEvent(String eventArgument) +62
   Telerik.Web.UI.RadScheduler.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +9672166
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724


If I move a recurring appointment I get:

Object reference not set to an instance of an object.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:



[NullReferenceException: Object reference not set to an instance of an object.]
   Telerik.Web.UI.Scheduling.AppointmentController.PrepareToEdit(Appointment appointmentToEdit, Boolean editSeries) +110
   Telerik.Web.UI.RadScheduler.Telerik.Web.UI.IScheduler.HandleMove(Appointment appointmentToMove, DateTime start, DateTime end, Boolean editSeries, ResourceUpdateInfo resourceUpdateInfo) +46
   Telerik.Web.UI.Scheduler.Views.Week.Model.HandleMove(Appointment appointment, ISchedulerTimeSlot sourceSlot, ISchedulerTimeSlot targetSlot, Boolean editSeries) +438
   Telerik.Web.UI.Scheduler.Views.SchedulerModel.ProcessPostBackCommand(SchedulerPostBackEvent postBack) +279
   Telerik.Web.UI.RadScheduler.ProcessPostBackCommand(SchedulerPostBackEvent postBack) +3412
   Telerik.Web.UI.RadScheduler.RaisePostBackEvent(String eventArgument) +62
   Telerik.Web.UI.RadScheduler.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +9672166
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724



Really appreciate any help I can get!

thanks, Andy



Bozhidar
Telerik team
 answered on 19 Nov 2015
8 answers
140 views

Team,

Please provide an example of gannt chart using RadHtmlChart.

 

Thanks,

Suresh.

 

Marin Bratanov
Telerik team
 answered on 19 Nov 2015
1 answer
158 views
<telerik:RadGrid ID="rgridUserList" runat="server" GridLines="None" OnNeedDataSource="rgridUserList_NeedDataSource"
                   AllowSorting="true" EnableHeaderContextMenu="true" EnableHeaderContextFilterMenu="true"
                   AllowFilteringByColumn="true" EnableLinqExpressions="false" OnItemCommand="rgridUserList_ItemCommand"
                   Skin="Telerik" OnItemDataBound="rgridUserList_ItemDataBound">
                   <ClientSettings>
                       <Selecting AllowRowSelect="True"></Selecting>
                   </ClientSettings>
                   <GroupingSettings CaseSensitive="false"></GroupingSettings>
                   <MasterTableView DataKeyNames="UserID" CommandItemDisplay="Top" IsFilterItemExpanded="false"
                       EnableHeaderContextMenu="true" EnableHeaderContextFilterMenu="true" AllowFilteringByColumn="true">
                       <Columns>
                           <telerik:GridTemplateColumn HeaderText="No." UniqueName="Number" ItemStyle-CssClass="NumberColomn">
                               <HeaderStyle Width="30px" HorizontalAlign="Center" />
                               <ItemStyle HorizontalAlign="Center" />
                               <ItemTemplate>
                                   <asp:Label ID="lblGridNumber" runat="server" Text='<%# (rgridUserList.PageSize*rgridUserList.CurrentPageIndex)+ Container.ItemIndex + 1 %>'></asp:Label>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="User Name" UniqueName="UserName" SortExpression="UserName"
                               CurrentFilterFunction="Contains" DataField="UserName" >
                               <HeaderStyle HorizontalAlign="Center" />
                               <ItemStyle HorizontalAlign="Left" />
                               <ItemTemplate>
                                   <asp:HyperLink ID="hlUserName" Font-Underline="true" runat="server"><%# DataBinder.Eval(Container, "DataItem.UserName") %></asp:HyperLink>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="Full Name" UniqueName="FullName" SortExpression="FullName"
                               CurrentFilterFunction="Contains" DataField="FullName">
                               <HeaderStyle HorizontalAlign="Center" />
                               <ItemStyle HorizontalAlign="Left" />
                               <ItemTemplate>
                                   <asp:Label ID="lblFullName" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.FullName") %>'></asp:Label>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="Email" UniqueName="Email" SortExpression="Email"
                               CurrentFilterFunction="Contains" DataField="Email">
                               <HeaderStyle HorizontalAlign="Center" />
                               <ItemStyle HorizontalAlign="Left" />
                               <ItemTemplate>
                                   <asp:Label ID="lblEmail" SkinID="EmailColor" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Email") %>'></asp:Label>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="User Group" UniqueName="UserGroupItem" SortExpression="UserGroupItem"
                               DataField="UserGroupItem" CurrentFilterFunction="Contains" >
                               <HeaderStyle HorizontalAlign="Center" />
                               <ItemStyle HorizontalAlign="Left" />
                               <ItemTemplate>
                                   <asp:Label ID="lblUserGroup" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.UserGroupItem") %>'></asp:Label>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="Is Active" UniqueName="IsActive" SortExpression="IsActive"
                               HeaderStyle-HorizontalAlign="Center" >
                               <ItemStyle HorizontalAlign="Center" />
                               <ItemTemplate>
                                   <asp:CheckBox ID="cbIsActive" runat="server" Enabled="false" Checked='<%# DataBinder.Eval(Container, "DataItem.IsActive") %>' />
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="Created By" UniqueName="CreatedBy" SortExpression="CreatedBy"
                                HeaderStyle-HorizontalAlign="Center" DataField="CreatedByName" CurrentFilterFunction="Contains">
                               <ItemStyle HorizontalAlign="Center" />
                               <ItemTemplate>
                                   <asp:Label ID="lblCreatedBy" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CreatedByName") %>'></asp:Label>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="Last Access" UniqueName="LastAccess" SortExpression="LastAccess"
                                HeaderStyle-HorizontalAlign="Center" DataField="LastAccess" CurrentFilterFunction="Contains">
                               <ItemStyle HorizontalAlign="Center" />
                               <ItemTemplate>
                                   <asp:Label ID="lblLastAccess" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.LastAccess","{0:dd-MM-yyyy hh:mm tt}") %>' />
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="Need Approval" Visible="false" UniqueName="IsNeedApproval"
                               HeaderStyle-HorizontalAlign="Center" SortExpression="IsNeedApproval">
                               <ItemStyle HorizontalAlign="Center" />
                               <ItemTemplate>
                                   <asp:CheckBox ID="cbIsNeedApproval" runat="server" Checked='<%# DataBinder.Eval(Container, "DataItem.IsNeedApproval") %>'>
                                   </asp:CheckBox>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                           <telerik:GridTemplateColumn HeaderText="Action" UniqueName="Action">
                               <HeaderStyle Width="100px" HorizontalAlign="Center" />
                               <ItemStyle HorizontalAlign="Center" />
                               <ItemTemplate>
                                   <asp:ImageButton ID="btnEdit" runat="server" SkinID="Edit" CommandName="Edit" Visible='<%# !(bool)DataBinder.Eval(Container, "DataItem.IsNeedApproval") %>' />
                                   <asp:ImageButton ID="btnDelete" runat="server" SkinID="Delete" CommandName="Delete"
                                       Visible='<%# !(bool)DataBinder.Eval(Container, "DataItem.IsNeedApproval") %>'
                                       OnClientClick="javascript:return confirm('Are you sure want to delete?')" />
                                   <asp:Label ID="lblNeedApproval" runat="server" Text='Need Approval' Visible='<%# DataBinder.Eval(Container, "DataItem.IsNeedApproval") %>'
                                       ForeColor="Red"></asp:Label>
                               </ItemTemplate>
                           </telerik:GridTemplateColumn>
                       </Columns>
                       <CommandItemTemplate>
                           <telerik:RadToolBar ID="RadTBUser" runat="server" SkinID="NewAndExport" />
                       </CommandItemTemplate>
                       <ExpandCollapseColumn Visible="False" Resizable="False">
                           <HeaderStyle Width="20px" />
                       </ExpandCollapseColumn>
                       <CommandItemSettings ExportToPdfText="Export to PDF" />
                       <RowIndicatorColumn Visible="False">
                           <HeaderStyle Width="20px" />
                       </RowIndicatorColumn>
                       <EditFormSettings>
                           <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                           </EditColumn>
                       </EditFormSettings>
                       <PagerStyle AlwaysVisible="True" Mode="NextPrevNumericAndAdvanced"></PagerStyle>
                   </MasterTableView>
                   <HeaderStyle HorizontalAlign="Center" />
                   <FilterMenu EnableImageSprites="False">
                   </FilterMenu>
                   <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">
                   </HeaderContextMenu>
               </telerik:RadGrid>

 

 

That is my code..

Scenario:

-I have 12 records ( 0.12Records.JPG)

-I try to filter (1.Search.JPG) The filter is fine. 

-Then I click Search button to rebind grid's datasource (2.Search.JPG)

-The right click filter on header , the text is cleared. But, the records not showing all records. I try to type something, the filter is not working.

-After I click Search Button (again) the filter is fine again.

 

What inside button search is:

private void BindGrid()
   {
       try
       {
           sessUserCollection = null;
           rgridUserList.Rebind();
       }
       catch (Exception Ex)
       {
           throw Ex;
       }
   }

 

So, the problem is when I click once the search button (rebind grid) the filter is crippled.

I need to click it twice, so the database hitted twice.

 

 

 

Any ways to solve this problem?
Am I missing something?

 

 

chameleon
Top achievements
Rank 1
 answered on 19 Nov 2015
3 answers
157 views

Hello, thanks for looking at my question.  I have a popup ​Add Record window, one of the fields to select is a RadDropDownList that is populated by the Department ID column from the database.   The items in the list are not sorted and I would like them sorted in order for the user to find he needed ID faster.

The RadDropDownList is within an EditItemTemplate  that is within a  GridTemplateColumn.

 

<telerik:GridTemplateColumn HeaderText="DepartmentID" ItemStyle-Width="240px">
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem, "DepartmentID")%>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadDropDownList runat="server" ID="RadDropDownList1" DataTextField="DepartmentID"
DataValueField="DepartmentID" DataSourceID="SqlDataSource1" SelectedValue='<%#Bind("DepartmentID")%>'>
</telerik:RadDropDownList>
</EditItemTemplate>
</telerik:GridTemplateColumn>

 

I have tried AllowSorting, SortExpression on the RadDropDownList and they did not work.

What am I missing in my code?

 

Thank you, Dale

 

Dale
Top achievements
Rank 1
 answered on 18 Nov 2015
6 answers
323 views
I used the new Telerik control panel to update my ASP.NET Ajax, Reporting and JustCode. There were no error messages shown, but if I click on ASP.NET Ajax or Reporting, it shows a status of "Partially Installed". I tried to repair both installs, but still have the same message. What the heck does it mean and how do I fix it?
Yana
Telerik team
 answered on 18 Nov 2015
3 answers
81 views

Hi there,

I'm currently using a Radmenu in a RadAjaxPanel. On a Itemclick in the radmenu i clear the multipage and add a new one based on the value of the radmenuitem, the radmenu however stays expanded after the refresh. If i remove the above RadAjaxPanel the radmenu doesn't stay expanded, with the radajaxpanel it does. How can I solve this?

Kind Regards,

 

Nencho
Telerik team
 answered on 18 Nov 2015
8 answers
230 views

Using the latest SP of 2015.2.

I have a Hierarchy RadGrid with the following options set:

HierarchyLoadMode="Client"

and 

<ClientEvent​s OnRowClick="expandCollapseRow" />

Then in Javascript:

function expandCollapseRow(sender, args)

{     

var item = args.get_item();     

item.set_expanded(!item.get_expanded());

}

This works great - but if I don't click on the Expand/Collapse Icon directly - the icon does not change.  I think this may be a bug with set_expanded()

Bernie
Top achievements
Rank 1
 answered on 18 Nov 2015
1 answer
139 views

Hello everyone, drag and drop is not working on Internet Explorer 11, but it's working on Chrome 46.

On a aspx page, with 3 rad async upload controls, when I drag and drop the image, Explorer just show the image.

The online demo works on IE11 but I believe it's using a Telerik newer version.

http://demos.telerik.com/aspnet-ajax/asyncupload/examples/draganddrop/defaultvb.aspx?show-source=true​

I'm using the Telerik Version Q2 2013 SP1.

 Thanks in advanced.

Pavlina
Telerik team
 answered on 18 Nov 2015
2 answers
109 views

Hello Telerik-Team,

i have a RadLightBox with a ItemTemplate and a RadGrid with an asp:LinkButton, where i open the lightbox.

Open the Lightbox is without any problems. I can change â€‹the Textbox Value in the RadLightBox Itemtemplate in PreRender. 

But the problem is, in the first call is the Textbox in RadLightbox always empty. The calls after are working without any problems. 

Any Ideas?

Thanks,

Nick

    function ShowBox(recordId) {
        $get('<%= HiddenField1.ClientID %>').value = recordId;
        var lightBox1 = $find('<%= RadLightBox1.ClientID %>');
        lightBox1.show();
}

 

<telerik:GridTemplateColumn HeaderText="<%$ Resources:Details %>" UniqueName="Details">
        <ItemTemplate>
                <asp:LinkButton ID="lnkEdit" runat="server" Text="<%$ Resources:Details %>" ></asp:LinkButton>
           </ItemTemplate>
</telerik:GridTemplateColumn>

 

<telerik:RadLightBox ID="RadLightBox1" runat="server" Width="1000px" Height="720px"
    Modal="true" ZIndex="100000">
    <ClientSettings>
        <AnimationSettings HideAnimation="Resize" NextAnimation="Fade"
            PrevAnimation="Fade" ShowAnimation="Resize" />
    </ClientSettings>
    <Items>
        <telerik:RadLightBoxItem>
            <ItemTemplate>
                <telerik:RadTextBox runat="server" ID="LightBoxNotice" Label="Notlar: "
                    text="" Width="800px" Height="300px" EnableViewState="false"
                    OnInit="LightBoxNotice_Init"
                    OnPreRender="LightBoxNotice_PreRender" TextMode="MultiLine"></telerik:RadTextBox>
            </ItemTemplate>
        </telerik:RadLightBoxItem>
    </Items>
</telerik:RadLightBox>

Kostadin
Telerik team
 answered on 18 Nov 2015
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
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
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?