Manage database tables through Kentico CMS UI

Anju S asked on February 3, 2016 11:13

Hi,

I have a Kentico Database and source code of a project. I can see a 'document type' say "Food" in CMS and a Database table for "Food" document type. I can see the contents of the 'Food' table in my one webpart.

I am expecting a default option on Ketico to manage (List, Add, Update & Delete) a document type 'item' on CMS UI. I am a beginner on Kentico framework, So please help me to find out a solution for this as soon as possible.

Recent Answers

Brenden Kehren answered on February 3, 2016 15:14

Depending on what version you're using it will be different. In v7 and earlier you will go to the CMSDesk and manage your pages in the Content Tree. In v8 and newer, you'd go to the Pages app and manage your pages in the content tree.

The short of the story is Document Types or Page Types make up your actual pages or nodes in your content tree. They have several tables joined to them to make up an actual page. So managing the Food table through SQL Server Management Studio is not a feasible option because of the several relationships it has with other tables.

You might want to start out with the basics of Kentico using this tutorial.

0 votesVote for this answer Mark as a Correct answer

Joshua Adams answered on February 3, 2016 15:17

Another thing along with what Brenden said, is that you may be able to use the contribution list for a simple create, read, update, and delete. Try to place the contribution list webpart on a page, and set the page type to your food page type. Just see what that does and hopefully that gets you close to what you want. Otherwise, let us know what exactly you need.

1 votesVote for this answer Mark as a Correct answer

Anju S answered on February 4, 2016 07:49

Thanks for the reply.

Is there any way to manage the database tables (Tables created during Document Types and Custom Table creation) from Kentico CMS UI by Global Administrator?

We can find option in Kentico UI to manage Views and Stored Procedure in version 8.2. Is there any option to manage tables also?

0 votesVote for this answer Mark as a Correct answer