How to Display information from another Database (without VB) ??

Taun Brown asked on March 18, 2014 18:59

What is the best way to show data from another database without having to use Visual Basic?

If I have the sql statement that makes the table of data I want to display but I don't have any exposure to VB coding?

Recent Answers

Brenden Kehren answered on March 19, 2014 07:06

You can use the report module to create a report. In the report you can define your SQL statement and choose your connection string. Your connection string will need to be in the web.config file. Then you can display that report on a page using the report webpart.

You could also create a new Document Type that is simply a container (vs. holding actual data) and create custom queries for everything and use the out of the box webparts. You'd have to make sure your Kentico db user has access to those other database and you're using the correct sql statements when calling the other database.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.