Questions on UI for ASP.NET AJAX Forum

1 answer

105 views

Hi Team,

I am implementing one application and in that i am using kendo map.

I have plotted bubbles on map. And i have added wraparound : true property.

My issue is when i am scrolling map to left or right side ,adjacent part of map is loading because i have used wraparound: true. But i can not see bubbles applied on same region. For example i have applied bubbles on few cities of US country. But when i am scrolling map to left or right side, new map get loaded, but i can not see any bubble on same cities of US.

How can i make visible those bubbles for everytime.

Thanks & Regards,

Amit

Map

answered on 30 Mar 2017

1 answer

137 views

PivotGrid - Chart Integration

Hi all,

I´ve made a PivotGrid with Chart integration like the example on the demo page.
My output is a little bit different as the demo. See attached file. As you can see in the picture the chart was generated twice.

Do you know why?

Here is my code aspx:

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/BdVNet.Master" AutoEventWireup="true" CodeBehind="Telefondaten.aspx.cs"

Inherits="BdVNet.Content.Reporting.Telefondaten" %>

<asp:Content ID="ReportTelefonContent" ContentPlaceHolderID="BdVMasterContentPlaceHolder" runat="server">

<telerik:RadAjaxManagerProxy ID="ReportTelefonAjaxManagerProxy" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="ReportTelefonPivotGrid">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="ReportTelefonPivotGrid" />

<telerik:AjaxUpdatedControl ControlID="A1HtmlChart" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="ReportTelefonZeitenPivotGrid">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="ReportTelefonZeitenPivotGrid" />

<telerik:AjaxUpdatedControl ControlID="A2HtmlChart" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManagerProxy>

<div class="box">

<telerik:RadTabStrip ID="ReportTelefonTabStrip" runat="server" MultiPageID="ReportTelefonMultiPage" SelectedIndex="0" Enabled="true"

RenderMode="<%$ Resources:Einstellungen, RenderMode %>">

<Tabs>

<telerik:RadTab runat="server" Text="Auswertung 1" Selected="true" />

<telerik:RadTab runat="server" Text="Auswertung 2" />

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="ReportTelefonMultiPage" runat="server" SelectedIndex="0" Enabled="true" RenderMode="<%$ Resources:Einstellungen, RenderMode %>">

<telerik:RadPageView ID="ReportTelefonA1PageView" runat="server">

<telerik:RadPivotGrid ID="ReportTelefonPivotGrid" runat="server" OnNeedDataSource="ReportTelefonPivotGrid_NeedDataSource"

ShowDataHeaderZone="false" ShowFilterHeaderZone="false" TotalsSettings-ColumnGrandTotalsPosition="None" Culture="de-DE"

RenderMode="<%$ Resources:Einstellungen, RenderMode %>" ColumnGroupsDefaultExpanded="false" OnCellDataBound="ReportTelefonPivotGrid_CellDataBound"

EnableConfigurationPanel="false">

<Fields>

<telerik:PivotGridRowField DataField="MitarbeiterDIMENSION_LONG" Caption="Abteilung" CellStyle-Width="150" ZoneIndex="0" />

<telerik:PivotGridRowField DataField="Name" Caption="Mitarbeiter" CellStyle-Width="150" />

<telerik:PivotGridColumnField DataField="Jahr" Caption="Jahr" />

<telerik:PivotGridColumnField DataField="Monat" Caption="Monat" />

<telerik:PivotGridColumnField DataField="Art" Caption="Art" />

<telerik:PivotGridAggregateField DataField="Dauer" DataFormatString="{0:N0}" Aggregate="Count">

<HeaderCellTemplate>

Anzahl

</HeaderCellTemplate>

</telerik:PivotGridAggregateField>

<telerik:PivotGridAggregateField DataField="DauerSek" DataFormatString="{0:N0}">

<HeaderCellTemplate>

Dauer

</HeaderCellTemplate>

<CellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</CellTemplate>

<RowTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</RowTotalCellTemplate>

<RowGrandTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</RowGrandTotalCellTemplate>

<ColumnTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</ColumnTotalCellTemplate>

<ColumnGrandTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</ColumnGrandTotalCellTemplate>

</telerik:PivotGridAggregateField>

</Fields>

<ConfigurationPanelSettings Position="Left" DefaultDeferedLayoutUpdate="true" />

</telerik:RadPivotGrid>

<telerik:RadHtmlChart ID="A1HtmlChart" runat="server" RenderMode="<%$ Resources:Einstellungen, RenderMode %>" Legend-Appearance-Position="Top"

PlotArea-YAxis-LabelsAppearance-DataFormatString="N0" PlotArea-XAxis-LabelsAppearance-RotationAngle="45">

<Appearance>

<FillStyle BackgroundColor="Transparent" />

</Appearance>

<ChartTitle Text="Telefondaten">

<Appearance Align="Center" BackgroundColor="Transparent" Position="Top" />

</ChartTitle>

</telerik:RadHtmlChart>

</telerik:RadPageView>

<telerik:RadPageView ID="ReportTelefonA2PageView" runat="server">

<telerik:RadPivotGrid ID="ReportTelefonZeitenPivotGrid" runat="server" OnNeedDataSource="ReportTelefonZeitenPivotGrid_NeedDataSource"

ShowDataHeaderZone="false" ShowFilterHeaderZone="false" TotalsSettings-ColumnGrandTotalsPosition="None" Culture="de-DE"

RenderMode="<%$ Resources:Einstellungen, RenderMode %>" ColumnGroupsDefaultExpanded="false" OnCellDataBound="ReportTelefonZeitenPivotGrid_CellDataBound"

EnableConfigurationPanel="false">

<Fields>

<telerik:PivotGridRowField DataField="Wochentag" Caption="Wochentag" CellStyle-Width="100" />

<telerik:PivotGridRowField DataField="Stunde" Caption="Stunde" CellStyle-Width="100" ZoneIndex="0" />

<telerik:PivotGridRowField DataField="BN_Telefon_Nebenstelle_1" Caption="Nebenstelle" CellStyle-Width="150" ZoneIndex="0" />

<telerik:PivotGridColumnField DataField="Jahr" Caption="Jahr" />

<telerik:PivotGridColumnField DataField="Monat" Caption="Monat" />

<telerik:PivotGridColumnField DataField="Art" Caption="Art" />

<telerik:PivotGridAggregateField DataField="Dauer" DataFormatString="{0:N0}" Aggregate="Count">

<HeaderCellTemplate>

Anzahl

</HeaderCellTemplate>

</telerik:PivotGridAggregateField>

<telerik:PivotGridAggregateField DataField="DauerSek" DataFormatString="{0:N0}">

<HeaderCellTemplate>

Dauer

</HeaderCellTemplate>

<CellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</CellTemplate>

<RowTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</RowTotalCellTemplate>

<RowGrandTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</RowGrandTotalCellTemplate>

<ColumnTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</ColumnTotalCellTemplate>

<ColumnGrandTotalCellTemplate>

<%# (Convert.ToInt64(Container.DataItem) == 0) ? "" : string.Format("{0:d2}:{1:d2}:{2:d2}", (Convert.ToInt64(Container.DataItem)/3600) , (Convert.ToInt64(Container.DataItem)%3600)/60 , (Convert.ToInt64(Container.DataItem)%3600)%60) %>

</ColumnGrandTotalCellTemplate>

</telerik:PivotGridAggregateField>

</Fields>

<ConfigurationPanelSettings Position="Left" DefaultDeferedLayoutUpdate="true" />

</telerik:RadPivotGrid>

<telerik:RadHtmlChart ID="A2HtmlChart" runat="server" RenderMode="<%$ Resources:Einstellungen, RenderMode %>" Legend-Appearance-Position="Top"

PlotArea-YAxis-LabelsAppearance-DataFormatString="N0" PlotArea-XAxis-LabelsAppearance-RotationAngle="45">

<Appearance>

<FillStyle BackgroundColor="Transparent" />

</Appearance>

<ChartTitle Text="Telefondaten">

<Appearance Align="Center" BackgroundColor="Transparent" Position="Top" />

</ChartTitle>

</telerik:RadHtmlChart>

</telerik:RadPageView>

</telerik:RadMultiPage>

</div>

</asp:Content>

and c#

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Telerik.Web.UI;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.Text;

namespace BdVNet.Content.Reporting

{

public partial class Telefondaten : System.Web.UI.Page

{

protected override void OnPreRender(EventArgs e)

{

base.OnPreRender(e);

ReportTelefonPivotGrid.ColumnGroupsDefaultExpanded = false;

ReportTelefonPivotGrid.RowGroupsDefaultExpanded = false;

ReportTelefonPivotGrid.Rebind();

base.OnPreRender(e);

ReportTelefonZeitenPivotGrid.ColumnGroupsDefaultExpanded = false;

ReportTelefonZeitenPivotGrid.RowGroupsDefaultExpanded = false;

ReportTelefonZeitenPivotGrid.Rebind();

}

protected void Page_Load(object sender, EventArgs e)

{

string currentYear = DateTime.Now.Year.ToString();

string currentMonth = String.Format(format: "{0:MM}", arg0: DateTime.Now);

if (Code.AccessControl.UserAdminAccessIsValid == true || Code.AccessControl.UserMgmAccessIsValid == true)

{

var menuSelect = (RadMenu)Master.FindControl(id: "BdVMasterMenu");

menuSelect.Items[2].Items[1].Selected = true;

}

else

{

Response.Redirect(url: "../Geschaeft.aspx");

}

Label masterPageTextLabel;

masterPageTextLabel = (Label)Master.FindControl("BdVMasterTextLabel");

masterPageTextLabel.Text = "Reporting | Telefonanlage";

if (!IsPostBack)

{

ReportTelefonPivotGrid.CollapsedColumnIndexes.Add(new object[] { currentYear });

ReportTelefonZeitenPivotGrid.CollapsedColumnIndexes.Add(new object[] { currentYear });

//ReportTelefonPivotGrid.CollapsedColumnIndexes.Add(new object[] { currentMonth });

}

protected void ReportTelefonPivotGrid_NeedDataSource(object sender, Telerik.Web.UI.PivotGridNeedDataSourceEventArgs e)

{

string sqlSelectCommand = "SELECT * FROM [BN_R_Telefonanlage] WHERE Name != ''";

var adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["BdVNet"].ConnectionString);

DataTable myDataTable = new DataTable();

adapter.Fill(myDataTable);

ReportTelefonPivotGrid.DataSource = myDataTable;

}

HashSet<string> columnNames = new HashSet<string>();

Dictionary<string, ColumnSeries> columnSeriesByRowName = new Dictionary<string, ColumnSeries>();

protected void ReportTelefonPivotGrid_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)

{

PivotGridDataCell dataCell = e.Cell as PivotGridDataCell;

if (columnNames.Count == 0)

{

this.A1HtmlChart.PlotArea.XAxis.Items.Clear();

this.A1HtmlChart.PlotArea.Series.Clear();

}

if (dataCell != null && dataCell.CellType == PivotGridDataCellType.DataCell)

{

string rowName = GetName(dataCell.ParentRowIndexes);

string columnName = GetName(dataCell.ParentColumnIndexes);

columnName = columnName.Replace('\'', ' ');

if (columnNames.Add(columnName))

{

AxisItem axisItem = new AxisItem(columnName);

this.A1HtmlChart.PlotArea.XAxis.Items.Add(axisItem);

}

ColumnSeries columnSeries = null;

if (columnSeriesByRowName.ContainsKey(rowName))

{

columnSeries = columnSeriesByRowName[rowName];

columnSeries.LabelsAppearance.DataFormatString = "N2";

//columnSeries.LabelsAppearance.ClientTemplate = "test #=value#";

}

else

{

columnSeries = new ColumnSeries();

columnSeriesByRowName.Add(rowName, columnSeries);

columnSeries.Name = rowName;

columnSeries.LabelsAppearance.DataFormatString = "N0";

this.A1HtmlChart.PlotArea.Series.Add(columnSeries);

}

CategorySeriesItem item = new CategorySeriesItem();

decimal value = 0;

if (e.Cell.DataItem != null && decimal.TryParse(e.Cell.DataItem.ToString(), out value))

{

if (value != 0)

{

if (columnName.Contains("Dauer"))

{

item.Y = value / 3600;

}

else

{

item.Y = value;

}

else

{

item.Y = null;

}

columnSeries.SeriesItems.Add(item);

}

private string GetName(object[] indexes)

{

StringBuilder builder = new StringBuilder();

foreach (object index in indexes)

{

builder.Append(index.ToString());

builder.Append(" | ");

}

builder.Remove(builder.Length -3, 3);

builder.Replace("Count of Dauer", "Anzahl");

builder.Replace("Sum of DauerSek", "Dauer");

return builder.ToString();

}

protected void ReportTelefonZeitenPivotGrid_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)

{

string sqlSelectCommand = "SELECT * FROM [BN_R_Telefonanlage] WHERE Name IS NULL";

var adapter = new SqlDataAdapter(sqlSelectCommand, ConfigurationManager.ConnectionStrings["BdVNet"].ConnectionString);

DataTable myDataTable = new DataTable();

adapter.Fill(myDataTable);

ReportTelefonZeitenPivotGrid.DataSource = myDataTable;

}

protected void ReportTelefonZeitenPivotGrid_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)

{

PivotGridDataCell dataCell = e.Cell as PivotGridDataCell;

if (columnNames.Count == 0)

{

this.A2HtmlChart.PlotArea.XAxis.Items.Clear();

this.A2HtmlChart.PlotArea.Series.Clear();

}

if (dataCell != null && dataCell.CellType == PivotGridDataCellType.DataCell)

{

string rowName = GetName(dataCell.ParentRowIndexes);

string columnName = GetName(dataCell.ParentColumnIndexes);

columnName = columnName.Replace('\'', ' ');

if (columnNames.Add(columnName))

{

AxisItem axisItem = new AxisItem(columnName);

this.A2HtmlChart.PlotArea.XAxis.Items.Add(axisItem);

}

ColumnSeries columnSeries = null;

if (columnSeriesByRowName.ContainsKey(rowName))

{

columnSeries = columnSeriesByRowName[rowName];

columnSeries.LabelsAppearance.DataFormatString = "N2";

//columnSeries.LabelsAppearance.ClientTemplate = "test #=value#";

}

else

{

columnSeries = new ColumnSeries();

columnSeriesByRowName.Add(rowName, columnSeries);

columnSeries.Name = rowName;

columnSeries.LabelsAppearance.DataFormatString = "N0";

this.A2HtmlChart.PlotArea.Series.Add(columnSeries);

}

CategorySeriesItem item = new CategorySeriesItem();

decimal value = 0;

if (e.Cell.DataItem != null && decimal.TryParse(e.Cell.DataItem.ToString(), out value))

{

if (value != 0)

{

if (columnName.Contains("Dauer"))

{

item.Y = value / 3600;

}

else

{

item.Y = value;

}

else

{

item.Y = null;

}

columnSeries.SeriesItems.Add(item);

}

Many thanks in advance

Andreas

PivotGrid

answered on 30 Mar 2017

0 answers

78 views

Customize Gantt Task

Dear all,

Is there any way to change the background color of the children tasks based on the data in the database?

I need to have different background colors alerting the user of the task's status (overdue, on track, completed). I appreciate your time.

Regards,

Marija

Gantt

asked on 30 Mar 2017

3 answers

221 views

Telerik Scheduler RadSchedulerRecurrenceEditor.RecurrenceRule.MaximumCandidates does not work : Possible bug since 2010

My project still uses Telerik v2011.1.413.35 and came across an issue with the recurrence editor. Here are the settings:

Recurrence: Hourly
Recur every: 1 hr
Repeat end: End By
End by: 10/3/2018

The above setting when configured in UI or preset at Page_Load always generates and stops at only 3000 occurrences. I tried setting/overriding RadSchedulerRecurrenceEditor.RecurrenceRule.MaximumCandidates and RadSchedulerRecurrenceEditor.RecurrenceRule.Range.MaxOccurrences during Page_Load or on click/submit of form, before accessing Occurrences property, as suggested in these forum topics: Link 1, Link 2. That does not work.

So, I went ahead and installed the latest Telerik UI for ASP.NET AJAX, and tried the same experiement a fresh, simple page that only has the recurrence editor, and still does not work. Below is the code snippet, both ASPX and VB page.

01.<%@ Page Language="VB" AutoEventWireup="false" CodeFile="RecurrenceEditor.aspx.vb" Inherits="RecurrenceEditor" %>

02.

03.<!DOCTYPE html>

04.

05.<html xmlns="http://www.w3.org/1999/xhtml">

06.<head runat="server">

07. <title></title>

08. <telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />

09.</head>

10.<body>

11. <form id="form1" runat="server">

12. <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>

13. <asp:Panel ID="pnlRadRecurrenceEditorTest" runat="server" CssClass="ssection" Width="600">

14. <telerik:RadSchedulerRecurrenceEditor ID="radRecurEditor" runat="server"></telerik:RadSchedulerRecurrenceEditor>

15. <asp:Button ID="btnRadRecurrenceEditorSubmit" runat="server" Text="Schedule Submit" /><br />

16. <asp:Label ID="lblRadRecurrenceEditorDetails" runat="server"></asp:Label>

17. </asp:Panel>

18. </form>

19.</body>

20.</html>

01.Imports Telerik.Web.UI

02.

03.Partial Class RecurrenceEditor

04. Inherits System.Web.UI.Page

05.

06. Protected Sub Page_Load_Recurrence(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

07. lblRadRecurrenceEditorDetails.Text = String.Empty

08. If IsPostBack Then Exit Sub

09. 'NOTE: With or without the below code commented, I cannot get occcurrences > 3000 in count

10. Dim endDate As New Date(2018, 10, 4)

11. radRecurEditor.StartDate = Now()

12. radRecurEditor.EndDate = endDate

13. radRecurEditor.RecurrenceRule = New HourlyRecurrenceRule(1, New RecurrenceRange(Now(), TimeSpan.Zero, endDate, 0))

14. radRecurEditor.RecurrenceRule.Range.MaxOccurrences = 10002

15. radRecurEditor.RecurrenceRule.MaximumCandidates = 10001

16. lblRadRecurrenceEditorDetails.Text += "<br>Max occurrences: " & radRecurEditor.RecurrenceRule.Range.MaxOccurrences.ToString()

17. lblRadRecurrenceEditorDetails.Text += "<br>Max candidates: " & radRecurEditor.RecurrenceRule.MaximumCandidates.ToString()

18. End Sub

19. Protected Sub btnRadRecurrenceEditorSubmit_Click(sender As Object, e As EventArgs) Handles btnRadRecurrenceEditorSubmit.Click

20. Dim output As New List(Of String)

21. output.Add("Max candidates: " & radRecurEditor.RecurrenceRule.MaximumCandidates.ToString())

22. radRecurEditor.RecurrenceRule.MaximumCandidates = 10000 'doesn't work

23. output.Add("Max candidates changed to: " & radRecurEditor.RecurrenceRule.MaximumCandidates)

24. output.Add("Max occurrences: " & radRecurEditor.RecurrenceRule.Range.MaxOccurrences.ToString())

25. output.Add("ToList count: " & radRecurEditor.RecurrenceRule.Occurrences.ToList().Count)

26. output.Add("Total count: " & radRecurEditor.RecurrenceRule.Occurrences.Count)

27. output.Add("Last recurring date: " & radRecurEditor.RecurrenceRule.Occurrences.LastOrDefault())

28. lblRadRecurrenceEditorDetails.Text = String.Join("<br>", output)

29. End Sub

30.

31.End Class

I have also attached the resultant page view.

Let me know what I'm doing wrong here, or if this is an actual bug in the tool.

Thanks.

Scheduler

answered on 30 Mar 2017

1 answer

123 views

RadCombo box inside Rad Grid is not working

Hi

I want to use RadCombo Box inside Rad grid and to use Multiselect combo using Checkboxes,By the major Issue is i am not getting the grid when I use the below code and the comboBox is displayes in front of all columns,While doing Crud operations the ComboBox column is not showing but is show a textbox

Here is my Design:

<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
<telerik:RadSkinManager ID="RadSkinManager1" runat="server" Skin="Telerik" />

<telerik:RadAjaxManager runat="server" ID="RadAjaxManager1">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadFormDecorator RenderMode="Lightweight" ID="RadFormDecorator1" runat="server" DecorationZoneID="demo" DecoratedControls="All" EnableRoundedCorners="false" />
<div>
<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" GridLines="None" AutoGenerateColumns="false" PageSize="10"
AllowPaging="true" AllowSorting="true" runat="server" DataSourceID="SqlDataSource2" OnItemDataBound="RadGrid1_ItemDataBound"
AllowAutomaticUpdates="true" AllowAutomaticInserts="True" >
<MasterTableView ShowFooter="false" DataKeyNames="Empid" EditMode="InPlace" CommandItemDisplay="TopAndBottom">
<Columns>
<telerik:GridBoundColumn DataField="EmpId" HeaderText="EmpId"
HeaderStyle-Width="300px" ItemStyle-Width="300px" />

<telerik:GridBoundColumn DataField="EmpName" HeaderText="EmployeeName"
HeaderStyle-Width="300px" ItemStyle-Width="300px" />

<telerik:GridBoundColumn HeaderText="Skills" DataField="CategoryName">
<FilterTemplate>


<telerik:RadComboBox ID="RadCombobox1" runat="server">
</telerik:RadComboBox>



<%# Eval("CategoryName")%>
</ItemTemplate>
</FilterTemplate>
</telerik:GridBoundColumn>



<telerik:GridEditCommandColumn FooterText="EditCommand footer" UniqueName="EditCommandColumn"
HeaderText="Edit" HeaderStyle-Width="100px" UpdateText="Update">
</telerik:GridEditCommandColumn>

</Columns>
</MasterTableView>
</telerik:RadGrid>

ComboBox

answered on 30 Mar 2017

1 answer

148 views

RadGrid FilterType Header Context - No accepting List Box Filters

I am having the following problem. I am doing the excel type Filter (FilterType="HederContext"). All the filtering options work except for the list box combo. I am retrieving the list box options (and they display), but when I check to filter one of them it does not filter any of the data elements. I can use the sort ascending/descending/add & remove columns. Start by and equals.

I just cannot use any fields in the combo box.

Here is the code sample:

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/WebForms.master" AutoEventWireup="true" CodeBehind="PostageReport.aspx.cs" Inherits="Site.Areas.Reports.PostageReport.PostageReport" %>

<asp:Content ID="Content7" ContentPlaceHolderID="ContentBottom" runat="server">

Date From:

<asp:Label runat="server" Visible="true" ID="lblDf"></asp:Label><br />

Date To:

<asp:Label runat="server" Visible="true" ID="lblDt"></asp:Label>

<%-- <telerik:RadScriptManager ID ="RadScriptManager1" runat="server" />--%>

<telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" EnableAJAX="true" LoadingPanelID="LoadingPanel1">

<telerik:RadGrid ID="RadGrid1" runat="server" RenderMode="Lightweight"

AllowFilteringByColumn="true"

FilterType="HeaderContext"

EnableHeaderContextMenu="true"

EnableHeaderContextFilterMenu="true"

EnableFiltering="true"

AllowPaging="True"

PagerStyle-AlwaysVisible="true"

AllowSorting="true"

GroupingEnabled="true"

OnNeedDataSource="RadGrid1_NeedDataSource"

OnFilterChecklistItemsRequested="RadGrid1_FilterCheckListItemsRequested">

<MasterTableView AutoGenerateColumns="false" DataKeyNames="new_entrynumber" AllowFilteringByColumn="true" AllowSorting="true" OverrideDataSourceControlSorting="true">

<Columns>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_entrydate" DataFormatString="{0:d}" FilterControlWidth="45px" DataType="System.DateTime" HeaderText="Date" UniqueName="Date"></telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_customernumberid" FilterControlWidth="45px" DataType="System.String" HeaderText="Account Number" UniqueName="CustomerNumber"></telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_costcenter" FilterControlWidth="45px" DataType="System.String" HeaderText="Cost Center" UniqueName="CostCenter"></telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_installname" FilterControlWidth="45px" DataType="System.String" HeaderText="Customer Name" UniqueName="CustomerName"></telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_installcity" FilterControlWidth="45px" DataType="System.String" HeaderText="City" UniqueName="City"></telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_installstate" FilterControlWidth="30px" DataType="System.String" HeaderText="State" UniqueName="State"></telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_serialnumber" FilterControlWidth="45px" DataType="System.String" HeaderText="Serial Number" UniqueName="SerialNumber"></telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterCheckListEnableLoadOnDemand="true" DataField="new_entrydescription" FilterControlWidth="45px" DataType="System.String" HeaderText="Description" UniqueName="TransDescription"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="new_entryamount" DataFormatString="{0:N}" FilterControlWidth="45px" HeaderText="Amount" UniqueName="TransAmount">

<ItemStyle HorizontalAlign="Right" />

<HeaderStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="new_numberimprints" FilterControlWidth="45px" DataType="System.Decimal" HeaderText="Total Piece Count" UniqueName="TotalPieceCount">

<ItemStyle HorizontalAlign="Right" />

<HeaderStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="new_postageused" DataFormatString="{0:N}" FilterControlWidth="45px" DataType="System.Decimal" HeaderText="Total Postage Used" UniqueName="TotalPostageUsed">

<ItemStyle HorizontalAlign="Right" />

<HeaderStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="new_endingcredit" DataFormatString="{0:N}" FilterControlWidth="45px" DataType="System.Decimal" HeaderText="Ending Credit" UniqueName="EndingCredit">

<ItemStyle HorizontalAlign="Right" />

<HeaderStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

<%--<CommandItemSettings ShowAddNewRecordButton="False" ShowExportToCsvButton="True" ShowExportToExcelButton="True" ShowExportToPdfButton="True" ShowExportToWordButton="True" />--%>

</asp:Content>

<asp:Content ID="Content8" ContentPlaceHolderID="Scripts" runat="server">

</asp:Content>

C# code behind it:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Site.Pages;

using Telerik.Web.UI;

using Xrm;

using Microsoft.Xrm.Sdk;

using Microsoft.Xrm.Sdk.Query;

using System.Data;

using System.Globalization;

using System.Threading;

namespace Site.Areas.Reports.PostageReport

{

public partial class PostageReport : PortalPage

{

private DateTime df;

private DateTime dt;

private string _guid;

public void Button2_Click(object sender, ImageClickEventArgs e)

{

// TODO: Implement this method

throw new NotImplementedException();

}

public void RadGrid1_SortCommand(object sender, GridSortCommandEventArgs e)

{

// TODO: Implement this method

throw new NotImplementedException();

}

protected void Page_Load(object sender, EventArgs e)

{

RedirectToLoginIfAnonymous();

}

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

(sender as RadGrid).DataSource = GetDataTable();

}

protected void RadGrid1_FilterCheckListItemsRequested(object sender, GridFilterCheckListItemsRequestedEventArgs e)

{

string DataField = (e.Column as IGridDataColumn).GetActiveDataField();

e.ListBox.DataSource = GetDistinctColumn(DataField);

e.ListBox.DataKeyField = DataField;

e.ListBox.DataTextField = DataField;

e.ListBox.DataValueField = DataField;

e.ListBox.DataBind();

}

public void ParseParameters()

{

if (Request.QueryString["df"] != null) {

df = Convert.ToDateTime(Request.QueryString["df"]).AddDays(1).AddDays(-1);

} else {

// Default is from date two years back

df = DateTime.Today.AddDays(-730);

}

if (Request.QueryString["dt"] != null) {

dt = Convert.ToDateTime(Request.QueryString["dt"]).AddDays(1).AddTicks(-1);

} else {

df = DateTime.Today;

}

if (Request.QueryString["id"] != null) {

_guid = Request.QueryString["id"];

}else {

_guid = "all";

}

public DataTable GetDistinctColumn(string columnName)

{

DataTable dTable = new DataTable();

var xrm = new Xrm.XrmServiceContext("Xrm");

ParseParameters();

lblDf.Text = df.ToShortDateString();

lblDt.Text = dt.ToShortDateString();

Xrm.Account account = new Xrm.Account();

if (_guid == "all")

{

account = xrm.Retrieve(Xrm.Account.EntityLogicalName, Contact.ParentCustomerId.Id, new ColumnSet(true)).ToEntity<Xrm.Account>();

}

else

{

Guid _account = new Guid(_guid);

account = xrm.Retrieve(Xrm.Account.EntityLogicalName, _account, new ColumnSet(true)).ToEntity<Xrm.Account>();

}

dTable.Columns.Add(columnName);

QueryExpression query = new QueryExpression();

query.EntityName = "new_tdcdata";

query.ColumnSet.AddColumn(columnName);

query.Distinct = true;

query.Criteria = new Microsoft.Xrm.Sdk.Query.FilterExpression();

if (_guid == "all")

{

query.Criteria.AddCondition("new_account",ConditionOperator.Equal,account.Id);

} else {

query.Criteria.AddCondition("new_customernumberid",ConditionOperator.Equal,account.Id);

}

Microsoft.Xrm.Sdk.Query.FilterExpression childFilter = query.Criteria.AddFilter(LogicalOperator.And);

childFilter.AddCondition("new_entrydate", ConditionOperator.Between, df, dt);

EntityCollection results = xrm.RetrieveMultiple(query);

foreach (var c in results.Entities)

{

DataRow row = dTable.NewRow();

if (columnName == "new_entrydate")

{

row[columnName] = c.GetAttributeValue<DateTime>(columnName).ToString("M/dd/yyyy", CultureInfo.InvariantCulture);

}

else

{

if (columnName == "new_customernumberid")

{

Guid _account = c.GetAttributeValue<Guid>(columnName);

account = xrm.Retrieve(Xrm.Account.EntityLogicalName, _account, new ColumnSet(true)).ToEntity<Xrm.Account>();

row[columnName] = account.Name;

}

else

{

row[columnName] = c.GetAttributeValue<string>(columnName);

}

dTable.Rows.Add(row);

}

return (dTable);

}

public DataTable GetDataTable()

{

DataTable dTable = new DataTable();

var xrm = new Xrm.XrmServiceContext("Xrm");

ParseParameters();

lblDf.Text = df.ToShortDateString();

lblDt.Text = dt.ToShortDateString();

Xrm.Account account = new Xrm.Account();

if (_guid == "all")

{

account = xrm.Retrieve(Xrm.Account.EntityLogicalName, Contact.ParentCustomerId.Id, new ColumnSet(true)).ToEntity<Xrm.Account>();

}

else

{

Guid _account = new Guid(_guid);

account = xrm.Retrieve(Xrm.Account.EntityLogicalName, _account, new ColumnSet(true)).ToEntity<Xrm.Account>();

}

RadGrid1.ExportSettings.FileName = string.Format("{0}-{1}-{2}-{3}-{4}",

"PostageReport",

account.Name,

df.ToShortDateString().Replace("/", ""),

dt.ToShortDateString().Replace("/", ""),

DateTime.Now.ToString("yyyyMMddHHmmss"));

dTable.Columns.Add("new_entrynumber", typeof(Int32));

dTable.Columns.Add("new_entrydate", typeof(DateTime));

dTable.Columns.Add("new_account");

dTable.Columns.Add("new_customernumberid");

dTable.Columns.Add("new_costcenter");

dTable.Columns.Add("new_installname");

dTable.Columns.Add("new_installaddress");

dTable.Columns.Add("new_installcity");

dTable.Columns.Add("new_installstate");

dTable.Columns.Add("new_installzip");

dTable.Columns.Add("new_serialnumber");

dTable.Columns.Add("new_entrydescription");

dTable.Columns.Add("new_entryamount",typeof(decimal));

dTable.Columns.Add("new_startingcredit", typeof(decimal));

dTable.Columns.Add("new_startingdebit", typeof(decimal));

dTable.Columns.Add("new_entrychecknumber");

dTable.Columns.Add("new_numberimprints",typeof(Int32));

dTable.Columns.Add("new_postageused", typeof(decimal));

dTable.Columns.Add("new_endingcredit", typeof(decimal));

dTable.Columns.Add("new_endingdebit", typeof(decimal));

//dTable.Columns.Add("Price Group");

IQueryable<new_tdcdata> stmt; //xrm.new_tdcdataSet.Where(t => t.new_Account.Id == account.Id);

if (_guid == "all")

{

stmt = xrm.new_tdcdataSet.Where(t => t.new_Account.Id == account.Id && t.new_entryDate >= df && t.new_entryDate <= dt);

}

else

{

stmt = xrm.new_tdcdataSet.Where(t => t.new_CustomerNumberId.Id == account.Id && t.new_entryDate >= df && t.new_entryDate <= dt);

}

Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-US");

Thread.CurrentThread.CurrentCulture.NumberFormat.CurrencyNegativePattern = 1;

foreach (var s in stmt)

{

// List<string> row = new List<string>();

DataRow row = dTable.NewRow();

row["new_entrynumber"] = s.new_entryNumber;

row["new_entrydate"] = s.new_entryDate;

row["new_account"] = (s.new_Account.Name ?? "");

row["new_customernumberid"] = (s.new_CustomerNumberId.Name ?? "");

row["new_costcenter"] = (s.new_CostCenter ?? "");

row["new_installname"] = (s.new_InstallName ?? "");

row["new_installaddress"] = (s.new_InstallAddress ?? "");

row["new_installcity"] =(s.new_InstallCity ?? "");

row["new_installstate"] = (s.new_InstallState ?? "");

row["new_installzip"] = (s.new_InstallZip ?? "");

row["new_serialnumber"] = (s.new_serialNumber ?? "n/a");

//row.Add(string.Format("{0} {1}", s.new_entryDescription ?? "", s.new_entryDescription2 ?? ""));

row["new_entrydescription"] = (string.Format("{0}", s.new_entryDescription ?? ""));

row["new_entryamount"] = s.new_entryAmount;

row["new_startingcredit"] = s.new_startingCredit;

row["new_startingdebit"] = s.new_startingDebit;

row["new_entrychecknumber" ] = (s.new_entryCheckNumber ?? "--");

row["new_numberimprints"] = s.new_numberImprints;

row["new_postageused"] = s.new_postageUsed;

row["new_endingcredit"] = s.new_endingCredit;

row["new_endingdebit"] = s.new_endingDebit;

dTable.Rows.Add(row);

}

return (dTable);

}

Grid

answered on 30 Mar 2017

5 answers

727 views

Use required field validator for new records

Hi

I want to validate new records before they gets added to the grid at client-side. After I clear out the "name" field tag I get the red *. Which is perfectly fine and just what I want to do. However, when I click on "Add new record" button more than once, new empty record gets added without being validated.

What is the most clean and neat way to achieve this? Below is my code using a classic ASP coding style, so you get everything at one place.

01.<%@ Page Language="C#" %>

02.

03.<!DOCTYPE html>

04.

05.<html>

06.<head runat="server">

07. <title>[Title]</title>

08. <script runat="server">

09. protected override void OnInit(EventArgs e)

10. {

11. this.Load += HandleLoad;

12. this.PreLoad += HandlePreLoad;

13.

14. base.OnInit(e);

15. }

16. private void HandleLoad(object sender, EventArgs e)

17. {

18. this.grid.DataSource = new[] { new { Id = 1, Name = "Name" } };

19. }

20. private void HandlePreLoad(object sender, EventArgs e)

21. {

22. this.grid.MasterTableView.AutoGenerateColumns = false;

23. this.grid.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Top;

24. this.grid.MasterTableView.EditMode = GridEditMode.Batch;

25. }

26. </script>

27.</head>

28.<body>

29. <form id="form" runat="server">

30. <asp:ScriptManager runat="server" />

31. <div style="width: 25%">

32. <telerik:RadGrid ID="grid" runat="server">

33. <MasterTableView>

34. <Columns>

35. <telerik:GridTemplateColumn HeaderText="Name">

36. <EditItemTemplate>

37. <asp:TextBox ID="name" runat="server" />

38. <asp:RequiredFieldValidator runat="server" ControlToValidate="name" Text="*" />

39. </EditItemTemplate>

40. <ItemTemplate>

41. <%# Eval("Name") %>

42. </ItemTemplate>

43. </telerik:GridTemplateColumn>

44. </Columns>

45. </MasterTableView>

46. </telerik:RadGrid>

47. </div>

48. </form>

49.</body>

50.</html>

Regrads,

Garmco ICT

Grid

answered on 30 Mar 2017

1 answer

134 views

Inserting data into multiple tables using single RadDataForm with EntityDataSource

Hi,
I have a scenario where in I have to insert data into multiple tables using a single RadDataForm with EntityDataSource

Following are the three tables and Columns
ComType: Id, ConType

ContactDetail: Id, ContactName, City

ContactCom: Id, ContactDetailsId, ComTypeId, ComValue

The point is I am able to insert into single table but not able to insert into multiple tables.

<asp:Label ID="ComValueLabel3" runat="server" AssociatedControlID="ComValueTextBox" CssClass="rdfLabel rdfBlock" Text="ComValue"></asp:Label>
<telerik:RadTextBox ID="ComValueTextBox" runat="server" RenderMode="Lightweight" Text='<%# Bind("ComValue") %>' WrapperCssClass="rdfInput" />

Following is the syntax of calling other tables columns while insertion
<asp:Label ID="ContactNameLabel2" runat="server" AssociatedControlID="ContactNameTextBox" CssClass="rdfLabel rdfBlock" Text="ContactName"></asp:Label>
<telerik:RadTextBox ID="ContactNameTextBox" runat="server" RenderMode="Lightweight" Text='<%# Bind("ContactDetail.ContactName") %>' WrapperCssClass="rdfInput" />

EntityDataSource Code:
<asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=sampleEntities" DefaultContainerName="sampleEntities" EnableDelete="True" EnableFlattening="False" EnableInsert="True" EnableUpdate="True"
EntitySetName="ContactComs" EntityTypeFilter="ContactCom" Include="ContactDetail,ComType"></asp:EntityDataSource>

I am unable to call the columns of other tables which are in include method

Here I am attaching the sample DB and full code of my scenario

How can I accomplish this

Thanks In Advance

DataForm

answered on 30 Mar 2017

1 answer

98 views

User control inside Wizard

hi, I have a user control with multiple fields that does its own validation. What is the best practice when using it inside a Wizard. It needs to be validated when Next button is clicked, also not sure if validation message can be injected to that if the Wizard

Wizard

answered on 30 Mar 2017

0 answers

71 views

Preview single image client-side before uploading with RadAsyncUploader?

I'm finding difficulty getting enough information on the individual parts of controls and data in order to:

1) Select a single image to upload with RadAsyncUploader

2) Find the image path that is being uploaded

3) Display image from selected path using RadBinaryImage

How can I do this? Can it support Jpg, jpeg, gif, and png?

(Note: I need BinaryImage since data I get from my server can potentially provide a default image in binary array.)

BinaryImage

asked on 29 Mar 2017