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 Tuesday, January 24, 2006 10:08:00 PM

Seems a letter I wrote to the hosts was actually read  and made it to the show -- Number #163 ... you can hear the entire show at www.dotnetrocks.com or just the letter at the link below.

As I wrote in my previous blog entries, I presented a talk on DotNetNuke Module development at the Toronto Code Camp.  As rank beginner in this field - public presentations - I was rather green. 

The reason I applied to speak, was a growing belief that I could do it and that a .Net community event would be the best venue to start (or end) my speaking career.  About the time that the annoucement of the Code Camp, the "boys" from DotNetRocks (Richard Campbell and Carl Franklin) were doing a road trip stoping at various .Net meetings throughout the U.S. as they headed to Vegas for the Launch of VS 2005.  Well as they spoke to each group, they recorded comments from the various .Net Community members.  It seemed to be an engaging group that, perhaps, I...

Read More »

By host on Tuesday, January 17, 2006 10:55:00 PM

I had the pleasure of being a speaker at the Toronto Code Camp on this past Saturday - January 14th - and it was a real success.  I spoke on "Module Development in the DotNetNuke Framework V3/V4".  My session was well attended as were all the sessions.  The camp had close to 200 attendees - see www.TorontoCodeCamp.com for details and pictures..  but here is one me.

Many thanks to organizers ...  especially Chris Defour.

 

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 Monday, January 09, 2006 7:13:00 PM

Today I started to create a rather simple stored procedure that I thought would take a few minutes... Well it fell into the "20 minute" rule... if you estimate about "20 minutes" it won't be...

Anyway, this procedure needed to build SQL Select based on parameters passed in.  So, I needed to user SQL EXECUTE statement.  I create @SQL as the varchar that I contained the select statement and passed the command to the EXECUTE.. When procedure ran, I got the MSG 203  error message, but it was truncated due to the length of the SQL statement..  No problem, off to Books Online to determine what the MSG 203 message -- not there... Google?

OK .. 20 minutes later I finally discovered that any statement I passed into the EXECUTE statement did not work.  Hmmmm.  So back to the EXECUTE statement documentation.  Seems that I had missed a little detail.  If you are using a variable -- eg. @SQL in my case -- you must surround the EXECUTE parameter statement in brackets.  

So...(using the NorthWind database...

Read More »

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 »

By host on Saturday, January 07, 2006 11:28 PM

The title graphic is base on a picture of a bridge that was shown on the Trains webiste as part of there photo contest between to amateur photographers.

The original photo was taken by  Mike Yuhas and is located here http://www.trains.com/Content/Dynamic/Articles/000/000/006/206skgap.asp

Many thanks Mike!

 

By host on Saturday, January 07, 2006 10:56:00 PM

This is my initial blog entry.  At this point I feel as if I am writing this in an empty room, but I believe this will change over time. 

So I am getting close to completing my new site.  So why TressleWorks?  It is rather simple, I am Model Railroading fan and was looking for a name that sort of reflect that aspect.  A tressle or trestle - take your pick - is a beam used to build a table.  In the case of railway tressles, the wood beams collectively are call a tressle.  Most tressle bridges now are metal, but there are stil some wooden ones around.

I have just released my latest version of SQLGridSelectedView. I made several tweaks to the code to correct some minor errors - specially I broke the data export with respect to user entered date ranges - version 3.3a and 3.3b both ignored the user input and only displayed the default date range in the exported data file.  This has been corrected.  

I also moved the location of the header message to appear above the data selections - it seems...

Read More »