Archive for May, 2007

Displaying the results of a query in matrix format (pivot table)

Thursday, May 31st, 2007

Today I came across an unusual request, I had to query the database and return the values in a pivot table format (variable columns). That’s kind of easy to do if you are using Sql Reporting, but I had never had to display a gridview in this format. After some research, I was able to find and article on Uma Chandar’s site doing just this: here

create table #tb (record_id int, obj_id char(4), reference char(10))


insert #tb values(1, ‘Btn1′, ‘forward’)
insert #tb values(1, ‘Btn2′, ‘backward’)  

select
  record_id,
  min(case when obj_id = ‘btn1′ then reference end) as btn1,
  min(case when obj_id = ‘btn2′ then reference end) as btn2
from #tb
group by record_id  

 

I hope this helps.  

Posted in Sql | No Comments »

AjaxControlToolkit and SmartNavigation

Tuesday, May 22nd, 2007

After spending almost 2 hours investigating the following problem with a Ajax dropdown extension object:

‘Error: Sys.ArgumentTypeException: Object of type ‘AjaxControlToolkit.PopupBehavior’ cannot be converted to type ‘AjaxControlToolkit.PopupBehavior’.

I finally realized the page was using the smartNavigation directive. This directive has become obsolete with .NET 2.0, you can now use Page.SetFocus() and
Page.MaintainScrollPositionOnPostBack() instead to obtain similar result. However, during the upgrade process from 1.1, the wizard didn’t flag this directive as a problem, so
I was not aware of its presence until I came across the problem above.
 
Anyway, I was not surprised that upon removing this directive, the page was no longer throwing the javascript exception.

Lesson learned.

Posted in .NET | 8 Comments »