Nov
11
Written by:
host
Saturday, November 11, 2006 9:14:11 PM
The latest version of the SQLGridSelectedView beta has been release. I fix one issue that has caused some problems, but I truely never knew why until recently.
SQLGridSelectedView would on occasion not work in Medium Trust, I could never get a resonable answer for this, but I beleive I stumbled over the issue but accident. I have been using the OLEDB SQL driver to access the database - this has worked well, with very few compliants - until I attempt to access MySQL - I needed a OLEDB driver - so I attempted to use the SQL native driver. Once implemented, my trust problem seem to disappear. I soon realize that the SQL native driver was meant for Medium Trust solution ( a real "a ah" moment)
So please try this in Medium trust mode and let me know if you have any problems.
I also extended the size of the SQL primary statement from 2000 character to 8000 character. I had thought 2000 would be plenty of room - as I imagined that you would true to stored procedure if you got even close to 2000 characters. Well, I had a rather lengthy query, that I came in at 1997 characters and when I add one more condition to the where clause I ran into space problems. On this particular database I could not use a stored procedure, so I was stuck with the limit - so I fix that problem (and then some!)
I added two Grid options that will hide the header or hide the gridlines. The two options allow more control to user to develop special displays where a column header and/or Gridline may interfere with customer CSS styles.
Do Enjoy.
Paul.
Tags: