The List module- need to show SQL resultset from a query
Last Post 08/19/2014 9:01 PM by Joseph Craig. 1 Replies.
Author Messages
Wha? Cafe
Posts:


--
08/19/2014 1:01 PM  
I have inserted a List module inside a pane on a page, I need to show five items from a table in my database , they would be headers from news stories, I have the correct SQL query to use, what is the best way inside DNN 6 to insert into a simple list module . I am used to using a an asp.net web form datalist , having it bound in codebehind to a datasource and displaying it that way.
Cheers
Wha
Joseph Craig
DNN MVP
Posts:11667


--
08/19/2014 9:01 PM  
Do you mean the "Form and List" module?

I would actually recommend the SGSV module from tressleworks.ca. It's not free, but it is so cheap that is is effectively free. And, it is a superb module.

You would use it to run the appropriate SQL query to return the list data. Then, build a template for the module to display the list. And, there are a ton of options.

Joe Craig, Patapsco Research Group
Complete DNN Support


---