SQLView - Free DotNetNuke Module > DNN Stuff - Quality DotNetNuke Modules, Unrivaled Support

View Article

Current Articles | Categories | Search | Syndication

Thursday, June 10, 2004

SQLView - Free DotNetNuke Module
By Richard Edwards @ 12:16 AM :: 1268 Views :: 4 Comments ::

:: DNNStuff

SQLView is a free, easy to use module that allows you to display the results of any SQL query in tabular format.

compatible with DotNetNuke 2.0.0+
uses new data provider model
specify sql query as a select from a table, view or stored procedure
sorting ascending/descending on each column
customizable formatting for the grid, header row, even row and odd row
display an additional header comment

You must register to download the free SQLView DotNetNuke module.

Comments

By andreas kviby @ Friday, June 18, 2004 5:38 PM

I would appreciate a quick how-to guide on how to get the most out from the DNN system with this superb module. I have already built latest ads from classifieds, most viewed pages but I am still looking for two things;

1. How to add a string before the resulting field data like;

The result we get is for example TabName Home and TabID 1 and I want the sql view to reformat it with the AS parameter to a linked Home label to the right page. Is this possible in SQL?

2. I would like to see this module take in arguments from the querystring parameter and also be able to insert UserID, PortalID and so on inside the SQL statements...

Andreas Kviby
Author of DNF RedirectPro, DNF Dropbox and DNF RandomHTML
www.dotnetfriends.com

By Richard Edwards @ Sunday, June 20, 2004 8:31 AM

You should be able to do that in the follow way:

select '< a href=''default.aspx?tabid=' + CAST(TabID AS varchar) + '''>' + TabName + '< /a>' AS Tab from tabs

By Richard Edwards @ Sunday, June 20, 2004 8:32 AM

I like those other ideas as well. I'll try and put them into my next release. I'm adding some simple charting functionality at the moment.

- Richard

By mike bill @ Monday, August 08, 2005 5:14 PM

Error: DNNStuff - SQLView is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Request failed. ---> System.Security.SecurityException: Request failed. at DNNStuff.SQLView.SQLView.RetrieveData(String QueryText) at DNNStuff.SQLView.SQLView.BindGrid() --- End of inner exception stack trace ---

I am using the same SQL with other appps so I need some help to figure this one out.

Click here to post a comment