Telerik Forums
Community Forums Forum
0 answers
581 views

Hi,

I know this product is retired since long ago.

But in our 10 years old legacy code, we have now requirement to migrate few tables in MySQL from SQL server. This old code is using Telerik.OpenAccess Nuget version 2016.2.822.1 and there is complex business logic written using it.

It is hard to change that bulk of code to use Entity Framework, so we thought to use My SQL connector with Telerik ORM as explained here https://docs.telerik.com/data-access/developers-guide/database-specifics/database-specifics-mysql-overview

I've everything setup as per the Article above. But when I run this code, it throws error which says Connection option 'datasource' is duplicated.

The connection string is perfectly fine and nothing duplicated in it: DataSource=127.0.0.1;port=3306;database=dbname;user=root;password=******

In fact, anything I change in connection string, it complains with same kind of error. For example Server=127.0.0.1;port=3306;database=dbname;user=root;password=******

It shows Connection option 'Server' is duplicated.

Kindly please help if you have used Telerik ORM with MySQL previously.

Aron
Top achievements
Rank 2
 asked on 23 Jun 2021
0 answers
4 views

Inside Adobe PDF viewer, for a PDF that exported from my Kendo App Grid, 
the DOCUMENT PROPERTIES says: 

PDF Producer: Kendo UI PDF Generator
PDF Version 1.4

Is this the latest?

jaymer
Top achievements
Rank 1
 asked on 20 Jun 2024
15 answers
261 views

Hello,

Although Telerik is awesome I wish to delete my Telerik account, Telerik Forums account and all of the data associated with this account. Please help me out with this.

 

Thanking You,

With Regards,

Subhadeep Bhattacharyya.

6 answers
49 views
Hello!

I would like to know how to delete the telerik user account I had to create in order to download a trial version a while ago. Unfortunately, I couldn't find any hints on how to do this. :-( Maybe someone here can help me to remove the account?

Any help appreciated.
Thanks in advance!
Jennifer
Telerik team
 answered on 10 Jun 2024
0 answers
10 views

Hi we're receiving this error regarding Kendo.Core.Export.dll however the DLL is present. Any ideas? There are similar issues here in the Community Forums however we have yet to discover a solution.

 

Line 18 in Program.cs:

builder.Services.AddControllersWithViews()

 

Complete exception message:

Application: w3wp.exe
CoreCLR Version: 8.0.424.16909
.NET Version: 8.0.4
Description: The process was terminated due to an unhandled exception.
Exception Info: 
Application '/LM/W3SVC/2/ROOT/appname' with physical root 'C:\webapplications\appname\06072024\' hit unexpected managed exception, exception code = '0xe0434352'. First 30KB characters of captured stdout and stderr logs:
Unhandled exception. System.IO.FileNotFoundException: Could not load file or assembly 'Kendo.Core.Export, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified.
File name: 'Kendo.Core.Export, Culture=neutral, PublicKeyToken=null'
   at System.Reflection.RuntimeAssembly.<InternalLoad>g____PInvoke|49_0(NativeAssemblyNameParts*, ObjectHandleOnStack, StackCrawlMarkHandle, Int32, ObjectHandleOnStack, ObjectHandleOnStack)
   at System.Reflection.RuntimeAssembly.InternalLoad(NativeAssemblyNameParts*, ObjectHandleOnStack, StackCrawlMarkHandle, Boolean , ObjectHandleOnStack, ObjectHandleOnStack)
   at System.Reflection.RuntimeAssembly.InternalLoad(AssemblyName, StackCrawlMark&, AssemblyLoadContext , RuntimeAssembly , Boolean )
   at System.Reflection.RuntimeAssembly.InternalLoad(String, StackCrawlMark&, AssemblyLoadContext )
   at System.Reflection.Assembly.Load(String)
   at Microsoft.AspNetCore.Mvc.ApplicationParts.ApplicationPartManager.<>c.<GetApplicationPartAssemblies>b__8_0(ApplicationPartAttribute name)
   at System.Linq.Enumerable.SelectArrayIterator`2.Fill(ReadOnlySpan`1, Span`1, Func`2)
   at System.Linq.Enumerable.SelectArrayIterator`2.ToArray()
   at System.Linq.Buffer`1..ctor(IEnumerable`1)
   at System.Linq.OrderedEnumerable`1.GetEnumerator()+MoveNext()
   at System.Linq.Enumerable.SelectManySingleSelectorIterator`2.MoveNext()
   at System.Linq.Enumerable.ConcatIterator`1.MoveNext()
   at Microsoft.AspNetCore.Mvc.ApplicationParts.ApplicationPartManager.PopulateDefaultParts(String)
   at Microsoft.Extensions.DependencyInjection.MvcCoreServiceCollectionExtensions.GetApplicationPartManager(IServiceCollection, IWebHostEnvironment)
   at Microsoft.Extensions.DependencyInjection.MvcCoreServiceCollectionExtensions.AddMvcCore(IServiceCollection)
   at Microsoft.Extensions.DependencyInjection.MvcServiceCollectionExtensions.AddControllersCore(IServiceCollection)
   at Microsoft.Extensions.DependencyInjection.MvcServiceCollectionExtensions.AddControllersWithViewsCore(IServiceCollection)
   at Microsoft.Extensions.DependencyInjection.MvcServiceCollectionExtensions.AddControllersWithViews(IServiceCollection)
   at Program.<Main>$(String[]) in C:\AppName\Program.cs:line 18

Alex
Top achievements
Rank 1
 asked on 07 Jun 2024
1 answer
13 views

I am trying to maintain a pre-existing piece of software that uses Telerik Data Access for data access and also Telerik Kendo on the frontend. Several Kendo grids in the software represent tables in the database, except in order to be more user-friendly, instead of displaying foreign keys, they display the Display Names of the objects those foreign keys represent.

In order to fill the grid, then, the data call made by the UI might look something like this:

[root]/DataServices/[tenant]/odata/HouseModels?%24format=json&%24top=100&%24count=true&%24expand=DoorStyle(%24select%3DID%2CDisplayName)%2CWindowStyle(%24select%3DID%2CDisplayName)%2CDeckStyle(%24select%3DID%2CDisplayName)%2CFinishStyle(%24select%3DID%2CDisplayName)

This works fine in all ways except one: if a foreign key column is nullable and the user sorts or filters on that column, all rows that have a null value in that column will disappear. (Ironically, this even happens if the user filters specifically to show only null values! They will always see no results!)

I personally don't care whether null values are sorted before or after non-null values, but entire rows should never disappear entirely just from sorting (or in a way that makes zero sense for a particular filter).

[Note: The 'HouseModels' thing above is just an example. My data has nothing to do with houses, so yes, it does make sense to have nullable FKs.]

Using SQL Profiler, I believe I have determined the Data Access behaviour that is causing this problem. When the user tries to apply a sort or filter, the first call received by the database will look something like this if the user sorts the 'Door Style' column:

SELECT  TOP(100)
a.[ID] AS COL1,a.[FinishStyleID] AS COL2,a.[DoorStyleID] AS COL3,
a.[WindowStyleID] AS COL4,a.[DeckStyleID] AS COL5,
(CASE WHEN a.[DoorStyleID] IS NULL THEN NULL
    ELSE b.[DisplayName] END)
AS xj1
FROM [HouseModels] a
JOIN [User DoorStyles] AS b
ON (a.[DoorStyleID] = b.[ID])
/*permissions-related SQL omitted*/
ORDER BY xj1 DESC

From what I can tell, the results of this first call determine what rows will be visible in the grid, because the subsequent data calls are to fulfill all of the 'expand' requirements for all the IDs in the result of that first call.

As you can see, this means the problem is in the "JOIN" in the first call. Whether the user is filtering or sorting, that JOIN will always be on the column being sorted or filtered. Due to that being a "JOIN" instead of a "LEFT JOIN", all rows with a null value in that column are completely omitted from the results.

Is there any way that I can change this to be a LEFT JOIN? I don't know how to configure or override that part of what Data Access is doing.

[Note: At this time, we have to keep using Data Access. Completely replacing that is way beyond the scope of this small bug I am trying to fix.]

Matt
Top achievements
Rank 1
Iron
 answered on 06 Jun 2024
2 answers
34 views
As stated, please delete this Telerik account completely. There is no functionality in your Telerik Account Overview page to do this.
Jennifer
Telerik team
 answered on 04 Jun 2024
1 answer
17 views

Yes, you can add watermarks to your PDF Files. Use the PDF Watermark application to recognize your PDFs as a logo, image, or text. The tool can watermark your PDF File at one time on every Page of the PDF file. The tool's Best feature is customized watermarks of your choice and some multiple-time increases of the opacity level from lighter to darker and darker to lighter. The tool permits enough flexibility in setting position to the top, left, right, center, and middle. The software is a user-friendly application that a non-technician can understand and operate without technical help. Download the tool today.


Dess | Tech Support Engineer, Principal
Telerik team
 answered on 03 Jun 2024
1 answer
14 views
In our WPF project, we have an issue with the Telerik data grid that,
> We have implemented a cell style for setting the background colour based on condition by using the MultiValue Converter,

 

Style code:

<Style x:Key="AFLinkCellFGStyle" TargetType="telerik:GridViewCell" BasedOn="{StaticResource {x:Type telerik:GridViewCell}}">
                <Style.Resources>
                <local:AFCellLinkFGConverter x:Key="AFCellLinkFGConverter"/>
                </Style.Resources>
                <Setter Property="Background"> 
                    <Setter.Value>
                    <MultiBinding Converter="{StaticResource AFCellLinkFGConverter}">
                        <Binding RelativeSource="{RelativeSource Self}"/>
                        <Binding />
                    </MultiBinding>
                    </Setter.Value>
                </Setter>
                <Style.Triggers>
                    <Trigger Property="IsSelected" Value="True">
                        <Setter Property="Foreground" Value="Black"/>
                        <Setter Property="FontWeight" Value="ExtraBold"/>
                    </Trigger>
                </Style.Triggers>
            </Style>

 

Converter code:

 public object Convert(object[] values, Type targetType, object parameter, CultureInfo culture)
        {
            if (values[1] is ArcFlashEvalRecord)
            {
                Efx.Assert(values[1] is ArcFlashEvalRecord && (values[1] as ArcFlashEvalRecord).pData != null, "FIX THIS - expecting ArcFlashEvalRecord and ArcBusData");
                GridViewCell cell = values[0] as GridViewCell;
                ArcFlashEvalRecord record = values[1] as ArcFlashEvalRecord;
                GridViewColumn column = cell.Column;
                if (column != null)
                {
                    AF_FieldType field_type = (AF_FieldType)column.GetValue(AttachedProp.TagProperty);
                    return AFCellInfo.GetCellInfo(field_type, record).BgBrush;
                }
            }
            return null;
        }

 

Issue: The issue is the background colour is not set properly for each cell.


Description: Initially the data is loaded and the Telerik data gets rendered in the display, we have more than 10 columns, and some of the last columns are hidden. Initially, the background colour worked properly for all cells. but when we horizontally scroll to the end of the data grid to see the hidden columns, at that time, the background of the cell is not set properly, it randomly sets the background colour for hidden column cells. it's changing every time we scroll.

Stenly
Telerik team
 answered on 31 May 2024
0 answers
9 views

Hi everyone!.

Im trying to put a "NumericTextBox" inside s "ForItem", cause i need extract some validation that i have in another file. and call some method that returns me a math result But when i try it, my proyect fails.

 

someone have  worked with something similar?

Jurgen
Top achievements
Rank 1
 updated question on 29 May 2024
Narrow your results
Selected tags
Tags
+? more
Top users last month
Patrick
Top achievements
Rank 1
Iron
Iron
Iron
MIS
Top achievements
Rank 1
Ross
Top achievements
Rank 1
Marcin
Top achievements
Rank 1
Iron
Iron
Sean
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Patrick
Top achievements
Rank 1
Iron
Iron
Iron
MIS
Top achievements
Rank 1
Ross
Top achievements
Rank 1
Marcin
Top achievements
Rank 1
Iron
Iron
Sean
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?