Hi there

I'm trying to retrieve a some basic related tables using an OpenAccessLinqDatasource control. I can retrieve one table just fine, but I get stuck trying to use the Custom Grouping as described in the documentation.

Basically I would like to have this query (which works just fine in SQL), work in the DataSource on my page:

"Select custorderitems.quantity, prodmain.itemtitle from custorderitems INNER JOIN prodmain on custorderitems.fkstoreitem = prodmain.id"

I've attached screenshots of the configuration screen where I enter the Custom Select Expression etc. Using a custom expression of new(quantity) actually works, I get that column in the RadGrid. The problem comes in when I specify another context with a field.. If I add Prodmain.itemtitle, I get no data at all.

Is there perhaps a clearer guide or tutorial explaining the Custom Grouping option of the OpenAccessLinqDatasource??

Regards
JohannS

Hello,

  I am looking to block any kind copy in radeditor control like CTRL+C and Mouse Right Click and copy option.


This is basic requirement of security for clinical prospective.
Please help me to solve this issue.

Thanks.

Hi,
Greetings!

The application that I am currently working upon was using Telerik 2009 version and we upgrated the same to the latest Telerik 2014 version for ASP.Net after which one of the form containing two RadEditors got distroted. I have attached the screen shot of the form before the upgrade and the form after the upgrade for reference. Also, please refer the code below. .

<telerik:radgrid id="grdFMEAv2" runat="server" autogeneratecolumns="false" onneeddatasource="grdFMEA_NeedDataSource"
onitemdatabound="grdFMEA_OnItemDataBound" oninsertcommand="grdFMEA_InsertCommand"
ondeletecommand="grdFMEA_DeleteCommand" onitemcommand="grdFMEA_ItemCommand" onitemcreated="grdFMEA_ItemCreated"
width="98%" allowpaging="true" pagerstyle-alwaysvisible="true" allowsorting="true">
<mastertableview commanditemdisplay="Bottom" editmode="InPlace" allowsorting="true"
datakeynames="CMSFMEAID">
<Columns>
<telerik:GridEditCommandColumn UniqueName="Edit" UpdateText="Update" ButtonType="ImageButton"
CancelImageUrl="../Images/Cancel.gif" InsertImageUrl="../Images/Update.gif" UpdateImageUrl="../Images/Update.gif"
EditImageUrl="../Images/Edit.gif">
<ItemStyle HorizontalAlign="center" Width="5%"></ItemStyle>
</telerik:GridEditCommandColumn>
<telerik:GridTemplateColumn HeaderText="FMEA Type" UniqueName="FMEAType" DataField="FMEAType"
SortExpression="FMEAType" HeaderStyle-Width="12%" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<asp:Label runat="server" ID="lblFMEAType" CssClass="gridlabel" Text='<%#Eval("FMEAType")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadComboBox ID="rcbFMEATypeEdit" runat="server" DataTextField="FMEAType"
Width="80px" AutoPostBack="true" OnSelectedIndexChanged="rcbFMEATypeEdit_SelectedIndexChanged"
CssClass="normalDropDownList" Skin="Web20" MarkFirstMatch="true">
<Items>
<telerik:RadComboBoxItem runat="server" Text="" Value="" />
<telerik:RadComboBoxItem runat="server" Text="DFMEA" Value="1" />
<telerik:RadComboBoxItem runat="server" Text="PFMEA" Value="2" />
<telerik:RadComboBoxItem runat="server" Text="No FMEA" Value="3" />
</Items>
</telerik:RadComboBox>
<asp:RequiredFieldValidator ID="rfvFMEAType" runat="server" ControlToValidate="rcbFMEATypeEdit"
Display="None" SetFocusOnError="true" ErrorMessage="Please select FMEA Type"
></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="vceFMEAType" runat="server" TargetControlID="rfvFMEAType"
CssClass="AjaxValidatorCalloutExtender">
</ajaxToolkit:ValidatorCalloutExtender>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Left" Width="12%" VerticalAlign="Top"></ItemStyle>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="FMEA Name" ItemStyle-HorizontalAlign="Left"
SortExpression="FMEAName" HeaderStyle-Width="12%">
<ItemTemplate>
<asp:Label runat="server" ID="lblFMEAName" CssClass="gridlabel" Text='<%#Eval("FMEAName")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadComboBox ID="rcbFMEANameEdit" runat="server" DataTextField="FMEAName"
Width="80px" AutoPostBack="true" OnSelectedIndexChanged="rcbFMEANameEdit_SelectedIndexChanged"
CssClass="normalDropDownList" Skin="Web20" MarkFirstMatch="true">
</telerik:RadComboBox>
<asp:RequiredFieldValidator ID="rfvFMEANameEdit" runat="server" ControlToValidate="rcbFMEANameEdit"
ErrorMessage="Please select FMEA Name" Display="None" InitialValue=""></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="vceFMEAName" runat="server" TargetControlID="rfvFMEANameEdit"
CssClass="AjaxValidatorCalloutExtender">
</ajaxToolkit:ValidatorCalloutExtender>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Left" Width="10%" VerticalAlign="Top"></ItemStyle>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="FMEA Owner" DataField="FMEA Owner" ItemStyle-HorizontalAlign="Left"
SortExpression="FMEAOwnerName" HeaderStyle-Width="12%">
<ItemTemplate>
<asp:Label ID="lblFMEAOwner" runat="server" CssClass="gridlabel" Text='<%#Eval("FMEAOwnerName")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblFMEAOwnerEdit" runat="server" CssClass="gridlabel" Text='<%#Eval("FMEAOwnerName")%>'></asp:Label>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Left" Width="10%" VerticalAlign="Top"></ItemStyle>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Relevant Risk(s)" DataField="Relevant Risk(s)"
ItemStyle-HorizontalAlign="Left" SortExpression="RelevantRisk" HeaderStyle-Width="20%">
<ItemTemplate>
<div id="txtRelevantrisk" runat="server">
<%#Eval("RelevantRisk")%>
</div>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadEditor ID="txtRelevantrisk_Edit" runat="server" Font-Names="Arial" Font-Size="10pt"
Content='<%#Eval("RelevantRisk")%>' EditModes="Design" Height="200px" Width="280px"
ContentFilters="IndentHTMLContent">
<CssFiles>
<telerik:EditorCssFile Value="~/EditorContentArea.css" />
</CssFiles>
<RealFontSizes>
<telerik:EditorRealFontSize Value="8pt" />
<telerik:EditorRealFontSize Value="9pt" />
<telerik:EditorRealFontSize Value="10pt" />
<telerik:EditorRealFontSize Value="11pt" />
<telerik:EditorRealFontSize Value="12pt" />
<telerik:EditorRealFontSize Value="14pt" />
<telerik:EditorRealFontSize Value="16pt" />
<telerik:EditorRealFontSize Value="18pt" />
<telerik:EditorRealFontSize Value="20pt" />
<telerik:EditorRealFontSize Value="22pt" />
<telerik:EditorRealFontSize Value="24pt" />
<telerik:EditorRealFontSize Value="26pt" />
<telerik:EditorRealFontSize Value="28pt" />
<telerik:EditorRealFontSize Value="32pt" />
<telerik:EditorRealFontSize Value="36pt" />
<telerik:EditorRealFontSize Value="48pt" />
<telerik:EditorRealFontSize Value="72pt" />
</RealFontSizes>
<Tools>
<telerik:EditorToolGroup>
<telerik:EditorTool Name="Copy" />
<telerik:EditorTool Name="Paste" />
<telerik:EditorTool Name="Bold" />
<telerik:EditorTool Name="FontName" Text="Calibri" />
<telerik:EditorTool Name="RealFontSize" Text="12pt" />
<telerik:EditorTool Name="InsertOrderedList" />
<telerik:EditorTool Name="InsertUnorderedList" />
</telerik:EditorToolGroup>
</Tools>
<FontNames>
<telerik:EditorFont Value="Arial" />
<telerik:EditorFont Value="Arial Black" />
<telerik:EditorFont Value="Arial Narrow" />
<telerik:EditorFont Value="Calibri" />
<telerik:EditorFont Value="Comic Sans MS" />
<telerik:EditorFont Value="Courier New" />
<telerik:EditorFont Value="Georgia" />
<telerik:EditorFont Value="Lucida Console" />
<telerik:EditorFont Value="sans-serif" />
<telerik:EditorFont Value="Tahoma" />
<telerik:EditorFont Value="Times New Roman" />
<telerik:EditorFont Value="Verdana" />
</FontNames>
<Content></Content>
</telerik:RadEditor>
<asp:RequiredFieldValidator ID="rfvRelevantrisk_Edit" runat="server" ControlToValidate="txtRelevantrisk_Edit"
ErrorMessage="Please Enter Relevant Risk(s)" Display="None" InitialValue=""></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="vceRelevantrisk" runat="server" TargetControlID="rfvRelevantrisk_Edit"
CssClass="AjaxValidatorCalloutExtender">
</ajaxToolkit:ValidatorCalloutExtender>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Left" Width="20%" VerticalAlign="Top"></ItemStyle>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Mitigation Item(s)" DataField="Mitigation Item(s)"
ItemStyle-HorizontalAlign="Left" SortExpression="MitigationAction" HeaderStyle-Width="20%">
<ItemTemplate>
<div id="txtMT" runat="server">
<%#Eval("MitigationAction")%>
</div>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadEditor ID="txtMTEdit" runat="server" Font-Names="Arial" Font-Size="10pt"
Content='<%#Eval("MitigationAction")%>' EditModes="Design" Height="200px" Width="280px"
ContentFilters="IndentHTMLContent">
<CssFiles>
<telerik:EditorCssFile Value="~/EditorContentArea.css" />
</CssFiles>
<RealFontSizes>
<telerik:EditorRealFontSize Value="8pt" />
<telerik:EditorRealFontSize Value="9pt" />
<telerik:EditorRealFontSize Value="10pt" />
<telerik:EditorRealFontSize Value="11pt" />
<telerik:EditorRealFontSize Value="12pt" />
<telerik:EditorRealFontSize Value="14pt" />
<telerik:EditorRealFontSize Value="16pt" />
<telerik:EditorRealFontSize Value="18pt" />
<telerik:EditorRealFontSize Value="20pt" />
<telerik:EditorRealFontSize Value="22pt" />
<telerik:EditorRealFontSize Value="24pt" />
<telerik:EditorRealFontSize Value="26pt" />
<telerik:EditorRealFontSize Value="28pt" />
<telerik:EditorRealFontSize Value="32pt" />
<telerik:EditorRealFontSize Value="36pt" />
<telerik:EditorRealFontSize Value="48pt" />
<telerik:EditorRealFontSize Value="72pt" />
</RealFontSizes>
<Tools>
<telerik:EditorToolGroup>
<telerik:EditorTool Name="Copy" />
<telerik:EditorTool Name="Paste" />
<telerik:EditorTool Name="Bold" />
<telerik:EditorTool Name="FontName" Text="Calibri" />
<telerik:EditorTool Name="RealFontSize" Text="12pt" />
<telerik:EditorTool Name="InsertOrderedList" />
<telerik:EditorTool Name="InsertUnorderedList" />
</telerik:EditorToolGroup>
</Tools>
<FontNames>
<telerik:EditorFont Value="Arial" />
<telerik:EditorFont Value="Arial Black" />
<telerik:EditorFont Value="Arial Narrow" />
<telerik:EditorFont Value="Calibri" />
<telerik:EditorFont Value="Comic Sans MS" />
<telerik:EditorFont Value="Courier New" />
<telerik:EditorFont Value="Georgia" />
<telerik:EditorFont Value="Lucida Console" />
<telerik:EditorFont Value="sans-serif" />
<telerik:EditorFont Value="Tahoma" />
<telerik:EditorFont Value="Times New Roman" />
<telerik:EditorFont Value="Verdana" />
</FontNames>
<Content></Content>
</telerik:RadEditor>
<asp:RequiredFieldValidator ID="rfvMitigationAction" runat="server" ControlToValidate="txtMTEdit"
ErrorMessage="Please Enter Mitigation Action(s)" Display="None" InitialValue=""></asp:RequiredFieldValidator>
<ajaxToolkit:ValidatorCalloutExtender ID="vceMT" runat="server" TargetControlID="rfvMitigationAction"
CssClass="AjaxValidatorCalloutExtender">
</ajaxToolkit:ValidatorCalloutExtender>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Left" Width="20%" VerticalAlign="Top"></ItemStyle>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="URL" DataField="URL" ItemStyle-HorizontalAlign="Left"
HeaderStyle-Width="10%">
<ItemTemplate>
<asp:HyperLink ID="hplnkURL" runat="server" Text="View FMEA here" NavigateUrl='<%#Eval("URL")%>'
Target="_blank" ForeColor="Blue"></asp:HyperLink>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtURL" Text='<%#Eval("URL")%>' CssClass="textboxCalibri"></asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Left" Width="15%"></ItemStyle>
</telerik:GridTemplateColumn>
<telerik:GridButtonColumn UniqueName="Delete" CommandName="Delete" ButtonType="ImageButton"
ImageUrl="..\Images\delete.gif" ConfirmText="Do you want to delete this row?">
<ItemStyle HorizontalAlign="Left" Width="4%"></ItemStyle>
</telerik:GridButtonColumn>
</Columns>
<ItemStyle VerticalAlign="Top" />
<ItemStyle CssClass="gridlabel" />
<AlternatingItemStyle CssClass="gridlabel" />
<HeaderStyle CssClass="gridlabel" />
<CommandItemSettings RefreshText="" ShowRefreshButton="false" AddNewRecordImageUrl="../Images/AddRecord.gif" />
<NoRecordsTemplate>
No Records to display.</NoRecordsTemplate>
</mastertableview>
</telerik:radgrid>
 

Hi,

Is is possible to create cue points in a video file using Telerik Media Player? I have a requirement to integrate media player in a webpage and to create a XML file which defines cue points with time interval. At the time of playing video file using media player it will take the cue points from XML file and create cue points in the video player and links as shown in attached image. 

Please help me to achieve this feature. Thank you .

Hello,

I have the following questions about the view of imported RTF or DOCX documents inside the editor:

1. Is there a possibility to show page information (current page number) and page separations like in Word?

2. Is there a possibility to show/edit header and footer of documents like in Word? When I tried to import RTF or DOCX files, header and footer got completely lost and were not displayed in the editor.

Thanks,
Felix

Hi,

I am using 2014.3.1024.40 of the ASP.NET for AJAX Controls.

I have a chart with a stacked ColumnSeries.

I want to be able to click on any of the columns and display a new browser window with additional information about that specific point in the series.  I figure I could easily do that in the OnSeriesClick event handler in javascript.  I could do a window.open with a URL to the aspx page I want to display.

I see that the args that are passed to the OnSeriesClick event can give me things like the value and category of that series point.

But I need to pass an ID that I can use as a querystring parameter in the URL I will build in the OnSeriesClick event handler function.

So, is there a way to add additional "context" information to the series, so that I can read and use it in the OnSeriesClick event handler function?

Adding context like this is the type of thing that can be done with your treeview control, so that with that control, for instance, you can then pass the context information to a web service to populate the node with a web service...

Or is there a different way to do this with the HTMLChart control?

Thanks,
Michael

Hi there.

I have a rad grid with a detail table and I want to have the master row expand (to show the details) when a master row is selected. What is the best way to do this?

Thanks, Mike

Hi..

I have a radgrid with a column that I'm entering a reference number that I wish to use to extract a corresponding row value. This reference value is not required to be stored so I only need to access the entry whilst the cells are in edit mode (red updated symbol) I wish to use the extracted value to plot a route via google maps.. and the reference will be a number corresponding to the waypoint order. How can I extract a list of strings of postcode column based on numerical value / null value in map column.

<telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowPaging="True" PageSize="10" EnableViewState="True"
        AutoGenerateColumns="False" OnNeedDataSource="RadGrid1_NeedDataSource" OnItemUpdated="RadGrid1_ItemUpdated"
        OnItemDeleted="RadGrid1_ItemDeleted" OnItemInserted="RadGrid1_ItemInserted" OnDataBound="RadGrid1_DataBound"
        OnItemCommand="RadGrid1_ItemCommand" OnItemDataBound="RadGrid1_ItemDataBound"
        CellSpacing="0" Skin="Windows7">
           <PagerStyle Mode="NextPrevAndNumeric" />
        <MasterTableView Width="100%" CommandItemDisplay="TopAndBottom" DataKeyNames="ID, PK"
            HorizontalAlign="NotSet" AutoGenerateColumns="False" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
11                 AllowAutomaticUpdates="False" EditMode="Batch">
            <BatchEditingSettings EditType="Cell" />
            <Columns>
                <telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name"
                    UniqueName="Name" ColumnEditorID="GridTextBoxColumnEditorEditor1">
                </telerik:GridBoundColumn>
                <telerik:GridHyperLinkColumn DataNavigateUrlFields="Postcode" HeaderText="Location" SortExpression="Location"
                    DataTextField="Location" UniqueName="Location" DataNavigateUrlFormatString="http://maps.google.co.uk/maps?q={0}">
                </telerik:GridHyperLinkColumn>
                <telerik:GridNumericColumn DataField="Map" HeaderText="Map" SortExpression="Map"
                    UniqueName="Map" Display="false" ColumnEditorID="GridTextBoxColumnEditorMap">
                </telerik:GridNumericColumn>
                <telerik:GridBoundColumn DataField="Sample" HeaderStyle-Width="300px" HeaderText="Equipment" SortExpression="Sample"
                    UniqueName="Equipment" ColumnEditorID="GridTextBoxColumnEditorEditor3">
                </telerik:GridBoundColumn>>
                <telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow"
                    ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"
                    UniqueName="Delete">
                    <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton" />
                </telerik:GridButtonColumn>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>

protected void rut_Click(object sender, EventArgs e)
        {
          string v;
           foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
           {
               if (item.FindControl("Map") != null)
               {
                   v = (item.FindControl("Map") as TextBox).Text;
               }
           }

            ClientScript.RegisterStartupScript(this.GetType(), "yourMessage", "alert('" + v + "');", true);
        }

Hi.

I have a scenario where a customer needs to upload to Amazon S3 a zip of files (it will contain a folder structure too) and then extract all the files and honour the folder structure too. It’s similar to this demo but that demo doesn’t use RadCloudUpload. The problem is that the zip file may be hundreds of MBs in size and it will always be to S3 so we need to use RadCloudUpload. 

Furthermore, as they are uploaded we need to enter the file and folder details in to a database table, and associate a few more custom fields to each file like a guid, tenantID, uploadedBy etc. Then we want to use RadFileExplorer to browse the files and custom fields similar to this demo. 

Is this possible? Any suggestions would be greatly appreciated.

Thanks in advance.

Chris

I have a radeditor control with the RealFontSize dropdown   

There are only 2 values available 24pt and 18pt


However, what is displaying in the text of the closed dropdown is either 32px or 24px.  (See attached image).  The client is distressed because the display is showing pixels and not points.   How do I get the closed dropdown to show the actual value of either 24 or 18 pt?  

The client area content returned to the sever has the value in points.    



  function OnClientLoad2(editor, args) {
           var style = editor.get_contentArea().style;
           style.color = '#636466';
    

       }


 <telerik:RadEditor ID="RadEditor2" runat="server" Height="75px"  Width="100%"  StripFormattingOnPaste="MSWord, MSWordNoFonts, MSWordRemoveAll, Css, Font, Span"
                                    StripFormattingOptions="MSWord, MSWordNoFonts, MSWordRemoveAll, Css, Font, Span" OnClientLoad="OnClientLoad2"
           Skin="Default" EditModes="Design">
                                <RealFontSizes>
                                <telerik:EditorRealFontSize Value="24pt" />
                                <telerik:EditorRealFontSize Value="18pt" />
                                </RealFontSizes>
                                     <Tools>
                                      <telerik:EditorToolGroup>
                                        <telerik:EditorTool Name="Save" Text="Save" />
                                        <telerik:EditorTool Name="Cancel" Text="Cancel" />
                                        
                                        <telerik:EditorSeparator />
                                        <telerik:EditorTool Name="Cut" />
                                        <telerik:EditorTool Name="Copy" />
                                        <telerik:EditorTool Name="Paste" />
                                        <telerik:EditorSeparator />
                                        <telerik:EditorTool Name="Undo" />
                                        <telerik:EditorTool Name="Redo" />
                                        <telerik:EditorSeparator />
                                        <telerik:EditorTool Name="InsertSymbol" />
                                      </telerik:EditorToolGroup>
                                      <telerik:EditorToolGroup>
                             
                                                    <telerik:EditorTool Name="RealFontSize" />                           

                                        <telerik:EditorSeparator />
                                        <telerik:EditorTool Name="JustifyLeft" />
                                        <telerik:EditorTool Name="JustifyRight" />
                                        <telerik:EditorTool Name="JustifyCenter" />
                                   
                                        <telerik:EditorTool Name="JustifyNone" />
                                      </telerik:EditorToolGroup>
                                      <telerik:EditorToolGroup>
                               
                                 
                                  
                                       
                                        <telerik:EditorTool Name="AjaxSpellCheck" Text="Spell Check" />

                                     <telerik:EditorTool Name="ResetContent" Text="Clear"/>

                                      </telerik:EditorToolGroup>
                                    </Tools>
                                    <Content>
                                    
</Content></telerik:RadEditor>