Connect data

Radzen Studio Angular
1

Hello,
what is the best way, to connect data from different tables in my database to one table in my radzen application?

Thank You!

2

Hi,

The easiest way will be to create view or stored procedure in your database, infer the Radzen app data source to get the new view/stored procedure and use this view/stored procedure to populate DataGrid:

image
image.png1728×972 83 KB

image
image.png1920×1080 149 KB

image
image.png1920×1080 182 KB

image
image.png1920×1080 184 KB

Best Regards,
Vladimir

3

@enchev But doesn't that mean, that the changes i make with my data aren't updated in my database?

4

I'm afraid that I don't understand your question.

5

@enchev I want to build an application with which i can update the data in my database. I want that the different tables from my database become one table in the application.

6

To update, delete and add new records to data returned from joined tables/views/stored procedures you need to write custom code or call for example stored procedure(s) that will perform the update,add or delete.

7

ok thank you i will try