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
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
Team,
Please provide an example of gannt chart using RadHtmlChart.
Thanks,
Suresh.
<
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?
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
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,
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()
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.
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
>