This week I received several E-mails requesting better support for data handling in SQLGridSelectedView.  The main issue as the specific format need to satisify SQL Select processing.  It seems that users would error in entering the needed data and the results were not pleasant.  So, I started to investigate the addition of a Calendar Popup. 

My needs were a bit specific and thus I couldn't use the Calendar that exists in DNN as it is tied to the region settings and the format must be numeric to work.  Ugh!  Also, I needed to be able to input time.

So, I started with a Google search and looked at many Calendar Popups that would certainly do the job, but most were over 40K in size... I really wanted something a little smaller - under 20K. 

I finally found "DateTimePicker" by TengYong Ng (www.rainforestnet.com).  While this is small, it did work with alpha months in the Date string and allowed for Time values.  I modified the routine to include "Yesterday", "Today", and "Tomorrow" preset values along with "Now". 

I must admit that I am not a Java developer, and it took some time to get this all working, but I believe it will improve the usability of SQLGridSelectedView.

Another feature added to this new version of SQLGridSelectedView deals with the Filter Dropdowns.  As most know, DropDownList supports the ability to display one thing, but return a different value when selected.  Typically this would be used to display a Company Name and return the Company Code when selected.    I have implemented a similar feature in SQLGridSelectedView.

Hope you like the new features...