Telerik Forums
Community Forums Forum
1 answer
85 views
 I am attempting to incorporate a data source parameter and a report parameter to create a parameterized query. I am certain my report parameter has values and can pass the correct value and data type I went (I create a text box to display the report parameter value and it did so correctly. However, the moment I then change my SQL query to include the parameter and then make the data source parameter equal to the value of my report parameter it does not work as intended.  Once I set the data source parameter value equal to the report parameter value and hit preview all available parameter value options disappear and nothing loads. 
Momchil
Telerik team
 answered on 26 Feb 2024
0 answers
224 views

Hello there.

I'm presently working on a Node.js project that uses Telerik and MongoDB with Mongoose for database operations, however I'm having trouble quickly implementing CRUD (Create, Read, Update, Delete) actions. I'm hoping to receive some ideas and advice from the community to help us overcome these obstacles and enhance our database interactions.

Scenario Overview:

In our Telerik-based Node.js application, we use MongoDB as our database solution, with Mongoose as the MongoDB object modeling tool. Our application manages a variety of entities and data collections, and we must use CRUD operations to create, read, update, and remove data entries in MongoDB.

The code sample below demonstrates our current method to implementing CRUD operations using Mongoose and MongoDB in our Telerik Node.js application. Take a look, and let's go into the complexities of database interactions using Mongoose and MongoDB.


// Sample code demonstrating CRUD operations with Mongoose and MongoDB in Telerik
const mongoose = require('mongoose');

// Connect to MongoDB database
mongoose.connect('mongodb://localhost:27017/mydb', { useNewUrlParser: true, useUnifiedTopology: true });
const db = mongoose.connection;

// Define Mongoose schema and model
const userSchema = new mongoose.Schema({
    name: String,
    email: String,
    age: Number
});

const User = mongoose.model('User', userSchema);

// CRUD operations
// Implement CRUD operations using Mongoose model methods
// ...

Key Points of Concern:

Model Schema Design: Creating effective Mongoose schemas to describe our data models and build relationships among distinct things in the MongoDB database. How can we optimize our schema design to maintain data consistency and integrity while allowing for complicated data structures?

Implementing CRUD operations (Create, Read, Update, and Delete) with Mongoose to interface with MongoDB collections. How can we simplify the implementation of CRUD procedures to ensure speedy and error-free database interactions?

Data validation and error handling: Putting in place measures to assure data integrity and prevent incorrect data from being put into the database. How can we apply data validation rules and gracefully manage mistakes during CRUD operations?

Performance optimization entails optimizing database queries and processes to increase performance and scalability, as described in the documentation. How can we use Mongoose query optimization and MongoDB indexing algorithms to improve the speed of CRUD operations in our Node.js application?

Let's work together to overcome these CRUD operations difficulties!

Thanks

jhonson
Top achievements
Rank 1
Iron
Iron
 asked on 25 Feb 2024
0 answers
153 views

I have a TelerikEditor and I have also a List-View, I want to insert in the TelerikEditor what is selected from List-View, similar to the Knedu-ui Editor. Is there any way to do this?

 

https://demos.telerik.com/kendo-ui/editor/snippets?_ga=2.185885487.768973806.1708748600-1556274050.1704398428&_gac=1.79606246.1707819915.Cj0KCQiAw6yuBhDrARIsACf94RW6QB0GISn8O6M41zw6097jzfLc0Pa7m07eijHkyh0eA-nEwbj6dVEaAr5LEALw_wcB&_gl=1*55bc3c*_ga*MTU1NjI3NDA1MC4xNzA0Mzk4NDI4*_ga_9JSNBCSF54*MTcwODc0ODU5OS4yNS4xLjE3MDg3OTQzNzUuMS4wLjA.*_gcl_aw*R0NMLjE3MDc4MTk5MTUuQ2owS0NRaUF3Nnl1QmhEckFSSXNBQ2Y5NFJXNlFCMEdJU244TzZNNDF6dzYwOTdqemZMYzBQYTdtMDdlaWpIa3loMGVBLW5Fd2JqNmRWRWFBcjVMRUFMd193Y0I.*_gcl_dc*R0NMLjE3MDc4MTk5MTUuQ2owS0NRaUF3Nnl1QmhEckFSSXNBQ2Y5NFJXNlFCMEdJU244TzZNNDF6dzYwOTdqemZMYzBQYTdtMDdlaWpIa3loMGVBLW5Fd2JqNmRWRWFBcjVMRUFMd193Y0I.*_gcl_au*MjAxMzkxMjIyNi4xNzA0Mzk4NDI3

Sua
Top achievements
Rank 1
 asked on 24 Feb 2024
0 answers
91 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,

Missing User
 asked on 21 Feb 2024
0 answers
71 views

你好!

我想知道如何删除我不久前为了下载试用版而必须创建的 telerik 用户帐户。不幸的是,我找不到任何关于如何做到这一点的提示。

任何帮助表示赞赏。
提前致谢!

asd
Top achievements
Rank 1
 asked on 20 Feb 2024
0 answers
74 views

I'm currently fine-tuning a project that involves MySQL and Telerik, and I've hit a roadblock when it comes to understanding the nuances between CHAR and VARCHAR. Specifically, I'm interested in how these choices may impact UI development with Telerik controls. Can someone help me decode these intricacies?

Let's start by sharing a CodeIgniter model snippet and MySQL table structure:


class Customer_model extends CI_Model {
    public function add_customer($customer_id, $customer_name, $email) {
        $data = array(
            'customer_id' => $customer_id,
            'customer_name' => $customer_name,
            'email' => $email
        );

        $this->db->insert('customers', $data);
        return $this->db->insert_id();
    }
}



CREATE TABLE customers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id CHAR(8),
    customer_name VARCHAR(50),
    email VARCHAR(255)
);

Question 1: CHAR vs. VARCHAR in MySQL
I've opted for CHAR(8) for customer_id and VARCHAR(50) for customer_name. Could someone shed light on the primary distinctions between CHAR and VARCHAR in MySQL, particularly concerning storage efficiency and how these choices might influence Telerik controls used in UI development?

Question 2: Telerik and MySQL Integration
Considering Telerik controls in the UI development landscape, are there specific considerations when working with VARCHAR fields like customer_name or email in MySQL? How do these considerations align with best practices for Telerik UI components, and are there potential pitfalls to be mindful of during integration?

Question 3: Effective Data Handling using Telerik.
In the context of data transmission between MySQL and Telerik, as seen here, how does the decision between CHAR and VARCHAR affect the effectiveness of data retrieval or processing within Telerik controls? Are there any ideas or best practices for managing variable-length fields in Telerik UI components?

Question 4: The impact on Telerik Grids and Forms.
Finally, when developing Telerik Grids or Forms, how do the MySQL data types used effect the layout, performance, and validation? Are there any special obstacles or benefits to using CHAR or VARCHAR fields in MySQL when working with Telerik UI components?

Your expertise on these questions will be invaluable as I strive for a seamless integration of MySQL data and Telerik controls in my UI development. Thanks a bunch for sharing your insights!

jhonson
Top achievements
Rank 1
Iron
Iron
 asked on 30 Jan 2024
1 answer
93 views

how to set ragdgridview row numbers in the highlighted cells ,tried RowIndicatorVisibility="Visible" but not working in c#

 

Dimitar
Telerik team
 answered on 26 Jan 2024
0 answers
93 views

Hello,

As per your documentation and example - https://docs.telerik.com/blazor-ui/components/multiselect/overview - if a user enters a text to filter the items from a multiselect list, then text will disappear as soon as the user clicks away from the multiselect box.

However, I've implemented the same functionality in my project, but for whatever reason the text still persists when I click away from the box. 
Please see my code below:



<TelerikMultiSelect Data="@ClientNames"
                    @bind-Value="@ClientValues "
                    Placeholder="ALL"
                    Filterable="true"
                    ClearButton="true" AutoClose="false">
</TelerikMultiSelect>

@code{

       List<string>? ClientNames { get; set; } = new() {"John",  "Elena" , "Michael" };

       List<string>? ClientValues { get; set; } = new();
}

 Please screenshot attached (Screenshot 2024-01-11 124224.png).

The behaviour is the same in Microsoft Edge and Google Chrome.

Please advise.

Many thanks,

Astig

 

n/a
Top achievements
Rank 1
Iron
Iron
Iron
 updated question on 11 Jan 2024
1 answer
91 views

Hi ,

We are evaluating Telerik Reporting for our .NET 8 ERP application.

Could you please provide Win UI3 Example with Binding ObjectDataSource where Report is embedded in to the winui3 sample and bind local dto object and render also locally .

We tried from our end but  unable to use  binding ObjectDataSource.

We have attached sample for your reference.

 

 

Todor
Telerik team
 answered on 10 Jan 2024
0 answers
97 views
I want to convert a numeric to string using = CStr(Sum(Fields.CURYEXTCOST).  Example: $123,000 ->  one Hundred and twenty three thousand. 
George
Top achievements
Rank 1
 asked on 08 Jan 2024
Narrow your results
Selected tags
Tags
+? more
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?