What new features would you like to see in the next version of SQLView?

Glad you asked!  But first let me thank you for SQLView... it's a great module and has helped me out greatly.

What I am looking for is a way to query SQL, to return one (or a few) row(s), and display that information non-tabularly.

For instance where SQLView returns a columnar view:

123  |  456  |   789

I need to had the data displayed:

123
456
789 

Now one way of doing it that I thought of would be to have the SQL query return the values as a single string with embedded html.  Seems to work, but I need to turn off the grid and column headings in SQLView... not sure if I can do that.

Anyway, thats what I am looking for.  If you can help, I appreciate it.

Again, thanks for a really useful tool!

-Dave

Dave, glad you are finding SQLView useful.

Currently there is no way to turn off the grid in the module but I will consider that for the next version. One addition that I was considering, was an xsl stylesheet option instead of a grid, so you could return xml back from SQL and display it in any format you wished using xsl. That would potentially cover off a whole range of formatting options depending on how people are using the module.

Thanks for your input

You asked for it - you got it!  Here are some things I would LOVE to see in this module.

1. Editable datagrid.  It would be great to be able to edit certain columns in the datagrid - preferably the ones that "match up" to a single field in the table (not computed columns like myCol1 + " " + myCol2.)  A google search returns many hits but so far the solutions that they suggest are above my current ability.
2. Export to Excel (or CSV.)  This is fairly simple to implement (with some caveats) using the information here.  I have added this to another datagrid module and if my meager .NET skills can be of any help I would be glad to offer it.
3. Save as PDF.  Not sure where to start on this one.  I understand that there are a couple of free or GPL PDF libraries out there but I haven't researched this yet.
4. CSS Class for header/footer.  Right now I am using a paragraph tag with a class setting for the header and footer but it would be nice to have an (optional) CSS setting for one or both of them.
5. Paging.  It would be nice to have the datagrid paging option enabled.  I am not sure how this would work with the QueryString though (my question is whether it would "pass" the url to the next page when you click "next" or "back.")

Thanks for putting together a great module and I look forward to watching it grow!

if i make select like this

select username as 'Bruger navn' from users

then the sorting dos not work becouse it tryes to sort by User name

so my request is make sort sort by the source colume name insted the displayed name

I checked into this, and it looks like there is a problem if the column name has a 'space' embedded in it. If you do this,

select username as 'Brugernavn' from users

it will sort correctly. I haven't looked to far into it yet, but it's probably because I'm not placing the fieldname into [] before I do the sorting. I'll have that fixed up in the next release.

Great module! I saw the reply where you referenced the use of xml and xsl, which may cover this. I am suggesting adding the ability to specify a css class per column. It could be as simple as a text box where column name/css name pairs can be entered with a separator between columns. i.e., username,cssName;totalAmount,cssMoney.

Cheers,

Paul

Thanks for great module. :!:

I would like to suggest a few mods that might prove useful.

1) Provide a copy or clone feature from an existing SQLView module. Helps if making several similar modules with minor differences. 

2) Provide a test query button to will return OK or the SQL Error.  This helps if you are not able to see the exception detail.

3) Provide a record count variable that could be used in the Header or Footer so that you could report the number of records that match the specific query.

4) Provide default Query values. Helps if you call the page without a expected Query Variable defined.

5) Validate that the sort field is not filled with blanks.  Seems that if the order field contains a blank, SQL will attempt to add an Order by clause to the Query. 

6) If  paging is selected and only one page is generated, then skip generating the page selection links.  Similarly, if on the first page display "Next" only or "Prev" if on the last page.

7) (added Jan 8th) Add an additional paging option to place numeric list at top and prev/next at bottom ... and the reverse. Allow the best of both worlds when unsure of amount of records returned or the amount increased over a given period.  For example in the morning you get a few rows, but by evening you have many pages... this would allow for both type of paging links.

Hopes these suggestion help

Paul.

I haven't seen anyone offering a grid that presents data in Master/Detail (Parent/Child) format. A very robust freeware grid is released at: http://www.denisbauer.com/ASPNETControls/HierarGrid.aspx 

What kind of hoops would it take to incorporate this control to DNN-based pages?

I would love to see SQLView evole into SQLEdit.

And have an editable datagrid.

I've been looking at the asp.net editable datagrid as part of the asp.net web matrix... it's over my head plus that would be outside of dnn.

So an editable datagrid dnn module would be just the ticket.:D

I would like to see some enhancements such as:

1. It would be good to have a larger text box area to enter large SQL select statements (I am referring to the amount of characters - not screen box size). It seems to be limited to 2k characters so I have to put large SQL statements in Stored Procs and then just execute the Stored proc within SQLView.

2. Select a Style template from a drop down (or just enter a name in) that groups all the element styles together instead of having to enter each time. Or maybe just have a default style name come up.

3. When a column is sorted display a small up or down arrow icon in column heading, so you can visually see when a column has been sorted.

4. Export to excel icon so a user can click on an icon to export to excel.

5. Automatically right align numeric fields in cells when displaying.

Great product!

Regards,

Duncan.

Regards,

Duncan

This module is very well written and has really saved me a lot of time and energy.  One enhancement I would like to see is to enable the import\export feature for the module content which is new for DNN 3.0.  This would allow me to easily copy the content from one portal to another without having to setup all of the module settings each time.

Thanks again!

Jim