Tips & Tricks

Using ASP.NET Caching with SQL Server

noreply@blogger.com (stanley) — Thu, 29 Apr 2010 21:25:00 +0000

Using ASP.NET Caching with SQL Server

Enabling Cache Notification for SQL Server

On the Windows Start menu, point to All Programs, point to Accessories, and then click Command Prompt to open a command prompt window.

Locate the Aspnet_regsql.exe executable file on your disk drive. This file is installed with the .NET Framework version 2.0 in the following location:

%windir%\Microsoft.NET\Framework\FrameworkVersion

Be sure that %windir% represents your Windows directory and that the .NET Framework version is 2.0 or later. The path might look like the following:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.40217

Use the following command to enable cache notification for the dimProductCategory table in the AdventureWorksDW database:

aspnet_regsql.exe -S <Server> -U <Username> -P <Password> -ed -d AdventureWorksDW -et –t dimProductCategory

Configuring the Web Page for Caching
<%@ OutputCache Duration="3600" SqlDependency=" AdventureWorksDW: DimProductCategory
" VaryByParam="none" %>

Setting Caching Configuration in the Web.config File
Add the following XML to the Web.config file as a child of the system.web element:

<add
name="AdventureWorksDW" connectionStringName="AdventureWorksDWConnectionString"

pollTime = "1000"/>

</databases>

</sqlCacheDependency>

</caching>

To configure application-level caching

<caching>
<outputCacheSettings>
<outputCacheProfiles>
<add
name="AppCache1"
enabled="true"
duration="60"/>
</outputCacheProfiles>
</outputCacheSettings>
</caching>
Add the OutputCache into the page

<%@ OutputCache CacheProfile="AppCache1" VaryByParam="none" %>

The sqlDependency table can also specify in the web config as below:

<add
name="AppCache1"
enabled="true" sqlDependency="AdventureWorksDW:DimProductCategory"

duration="60"/>

</outputCacheProfiles>

</outputCacheSettings>

</caching>

Cache the data object
The sample codes below can set up the SqlCacheDependency with the tables or the sql queries

// Declare the SqlCacheDependency instance, SqlDep.

SqlCacheDependency SqlDep = null;

// Check the Cache for the SqlSource key.

// If it isn't there, create it with a dependency

// on a SQL Server table using the SqlCacheDependency class.

if (Cache["SqlSource"] == null)

{

// Because of possible exceptions thrown when this

// code runs, use Try...Catch...Finally syntax.

try

{

// Instantiate SqlDep using the SqlCacheDependency constructor.

SqlDep = new SqlCacheDependency("AdventureWorksDW", "DimProductCategory");

}

// Handle the DatabaseNotEnabledForNotificationException with

// a call to the SqlCacheDependencyAdmin.EnableNotifications method.

catch (DatabaseNotEnabledForNotificationException exDBDis)

{

try

{

SqlCacheDependencyAdmin.EnableNotifications("AdventureWorksDW");

}

// If the database does not have permissions set for creating tables,

// the UnauthorizedAccessException is thrown. Handle it by redirecting

// to an error page.

catch (UnauthorizedAccessException exPerm)

{

throw new Exception(exPerm.Message, exPerm);

}

// Handle the TableNotEnabledForNotificationException with

// a call to the SqlCacheDependencyAdmin.EnableTableForNotifications method.

catch (TableNotEnabledForNotificationException exTabDis)

{

try

{

SqlCacheDependencyAdmin.EnableTableForNotifications("Northwind", "Categories");

}

// If a SqlException is thrown, redirect to an error page.

catch (SqlException exc)

{

throw new Exception(exc.Message, exc);

}

// If all the other code is successful, add MySource to the Cache

// with a dependency on SqlDep. If the Categories table changes,

// MySource will be removed from the Cache. Then generate a message

// that the data is newly created and added to the cache.

finally

{

Cache.Insert("SqlSource", this.SqlDataSource1, SqlDep);

//The data object was created explicitly;

}

else

{

//The data was retrieved from the Cache;

}

3. Multiple Table Dependencies

SqlCacheDependency
  dep1 = new SqlCacheDependency ("MyDb", "Users"),
  dep2 = new SqlCacheDependency ("MyDb", "UserRoles"),
  dep3 = new SqlCacheDependency ("MyDb", "Policies");

AggregateCacheDependency aggDep = new AggregateCacheDependency ();
aggDep.Add (dep1, dep2, dep3);

Cache.Insert ("SomeKey", someData, aggDep);

Create a SQL cache dependecy using a custom (non-dbo) schema

noreply@blogger.com (stanley) — Thu, 29 Apr 2010 16:57:00 +0000

The store procedure "AspNet_SqlCacheRegisterTableStoredProcedure" 'enables' change notification on the table you specify (in simpler terms, it just creates a trigger on the table you specify)

This procedure has the dbo schema hardcoded in it

SET @fullTriggerName =
'dbo.['
+ @triggerName +
']'

Just tweaked this portion of the procedure to extract the Schema Name specified by the user and use that to create the trigger rather than the hardcoded 'dbo'. The modified stored proc is below. You can alter the procedure on your database instance and you are all set. Ofcourse, I find similar hardcoding of 'dbo' in the procedure AspNet_SqlCacheUnRegisterTableStoredProcedure, which is responsible for disabling notifications on your table, so you will need to tweak it a bit to make unregistration work.

-- ===========================================================================================

USE [TestDB]

/****** Object: StoredProcedure [dbo].[AspNet_SqlCacheRegisterTableStoredProcedure] Script Date: 04/18/2008 16:05:31 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

ALTER PROCEDURE [dbo].[AspNet_SqlCacheRegisterTableStoredProcedure]

@tableName NVARCHAR(450)

BEGIN

DECLARE @triggerName AS NVARCHAR(3000)

DECLARE @fullTriggerName AS NVARCHAR(3000)

DECLARE @canonTableName NVARCHAR(3000)

DECLARE @quotedTableName NVARCHAR(3000)

--Vivek Start --Added A

DECLARE @schemaName NVARCHAR(3000)

IF(CHARINDEX('.',@tableName) <> 0)

BEGIN

SET @schemaName = SUBSTRING(@tableName,0,CHARINDEX('.',@tableName))

SET @tableName = SUBSTRING(@tableName,CHARINDEX('.',@tableName) + 1,LEN(@tableName) - CHARINDEX('.',@tableName))

END

--Vivek END A

/* Create the trigger name */

SET @triggerName = REPLACE(@tableName, '[', '__o__')

SET @triggerName = REPLACE(@triggerName, ']', '__c__')

SET @triggerName = @triggerName + '_AspNet_SqlCacheNotification_Trigger'

--Vivek Commented --SET @fullTriggerName = 'dbo[' + @triggerName + ']'

IF(@schemaName IS NOT NULL)

SET @fullTriggerName ='[' + @schemaName + '].[' + @triggerName + ']'

ELSE

SET @fullTriggerName = 'dbo.[' + @triggerName + ']'

/* Create the cannonicalized table name for trigger creation */

/* Do not touch it if the name contains other delimiters */

IF (CHARINDEX('.', @tableName) <> 0 OR

CHARINDEX('[', @tableName) <> 0 OR

CHARINDEX(']', @tableName) <> 0)

SET @canonTableName = @tableName

ELSE

SET @canonTableName = '[' + @schemaName + '].[' + @tableName + ']'

/* First make sure the table exists */

--Vivek Commented --IF (SELECT OBJECT_ID(@tableName, 'U')) IS NULL

--BEGIN

-- RAISERROR ('00000001', 16, 1)

-- RETURN

--END

--Vivek Start --Added B

IF(@schemaName IS NULL)

BEGIN

IF (SELECT OBJECT_ID(@tableName, 'U')) IS NULL

BEGIN

RAISERROR ('00000001', 16, 1)

RETURN

END

ELSE

BEGIN

IF (SELECT OBJECT_ID(@schemaName + '.' + @tableName, 'U')) IS NULL

BEGIN

RAISERROR ('00000001', 16, 1)

RETURN

END

--Vivek End B

BEGIN TRAN

/* Insert the value into the notification table */

IF NOT EXISTS (SELECT tableName FROM dbo.AspNet_SqlCacheTablesForChangeNotification WITH (NOLOCK) WHERE tableName = @tableName)

IF NOT EXISTS (SELECT tableName FROM dbo.AspNet_SqlCacheTablesForChangeNotification WITH (TABLOCKX) WHERE tableName = @tableName)

INSERT dbo.AspNet_SqlCacheTablesForChangeNotification

VALUES (@tableName, GETDATE(), 0)

/* Create the trigger */

SET @quotedTableName = QUOTENAME(@tableName, '''')

IF NOT EXISTS (SELECT name FROM sysobjects WITH (NOLOCK) WHERE name = @triggerName AND type = 'TR')

IF NOT EXISTS (SELECT name FROM sysobjects WITH (TABLOCKX) WHERE name = @triggerName AND type = 'TR')

EXEC('CREATE TRIGGER ' + @fullTriggerName + ' ON ' + @canonTableName +'

FOR INSERT, UPDATE, DELETE AS BEGIN

SET NOCOUNT ON

EXEC dbo.AspNet_SqlCacheUpdateChangeIdStoredProcedure N' + @quotedTableName + '

END

COMMIT TRAN

END

Ajax enabled WCF Service stops working with Undefined error

noreply@blogger.com (stanley) — Thu, 11 Mar 2010 19:40:00 +0000

I got a javascript underfine error when I use the wcf service call. I found out that it will work after I remove or comment the extendedProtectionPolicy from the web configuration.

Use AspNet_Merge to Version Website Assemblies

noreply@blogger.com (stanley) — Tue, 09 Mar 2010 21:44:00 +0000

If you want to add versioning information to the assemblies generated for a precompiled Web site, you can do the following:

Add an AssemblyInfo.cs or AssemblyInfo.vb file to the App_Code folder. The assembly generated for the App_Code folder will then be versioned. You can also add version attributes to the code-behind files for pages and user controls. However, adding version attributes to individual files is tedious and applies only to code-behind files in an updatable precompilation layout.
Add references to an AssemblyInfo.cs or AssemblyInfo.vb file to the compilerOptions attribute of the <compiler> element in the Web.config file. This enables you to add versioning for all assemblies generated for the Web site. In that case, you must include both C# and Visual Basic compilers because ASP.NET might select a compiler for non-code type files, such as WSDL, when compiling the proxies.

Aspnet_merge.exe can version the assemblies it creates by either copying the attributes from the App_Code assembly or copying them from a specific assembly specified using the –copyattrs option. This is therefore treated like any other assembly attribute. These options for specifying an attribute for the merged assembly or assemblies ensures that you can define all version attributes, including the file version, the assembly version, and any other assembly attributes you require.

Figure 25 shows the merge command used to apply attributes from the App_Code assembly, using the Web site shown in Figure 1. The AssemblyInfo.cs file shown in Figure 22 has been added to the Web site's App_Code folder.

Example

Aspnet_merge c:\precompileWebsite –copyattrs –a

IE Modal Dialog and ASP.NET PostBack solution

noreply@blogger.com (stanley) — Mon, 08 Mar 2010 23:50:00 +0000

Put the following HTML code inside of your page header in HTML source,

1	<head>
2	<title>My Page</title>

3	<base target="_self"></base>
4	</head>

The modal dialog will be able to successfully postback to itself

Multiple Onclick JavaScript Events on a Single Control

noreply@blogger.com (stanley) — Thu, 04 Mar 2010 16:57:00 +0000

You can't add two identical events to the same Html control. For example, if you have a button with an onclick event, and you add another onclick at the server, the second event will overwrite the first. This becomes a problem if you need to add an event to some variable control, but you don't know what events that control already has. However, .Net provides a way to handle this.

We can:

See if the variable html control already has an onclick event.
If it does, then dynamically register a new script that calls both the original onclick script as well as the new script.
Replace the variable control's onclick value with that new script.

The following code snippets this. This first block shows a simple JavaScript (with a parameter) being called by a button's onclick event.

function DoStuff1(var1) {
alert('1: ' + var1);
}

...

...

This snippet shows the server code to check if an onclick event already exists, and add a new wrapper if needed. Note that it persists the onclick values in viewstate to ensure that the wrapper function doesn't wrap itself upon postback. For example, if the first onclick event called DoStuff1(), and we wanted to dynamically add a new onclick function DoStuff2(), we could create a wrapper function Wrapper1() that called both functions, and was called from the onclick. Wrapper1() becomes the new value of the button's onclick.

private void Page_Load(object sender, System.EventArgs e)
{
    string s = this.Button1.Attributes["onclick"];
    if (!Page.IsPostBack)
        OriginalJSFunction = s;
    if (s == null)
        this.Button1.Attributes.Add("onclick","DoStuff2()");
    else
    {
        if (!Page.IsClientScriptBlockRegistered("JS1"))
            Page.RegisterClientScriptBlock("JS1",GetJS(OriginalJSFunction));
        this.Button1.Attributes.Add("onclick","Wrapper1()");
    }
}

private string OriginalJSFunction
{
    get
    {
        object o = ViewState["OriginalJSFunction"];
        if (o == null)
            return "";
        else
            return o.ToString();
    }
    set
    {
        ViewState["OriginalJSFunction"] = value;
    }
}

private string GetJS(string strOriginalFn) //will handle initial JS with params
{
    System.Text.StringBuilder sb = new System.Text.StringBuilder();
    sb.Append(@"
        <script language='javascript'>
        function Wrapper1() {
        " + strOriginalFn + @";
        DoStuff2();
        }
        </script>
    ");

    return sb.ToString();
}

While this approach is tedious, it lets you dynamically add an event to a control without overwriting that control's existing event. This is useful when making your own custom controls that integrate with existing Html controls already on the page.

http://timstall.dotnetdevelopersjournal.com/multiple_onclick_javascript_events_on_a_single_control.htm

Multiple select values in Cognos Report with store procedure

noreply@blogger.com (stanley) — Tue, 02 Mar 2010 21:47:00 +0000

Import the stored procedure in Framework Manager and set the parameters to:

1^st parameter = #prompt('param1')#

2nd parameter = #prompt('param2')#
Create a report in Report Studio with a report page calling the SP and a prompt page containing the multiple select value prompt

Add a text box prompt object to the prompt page

Set the following ID's for the objects on the prompt page:

Multiple select value prompt ID = Preprocessing_ID1

Textbox prompt ID = Postprocessing_ID1
Add an HTML item with the following javascript to the report:

// IBM Cognos 8.3 specific

function assignParamValue()

{

// get the reference to the Cognos form

var fW = (typeof getFormWarpRequest == "function" ? getFormWarpRequest() :

document.forms["formWarpRequest"]);

var i, tmp;

tmp = "";

// get the handle for the 1st checkbox prompt - add div around them to distinguish

var prompt1 = document.getElementById('checkboxPrompt1');

// find all the children of the div of type checkboxes.

for (i=0; i < prompt1.childNodes.length; i++)

{

var node_list = prompt1.getElementsByTagName('input');

for (var i = 0; i < node_list.length; i++)

{

var node = node_list[i];

if (node.getAttribute('type') == 'checkbox')

{

if (node.checked)

{

if( tmp == "" )

{

tmp = node.value;

}

else

{

tmp = tmp + "," + node.value;

}

fW._textEditBoxPostprocessing_ID.value = tmp;

canSubmitPrompt();

promptButtonFinish();

}

</script>

Add an HTML item before the checkbox with the contents of

<div id="checkboxPrompt1">

and add an HTML item right after the checkbox prompt with the contents of

</div>
Add a virtual "finish" button to call the javascript function before proceeding to the report itself by adding another HTML item and inserting the following code:

<input type="BUTTON" class="clsPromptButton" onClick="assignParamValue()"

value="Finish">

Code Signing for Developers - An Authenticode How-To

noreply@blogger.com (stanley) — Tue, 02 Mar 2010 21:45:00 +0000

If you are a software developer then you probably already know that Microsoft Windows and web browsers such as Internet Explorer and Mozilla Firefox use a technology called Authenticode to verify the publisher of downloads and check that they have not been infected by a virus since they were created. If your software is not signed with a digital certificate, users will receive a warning that the publisher could not be verified and asked whether they want to continue running it. Many users will decide to play safe and click "Don't run", costing you lost sales.

http://www.tech-pro.net/code-signing-for-developers.html

How to Create Versioned Assemblies in the Visual Studio 2005 and Visual Studio 2008 Website

noreply@blogger.com (stanley) — Tue, 02 Mar 2010 21:40:00 +0000

To create an assembly-information file for your website

Using a text editor, create a new assembly-information file. For Visual Basic applications, the suggested file name is AssemblyInfo.vb. For C# applications, the suggested file name is AssemblyInfo.cs.

[assembly:System.Reflection.AssemblyVersionAttribute("versionNumber")]

Do not place the assembly-information file in the App_Code directory. If you place the assembly-information file in the App_Code directory, it will be compiled automatically by the ASP.NET runtime and might cause compilation errors later in the compilation process.

To specify the assembly-information file in your .aspx page

Open your .aspx file in a text editor.
Add the following attribute to the @ Page directive in the .aspx page.

CompilerOptions="path\AssemblyInfo.cs"

Replace the path parameter with the physical path to the assembly-information file on disk.

If the path to your assembly-information file contains spaces, you must enclose the path and file name in single quotation marks (').

CompilerOptions='"path with spaces\AssemblyInfo.cs"'

Replace the path with spaces parameter with the physical path to the assembly-information file on disk.

Publish the website.

To specify the assembly-information file in your Web.config file

Open your Web.config file in a text editor.
Add the following code to your Web.config file.

"c#;cs;csharp" extension=".cs"

type="Microsoft.CSharp.CSharpCodeProvider, System,

Version=2.0.3600.0, Culture=neutral,

PublicKeyToken=b77a5c561934e089" warningLevel="1"

compilerOptions="path\AssemblyInfo.cs" />

Publish the website

Ref: http://msdn.microsoft.com/en-us/library/ms228042.aspx

noreply@blogger.com (stanley) — Tue, 20 Oct 2009 20:46:00 +0000

Sort Cognos report in the JavaScript

<!--

function expandA(array,x,y) {

// Expand X

for (var i=0; i<=x; i++ )

{

if (array.length <= i)

{

array[i]=[];

}

// Expand y

for (var i=0; i<=y; i++ )

{

if (array[x].length <= i)

{

array[x][i]= '';

}

function setVal(array, x, y, val) {

expandA(array,x,y);

array[x][y]=val;

}

function getVal(array, x, y) {

if (array.length >= x+1 && array[x].length >=y+1)

{

return array[x][y];

} else {

return null;

}

var stIsIE = /*@cc_on!@*/false;

var colOffset = 0;

sorttable = {

init: function() {

// quit if this function has already been called

if (arguments.callee.done) return;

// flag this function so we don't do the same thing twice

arguments.callee.done = true;

// kill the timer

if (_timer) clearInterval(_timer);

if (!document.createElement || !document.getElementsByTagName) return;

sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/;

forEach(document.getElementsByTagName('table'), function(table) {

if (table.className.search(/\bxt\b/) != -1) {

sorttable.makeSortable(table);

}

});

makeSortable: function(table) {

if (table.getElementsByTagName('thead').length == 0) {

// table doesn't have a tHead. Since it should have, create one and

// put the first table row in it.

the = document.createElement('thead');

var headerRows = 0;

// Now we need to determine how many rows are the header

forEach(table.children[0].childNodes, function(row) {

if (row.nodeType == 1) {

//alert(row.innerHTML);

if (row.innerHTML.search(/\bcl\b/) != -1 && headerRows>=0) {

// found

headerRows = -(++headerRows);

} else {

if (headerRows >= 0)

{

headerRows++;

}

});

for (var i=0;i<-(headerRows) ;i++ )

{

the.appendChild(table.rows[0]);

}

table.insertBefore(the,table.firstChild);

}

// Safari doesn't support table.tHead, sigh

if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0];

// if (table.tHead.rows.length != 1) return; // can't cope with two header rows

// Figure out how many columns we need to offset

// Build cell map

var cellMap=new Array();

rowNum = 1;

rowIndex = 0;

colIndex = 0;

forEach(table.tHead.childNodes, function(row) {

if (row.nodeType == 1) {

forEach(row.childNodes, function(cell) {

if (cell.nodeType == 1) { // an element

while (getVal(cellMap,rowIndex,colIndex) > 0) colIndex++;

// populate array

for (var i=0;i< cell.colSpan; i++ )

{

for (var j=0;j< cell.rowSpan; j++ )

{

setVal(cellMap,rowIndex+j,colIndex+i,rowNum);

}

colIndex+=i;

}

});

rowNum++;

colIndex=0;

rowIndex = rowNum- 1;

}

});

// Count number of columns to skip

rowNum--;

for (colIndex=0; colIndex<cellMap[rowIndex-1].length && cellMap[rowIndex-1][colIndex] != rowNum ; colIndex++ ) {}

if (cellMap[rowIndex-1][colIndex] == rowNum) {

colOffset = colIndex;

}

// Sorttable v1 put rows with a class of "sortbottom" at the bottom (as

// "total" rows, for example). This is B&R, since what you're supposed

// to do is put them in a tfoot. So, if there are sortbottom rows,

// for backwards compatibility, move them to tfoot (creating it if needed).

sortbottomrows = [];

for (var i=0; i<table.rows.length; i++) {

if (table.rows[i].className.search(/\bsortbottom\b/) != -1) {

sortbottomrows[sortbottomrows.length] = table.rows[i];

}

if (sortbottomrows) {

if (table.tFoot == null) {

// table doesn't have a tfoot. Create one.

tfo = document.createElement('tfoot');

table.appendChild(tfo);

}

for (var i=0; i<sortbottomrows.length; i++) {

tfo.appendChild(sortbottomrows[i]);

}

delete sortbottomrows;

}

// work through each column and calculate its type

headrow = table.tHead.lastChild.cells;

for (var i=0; i<headrow.length; i++) {

if(headrow[i].getAttribute('sort') == null) {

headrow[i].setAttribute('sort','');

}

// manually override the type with a sorttable_type attribute

if (!headrow[i].getAttribute('sort').match(/\bsorttable_nosort\b/)) { // skip this col

mtch = headrow[i].getAttribute('sort').match(/\bsorttable_([a-z0-9_]+)\b/);

if (mtch) { override = mtch[1]; }

if (mtch && typeof sorttable["sort_"+override] == 'function') {

headrow[i].sorttable_sortfunction = sorttable["sort_"+override];

} else {

headrow[i].sorttable_sortfunction = sorttable.guessType(table,i+colOffset);

// alert(headrow[i].sorttable_sortfunction);

}

// make it clickable to sort

headrow[i].sorttable_columnindex = i+colOffset;

headrow[i].sorttable_tbody = table.tBodies[0];

dean_addEvent(headrow[i],"click", function(e) {

if (this.getAttribute('sort').search(/\bsorttable_sorted\b/) != -1) {

// if we're already sorted by this column, just

// reverse the table, which is quicker

sorttable.reverse(this.sorttable_tbody);

this.setAttribute('sort',this.getAttribute('sort').replace('sorttable_sorted',

'sorttable_sorted_reverse'));

this.removeChild(document.getElementById('sorttable_sortfwdind'));

sortrevind = document.createElement('span');

sortrevind.id = "sorttable_sortrevind";

sortrevind.innerHTML = stIsIE ? '&nbsp<font face="webdings">5</font>' : ' ▴';

this.appendChild(sortrevind);

return;

}

if (this.getAttribute('sort').search(/\bsorttable_sorted_reverse\b/) != -1) {

// if we're already sorted by this column in reverse, just

// re-reverse the table, which is quicker

sorttable.reverse(this.sorttable_tbody);

this.setAttribute('sort',this.getAttribute('sort').replace('sorttable_sorted_reverse',

'sorttable_sorted'));

this.removeChild(document.getElementById('sorttable_sortrevind'));

sortfwdind = document.createElement('span');

sortfwdind.id = "sorttable_sortfwdind";

sortfwdind.innerHTML = stIsIE ? '&nbsp<font face="webdings">6</font>' : ' ▾';

this.appendChild(sortfwdind);

return;

}

// remove sorttable_sorted classes

theadrow = this.parentNode;

forEach(theadrow.childNodes, function(cell) {

if (cell.nodeType == 1) { // an element

cell.setAttribute('sort',cell.getAttribute('sort').replace('sorttable_sorted_reverse',''));

cell.setAttribute('sort',cell.getAttribute('sort').replace('sorttable_sorted',''));

}

});

sortfwdind = document.getElementById('sorttable_sortfwdind');

if (sortfwdind) { sortfwdind.parentNode.removeChild(sortfwdind); }

sortrevind = document.getElementById('sorttable_sortrevind');

if (sortrevind) { sortrevind.parentNode.removeChild(sortrevind); }

this.setAttribute('sort',this.getAttribute('sort') + ' sorttable_sorted');

sortfwdind = document.createElement('span');

sortfwdind.id = "sorttable_sortfwdind";

sortfwdind.innerHTML = stIsIE ? '&nbsp<font face="webdings">6</font>' : ' ▾';

this.appendChild(sortfwdind);

// build an array to sort. This is a Schwartzian transform thing,

// i.e., we "decorate" each row with the actual sort key,

// sort based on the sort keys, and then put the rows back in order

// which is a lot faster because you only do getInnerText once per row

row_array = [];

col = this.sorttable_columnindex;

rows = this.sorttable_tbody.rows;

for (var j=0; j<rows.length; j++) {

row_array[row_array.length] = [sorttable.getInnerText(rows[j].cells[col]), rows[j]];

}

/* If you want a stable sort, uncomment the following line */

//sorttable.shaker_sort(row_array, this.sorttable_sortfunction);

/* and comment out this one */

row_array.sort(this.sorttable_sortfunction);

tb = this.sorttable_tbody;

for (var j=0; j<row_array.length; j++) {

tb.appendChild(row_array[j][1]);

}

delete row_array;

});

}

guessType: function(table, column) {

// guess the type of a column based on its first non-blank row

sortfn = sorttable.sort_alpha;

for (var i=0; i<table.tBodies[0].rows.length; i++) {

text = sorttable.getInnerText(table.tBodies[0].rows[i].cells[column]);

//alert(text);

if (text != '') {

//alert(text);

if (text.match(/^[(-]?[£$¤]?[\d,.]+[%)]?$/)) {

return sorttable.sort_numeric;

}

// check for a date: dd/mm/yyyy or dd/mm/yy

// can have / or . or - as separator

// can be mm/dd as well

possdate = text.match(sorttable.DATE_RE)

if (possdate) {

// looks like a date

first = parseInt(possdate[1]);

second = parseInt(possdate[2]);

if (first > 12) {

// definitely dd/mm

return sorttable.sort_ddmm;

} else if (second > 12) {

return sorttable.sort_mmdd;

} else {

// looks like a date, but we can't tell which, so assume

// that it's dd/mm (English imperialism!) and keep looking

sortfn = sorttable.sort_ddmm;

}

return sortfn;

getInnerText: function(node) {

// gets the text we want to use for sorting for a cell.

// strips leading and trailing whitespace.

// this is *not* a generic getInnerText function; it's special to sorttable.

// for example, you can override the cell text with a customkey attribute.

// it also gets .value for <input> fields.

hasInputs = (typeof node.getElementsByTagName == 'function') &&

node.getElementsByTagName('input').length;

if (node.getAttribute("sorttable_customkey") != null) {

return node.getAttribute("sorttable_customkey");

}

else if (typeof node.textContent != 'undefined' && !hasInputs) {

return node.textContent.replace(/\s\)/g,'').replace(/^\s+|\s+$/g, '');

}

else if (typeof node.innerText != 'undefined' && !hasInputs) {

return node.innerText.replace(/^\s+|\s+$/g, '');

}

else if (typeof node.text != 'undefined' && !hasInputs) {

return node.text.replace(/^\s+|\s+$/g, '');

}

else {

switch (node.nodeType) {

case 3:

if (node.nodeName.toLowerCase() == 'input') {

return node.value.replace(/^\s+|\s+$/g, '');

}

case 4:

return node.nodeValue.replace(/^\s+|\s+$/g, '');

break;

case 1:

case 11:

var innerText = '';

for (var i = 0; i < node.childNodes.length; i++) {

innerText += sorttable.getInnerText(node.childNodes[i]);

}

return innerText.replace(/^\s+|\s+$/g, '');

break;

default:

return '';

}

reverse: function(tbody) {

// reverse the rows in a tbody

newrows = [];

for (var i=0; i<tbody.rows.length; i++) {

newrows[newrows.length] = tbody.rows[i];

}

for (var i=newrows.length-1; i>=0; i--) {

tbody.appendChild(newrows[i]);

}

delete newrows;

/* sort functions

each sort function takes two parameters, a and b

you are comparing a[0] and b[0] */

sort_numeric: function(a,b) {

aa = parseFloat(a[0].replace(/[^0-9.-]/g,''));

bb = parseFloat(b[0].replace(/[^0-9.-]/g,''));

return aa-bb;

sort_alpha: function(a,b) {

if (a[0]==b[0]) return 0;

if (a[0]<b[0]) return -1;

return 1;

sort_ddmm: function(a,b) {

mtch = a[0].match(sorttable.DATE_RE);

y = mtch[3]; m = mtch[2]; d = mtch[1];

if (m.length == 1) m = '0'+m;

if (d.length == 1) d = '0'+d;

dt1 = y+m+d;

mtch = b[0].match(sorttable.DATE_RE);

y = mtch[3]; m = mtch[2]; d = mtch[1];

if (m.length == 1) m = '0'+m;

if (d.length == 1) d = '0'+d;

dt2 = y+m+d;

if (dt1==dt2) return 0;

if (dt1<dt2) return -1;

return 1;

sort_mmdd: function(a,b) {

mtch = a[0].match(sorttable.DATE_RE);

y = mtch[3]; d = mtch[2]; m = mtch[1];

if (m.length == 1) m = '0'+m;

if (d.length == 1) d = '0'+d;

dt1 = y+m+d;

mtch = b[0].match(sorttable.DATE_RE);

y = mtch[3]; d = mtch[2]; m = mtch[1];

if (m.length == 1) m = '0'+m;

if (d.length == 1) d = '0'+d;

dt2 = y+m+d;

if (dt1==dt2) return 0;

if (dt1<dt2) return -1;

return 1;

shaker_sort: function(list, comp_func) {

// A stable sort function to allow multi-level sorting of data

// see: http://en.wikipedia.org/wiki/Cocktail_sort

// thanks to Joseph Nahmias

var b = 0;

var t = list.length - 1;

var swap = true;

while(swap) {

swap = false;

for(var i = b; i < t; ++i) {

if ( comp_func(list[i], list[i+1]) > 0 ) {

var q = list[i]; list[i] = list[i+1]; list[i+1] = q;

swap = true;

}

} // for

t--;

if (!swap) break;

for(var i = t; i > b; --i) {

if ( comp_func(list[i], list[i-1]) < 0 ) {

var q = list[i]; list[i] = list[i-1]; list[i-1] = q;

swap = true;

}

} // for

b++;

} // while(swap)

}

/* ******************************************************************

Supporting functions: bundled here to avoid depending on a library

****************************************************************** */

// Dean Edwards/Matthias Miller/John Resig

/* for Mozilla/Opera9 */

if (document.addEventListener) {

document.addEventListener("DOMContentLoaded", sorttable.init, false);

}

/* for Internet Explorer */

/*@cc_on @*/

/*@if (@_win32)

document.write("<script id=__ie_onload defer src=javascript:void(0)><\/script>");

var script = document.getElementById("__ie_onload");

script.onreadystatechange = function() {

if (this.readyState == "complete") {

sorttable.init(); // call the onload handler

}

};

/*@end @*/

/* for Safari */

if (/WebKit/i.test(navigator.userAgent)) { // sniff

var _timer = setInterval(function() {

if (/loaded|complete/.test(document.readyState)) {

sorttable.init(); // call the onload handler

}

}, 10);

}

/* for other browsers */

window.onload = sorttable.init;

// written by Dean Edwards, 2005

// with input from Tino Zijdel, Matthias Miller, Diego Perini

// http://dean.edwards.name/weblog/2005/10/add-event/

function dean_addEvent(element, type, handler) {

if (element.addEventListener) {

element.addEventListener(type, handler, false);

} else {

// assign each event handler a unique ID

if (!handler.$$guid) handler.$$guid = dean_addEvent.guid++;

// create a hash table of event types for the element

if (!element.events) element.events = {};

// create a hash table of event handlers for each element/event pair

var handlers = element.events[type];

if (!handlers) {

handlers = element.events[type] = {};

// store the existing event handler (if there is one)

if (element["on" + type]) {

handlers[0] = element["on" + type];

}

// store the event handler in the hash table

handlers[handler.$$guid] = handler;

// assign a global event handler to do all the work

element["on" + type] = handleEvent;

}

};

// a counter used to create unique IDs

dean_addEvent.guid = 1;

function removeEvent(element, type, handler) {

if (element.removeEventListener) {

element.removeEventListener(type, handler, false);

} else {

// delete the event handler from the hash table

if (element.events && element.events[type]) {

delete element.events[type][handler.$$guid];

}

};

function handleEvent(event) {

var returnValue = true;

// grab the event object (IE uses a global event object)

event = event || fixEvent(((this.ownerDocument || this.document || this).parentWindow || window).event);

// get a reference to the hash table of event handlers

var handlers = this.events[event.type];

// execute each event handler

for (var i in handlers) {

this.$$handleEvent = handlers[i];

if (this.$$handleEvent(event) === false) {

returnValue = false;

}

return returnValue;

};

function fixEvent(event) {

// add W3C standard event methods

event.preventDefault = fixEvent.preventDefault;

event.stopPropagation = fixEvent.stopPropagation;

return event;

};

fixEvent.preventDefault = function() {

this.returnValue = false;

};

fixEvent.stopPropagation = function() {

this.cancelBubble = true;

}

// Dean's forEach: http://dean.edwards.name/base/forEach.js

forEach, version 1.0

License: http://www.opensource.org/licenses/mit-license.php

// array-like enumeration

if (!Array.forEach) { // mozilla already supports this

Array.forEach = function(array, block, context) {

for (var i = 0; i < array.length; i++) {

block.call(context, array[i], i, array);

}

};

}

// generic enumeration

Function.prototype.forEach = function(object, block, context) {

for (var key in object) {

if (typeof this.prototype[key] == "undefined") {

block.call(context, object[key], key, object);

}

};

// character enumeration

String.forEach = function(string, block, context) {

Array.forEach(string.split(""), function(chr, index) {

block.call(context, chr, index, string);

});

};

// globally resolve forEach enumeration

var forEach = function(object, block, context) {

if (object) {

var resolve = Object; // default

if (object instanceof Function) {

// functions have a "length" property

resolve = Function;

} else if (object.forEach instanceof Function) {

// the object implements a custom forEach method so use that

object.forEach(block, context);

return;

} else if (typeof object == "string") {

// the object is a string

resolve = String;

} else if (typeof object.length == "number") {

// the object is array-like

resolve = Array;

}

resolve.forEach(object, block, context);

}

};

//-->

</script>

HTML Strict Mode Vertical Height with CSS

noreply@blogger.com (stanley) — Thu, 08 Oct 2009 15:37:00 +0000

The table tag for the table containing this text looks like this:

Note that it expands vertically even though it is rendered in standards compliance mode because it has the following CSS applied to it:

html, body{height:100%}

Get Tables has records

noreply@blogger.com (stanley) — Tue, 06 Oct 2009 04:08:00 +0000

DECLARE @TableName VARCHAR(500)

DECLARE table_cursor CURSOR
FOR

SELECT [Name] FROM
sys.tables
order
by [Name]

TRUNCATE
TABLE __ImportTables

OPEN table_cursor

FETCH
NEXT
FROM table_cursor INTO @TableName

WHILE
@@FETCH_STATUS
= 0

BEGIN

DECLARE @SQLString NVARCHAR(2000)

DECLARE @ParmDefinition nvarchar(500);

DECLARE @Count int

SET @SQLString =
'SELECT @Count_Out = COUNT(*) FROM '
+ @TableName

SET @ParmDefinition = N'@Count_Out int OUTPUT';

EXECUTE
sp_executesql @SQLString, @ParmDefinition, @Count_Out=@Count OUTPUT;

IF @Count > 0

INSERT __ImportTables(TableName)
Values
(@TableName)

FETCH
NEXT
FROM table_cursor INTO @TableName

END

CLOSE table_cursor

DEALLOCATE table_cursor

Show loading status page in Cognos Report

noreply@blogger.com (stanley) — Fri, 02 Oct 2009 19:32:00 +0000

<br /><img src='http://train1.dstrat.com/cognos8/samples/images/progress.gif'><b>The request is in processing. Please wait......</b><p></p><br />

</td></tr>

</table>

</td></tr></table>

</div>

setTimeout("SetDefaultSelectedItems();",100);

function SetDefaultSelectedItems()

{

HideLoadingStatus(true);

try

{

var selElements = document.getElementsByTagName('select');

if(selElements != null)

{

var hasSelected = false;

for(var i=0;i<selElements.length;i++)

{

var selElement = selElements[i];

if(selElement.options.length == 1)

{

selElement.options[0].selected = true;

hasSelected = true;

}

if(hasSelected)

{

if(selElements[5].selectedIndex > 1 && selElements[6].selectedIndex > 1)

{

var buttons = document.getElementsByTagName('button');

for(var k = 0;k<buttons.length;k++)

{

var button = buttons[k];

if(button != null && button.innerText == "Finish")

{

if(button.disabled == true)

{

HideLoadingStatus(false);

self.setTimeout("promptAction( 'reprompt' );", 200); // set, it is a hidden button

}

break;

}

}catch(e){}

}

function HideLoadingStatus(hidden)

{

if(hidden)

HideLoadingPage();

else

ShowLoadingPage();

}

function HideLoadingPage() {

if (document.getElementById) { // DOM3 = IE5, NS6

document.getElementById('hidepage').style.visibility = 'hidden';

}

else {

if (document.layers) { // Netscape 4

document.hidepage.visibility = 'hidden';

}

else { // IE 4

document.all.hidepage.style.visibility = 'hidden';

}

function ShowLoadingPage() {

if (document.getElementById) { // DOM3 = IE5, NS6

document.getElementById('hidepage').style.visibility = 'visible';

}

else {

if (document.layers) { // Netscape 4

document.hidepage.visibility = 'show';

}

else { // IE 4

document.all.hidepage.style.visibility = 'visible';

}

</script>

Use JavaScript to Custom Congos Prompt Page

noreply@blogger.com (stanley) — Fri, 25 Sep 2009 22:21:00 +0000

setTimeout("SetDefaultSelectedItems();",200);

function SetDefaultSelectedItems()

{

var selElements = document.getElementsByTagName('select');

if(selElements != null)

{

var hasSelected = false;

for(var i=0;i<selElements.length;i++)

{

var selElement = selElements[i];

if(selElement.options.length == 1)

{

selElement.options[0].selected = true;

hasSelected = true;

}

if(hasSelected)

{

if(selElements[5].selectedIndex > 1 && selElements[6].selectedIndex > 1)

{

var buttons = document.getElementsByTagName('button');

for(var k = 0;k<buttons.length;k++)

{

var button = buttons[k];

if(button != null && button.innerText == "Finish")

{

if(button.disabled == true)

self.setTimeout("promptAction( 'reprompt' );", 200); // set, it is a hidden button

}

</script>

Cognos SDK installation

noreply@blogger.com (stanley) — Wed, 09 Sep 2009 21:51:00 +0000

Cognos SDK Installation

1. c8bimodel_win32_8.4.27.78_ml

2. c8sdk_mp_win32_8.4.27.78_ml

Object reference not set to an instance of an object when creating Silverlight-Enabled WCF Service

noreply@blogger.com (stanley) — Wed, 09 Sep 2009 15:23:00 +0000

Object reference not set to an instance of an object when creating Silverlight-Enabled WCF Service

Resolution 1:

Go to visual studio and under tools, click on options, click on Source Control, and on the drop down menu click on None

Resolution 2:

Create a new WCF service project and then change the binding mode from "wsHttpBinding" to "basicHttpBinding".

Call parents JavaScript function from Child popup windows

noreply@blogger.com (stanley) — Wed, 09 Sep 2009 14:28:00 +0000

function CallAlert()

{

alert("This is parent window's alert function.");

}

</script>

Fig – (2) Javascript on parent window.

function SetParentWindowsHiddenFieldValue()

{

window.opener.document.getElementById("HiddenField1").value =

document.getElementById("TextBox1").value;

return
false;

}

function CallParentWindowFunction()

{

window.opener.CallAlert();

return
false;

}

</script>

Invalid length for a Base-64 char array

noreply@blogger.com (stanley) — Thu, 06 Aug 2009 21:13:00 +0000

Error "Invalid length for a Base-64 char array" when using Convert. FromBase64String(InputString)

Resolution:

When Crypted, replace "+" to space.

string encryptString = Convert.ToBase64String(ms.ToArray());

encryptString = encryptString.Replace("+", " ");

When decrypted, replace space back to "+"

encryptString = encryptString.Replace(" ", "+");

Customize Web Dialog Header

noreply@blogger.com (stanley) — Tue, 04 Aug 2009 20:53:00 +0000

Sample of Customizing Header of Web Dialog window, the style of the header
need to override

. igdw_HeaderContent

{ background-images:url(‘igdw_HeaderContent_blue.gif’)

}

</style>

<ig:WebDialogWindow
ID="WebDialogWindow1"
runat="server" Height="200px" Width="400px">

<RoundedCorners
BodyCornerTopLeftCssClass="cornerLeft" BodyCornerTopRightCssClass="cornerRight" BodyEdgeTopCssClass="edgeTop" />

<Header Visible="False"></Header>

</ig:WebDialogWindow>

Resizing the infragistics web grid and column automatically

noreply@blogger.com (stanley) — Tue, 04 Aug 2009 20:43:00 +0000

Set Body

body onload ="OnPageLoad();" onresize="SetGridSize();"

JavaScript function:

function OnPageLoad() {
SetGridSize();
}
function SetGridSize() {
//debugger;
//g_grdMediaAttachments_ClientID defined in the codeBehind
var webGrid = igtbl_getGridById(g_grdMediaAttachments_ClientID);
var band = webGrid.Bands[0];
var column = band.getColumnFromKey("Comments");
column.setWidth(GetResizedColumnWidth());

//Not sure why the total of the column width are not equal to frame width
var totalColumnWidth = GetResizedColumnWidth()) + GetFixedColumnWidth() - 34;
webGrid.MainGrid.style.width = totalColumnWidth + "px";

}
function GetResizedColumnWidth() {
var resizedColumnWidth = document.body.clientWidth - GetFixedColumnWidth();
if (resizedColumnWidth < resizedcolumnwidth =" 150;" fixedcolumnwidth =" 0;" fixedcolumnwidth =" fixedColumnWidth" fixedcolumnwidth =" fixedColumnWidth" fixedcolumnwidth =" fixedColumnWidth" fixedcolumnwidth =" fixedColumnWidth" fixedcolumnwidth =" fixedColumnWidth" fixedcolumnwidth =" fixedColumnWidth" width =" 0;" webgrid =" igtbl_getGridById(g_grdMediaAttachments_ClientID);" band =" webGrid.Bands[0];" column =" band.getColumnFromKey(columnName);" width =" column.getWidth();">

Create stored procedure if doesn't exists in sysobjects

noreply@blogger.com (stanley) — Tue, 23 Jun 2009 15:33:00 +0000

if not exists(Select * from sysobjects where name = 'ON_TIME_DELIVERY_TELCON2006')

begin

EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE ON_TIME_DELIVERY_TELCON2006 AS

SELECT * FROM ACCOUNTS'

end

Convert Multiple Rows into single Row

noreply@blogger.com (stanley) — Fri, 19 Jun 2009 15:27:00 +0000

Method 1:

DECLARE @str varchar(4000)
SET @str = (SELECT CONTACT_EMAIL + ';' FROM table FOR XML PATH(''))
SET @str = SUBSTRING(@str,1,LEN(@str)-1)
SELECT @str

Method 2:

DECLARE @str varchar(4000)
SELECT @str = COALESCE(@str + ';', '') + CONTACT_EMAIL FROM table
SELECT @str

Method 3:

DECLARE @str varchar(4000)
SELECT DISTINCT STUFF( (SELECT CONTACT_EMAIL + ';' from table FOR XML PATH('')),1,1,'')
SELECT @str

Automatically Create Install Scripts with Sql Server

noreply@blogger.com (stanley) — Mon, 15 Jun 2009 18:53:00 +0000

Problem: How can I QUICKLY create an install script automatically in sql server every time I change my database? Creating an install script in sql server is pretty easy thanks to the "Script Database As..." command. However, this is generally a long winded process that doesn't give you too much control.

In this post, I propose a solution to create build scripts with the following requirements

1. Don't need to write any code
2. Easily maintainable
3. Can script schema AND data
4. Can specify which objects to script
5. Can run automatically before an MSI setup/deployment project is built
6. It has to be FREE

The first thing you need to do is download Microsoft's Database Publishing Wizard (http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en)

Next, in your development sql server, add two new accounts named: ScriptSchema and ScriptData. Make sure they are created as a sql login. At this point, don't give them any other access than public access to the database you want to script.

Open the database you want to script. For each table/view/stored proc etc that you want to include in the install, grant view definition access to the ScriptSchema user as follows:

grant view definition on . to scriptschema

Next, for each table that you want to script the data for, grant select permission on that table to the ScriptData user, ie:

grant select on . to scriptdata

You can double up, so for instance if you want to script the creation and population of data of a certain table called [dbo].[customers] you'd run the two commands:

grant view definition on [dbo].[customers] to scriptschema

grant select on [dbo].[customers] to scriptdata

Once you've set up the permissions, you can check out what will be scripted by connecting to the database as the scriptschema and scriptdata users. As you've now defined what will be scripted, it's time to do the scripting itself.

Jump out into a cmd.exe, and run the two commands;

sqlpubwiz script -C "data source=[server]; initial catalog=[database]; uid=scriptschema; pwd=password;" schema.sql -schemaonly -f

sqlpubwiz script -C "data source=[server]; initial catalog=[database]; uid=scriptdata; pwd=password;" data.sql -dataonly -f

The first command connects to the database using the scriptschema account, and generates the definition of all the objects it can see, ie: those which you gave grant view definition access to.

Likewise the second command connects to teh database using the scriptdata account and generates the scripts to insert the data, based on all the tables it can select from.

You now have two scripts: schema.sql, data.sql. You can add these to your msi/setup projects in visual studio (outside the scope of this post). Furthermore you can then add the two commands mentioned to the pre-build events of your setup's resource project to build the install scripts prior to the MSI etc being built.

I really like this solution to automatically generate sql install scripts. I feel it's elegant, there's no code to be maintained, and no manual updating of sql scripts every time you change the database.

Team Deployment

noreply@blogger.com (stanley) — Thu, 11 Jun 2009 13:05:00 +0000

http://www.tfsbuild.com/Default.aspx?Page=TeamDeploy&AspxAutoDetectCookieSupport=1

Memory leak configuration

noreply@blogger.com (stanley) — Thu, 04 Jun 2009 19:53:00 +0000

http://blogs.msdn.com/tess/archive/2009/05/12/debug-diag-script-for-troubleshooting-net-2-0-memory-leaks.aspx

http://msdn.microsoft.com/en-us/library/ms954593.aspx#dbgch04_scenariounexpected

http://msdn.microsoft.com/en-us/library/ms954591.aspx

http://www.red-gate.com/products/ants_memory_profiler/index.htm

http://support.microsoft.com/?id=911816

http://social.msdn.microsoft.com/Forums/en-US/netfxsetup/thread/ed3d8886-459f-4f13-8a8e-ec86b7f6f4a6

http://social.msdn.microsoft.com/forums/en-US/netfxbcl/thread/9fc91efe-5a5c-42da-a0b3-101752ce92f6/

http://social.msdn.microsoft.com/forums/en-US/netfxbcl/thread/297cc644-00ec-412f-a417-9e8ad1f070f7/