By host on Sunday, January 29, 2006 12:48 PM

I was advised by a user of SQLGridSelectedView (thanks Roy Dean) that column sorting did not function when using column formatting - the latest feature to be added to SQLGridSelectedView.

Sure enough - the initial page would display, but clicking on a column to sort would result in an empty display.  Simply put, the OnSortCommand was not firing. In the case of column formatting, SQLGridSelectedView turns off the AutoGenerateColumns property and must create the column structure manually. A quick check of the forums confirmed my oversite of not providing the SortExpression on the columns.   Simple. 20 miuntes -  Added one line of code and done -- Not so fast - still didn't work ???

So, back to the forums and a lot of reading and testing... still no luck.  Then a post indicated that the Column definition must be defined prior to the Page_Load event - so I must define the column definitions in the Page_Init event.  What?  Why?

I was getting the initial display by defining the columns in the Page_Load...

Read More »

By host on Thursday, January 12, 2006 7:42 PM

I have added another example to the SQLGridSelectedView Examples page.  This example is one of the most asked question I get... how to create a hyperlink in the Grid.  

This is a simple example pulled from the Link Table of the DNN database.  I just use the URL and Title columns from 'http' links to build the hyperlink in the SQL Select Statement.  Rather simple... but it is not obvious.  Give it a try...

By host on Sunday, January 08, 2006 9:14 AM

At the beginning of the year I released the initial version of SQLGridSelectedView with several changes that I thought would be useful.  Also I need to "re-brand" the module from my old site to Tresslworks. 

The initial release, V3.3a, had a rather major issue in the release kit. I appearently released the aspx file referring to my previous "companyname" namespace, but shipped the Tressleworks version of the DLL.  Needless to say, it would not load upon upload to any system -- except mine.

I corrected that version and released V3.3b.  Now that people could see it, a minor issue appeared related to the export function. Entered date ranges were ignored,  only the displayed default date ranges would be exported to data file. 

Version V3.3c has corrected this issue and I added the ability to set the DropDown Label text for "ALL" and "Not Applicable".  I have been asked for this several times and I forgot to put this feature on my change list.

I also moved the location of the header message...

Read More »