http://www.javascript-coder.com/window-popup/javascript-window-open.phtml
‘top.document.documentElement’ is null or not an object
This is due to Java script files using same named variables as those used by the Microsoft.NET AJAX Library. Hence causing the error
‘top.document.documentElement’ is null or not an object
SQL Server Join Types
Microsoft SQL Server Programming FAQ Index ( good collection of topics on SQL Server).
http://www.tek-tips.com/faq.cfm?pid=183
JOIN Types the following is a summary of http://www.tek-tips.com/faqs.cfm?fid=4785
**********************************************************
– INNER JOIN
**********************************************************
Ex.
SELECT Team.Name, Matches.id
FROM Team INNER JOIN
Matches ON Team.id = Matches.HomeTeam
Note:
Returns all rows in which a column on the left table matches one on the right.
**********************************************************
– OUTER JOIN
**********************************************************
1) LEFT OUTER JOIN:
Ex.
SELECT Team.Name, Matches.id
FROM Team LEFT OUTER JOIN
Matches ON Team.id = Matches.HomeTeam
Note:
Similar to the INNER JOIN except that for all records in which a column does not exist for the left hand side table a NULL is returned
2) RIGHT OUTER JOIN
Ex.
SELECT Team.Name, Matches.id
FROM Team RIGHT OUTER JOIN
Matches ON Team.id = Matches.HomeTeam
Note:
RIGHT OUTER JOIN – This JOIN is just like the LEFT OUTER JOIN except the Right_Table is the table that will have every one of its records in the result set and if no record is found in the
Left_Table then its columns in the result set will be NULL
3) FULL OUTER JOIN
Ex.
SELECT Team.Name, Matches.id
FROM Team FULL OUTER JOIN
Matches ON Team.id = Matches.HomeTeam
Note:
FULL OUTER JOIN – This JOIN is a combination of both. All records from both Left_Table and Right_Table are in the result set and matched when they can be on the Join_Condition when no record is found in the opposit table NULL values are used for the columns.
So a query of
**********************************************************
– CROSS JOIN
**********************************************************
Ex.
Note:
Serialization:
Advanced Serialization
http://msdn2.microsoft.com/en-us/magazine/cc163902.aspx
The process of serialization:
http://www.codeproject.com/KB/dotnet/Surrogate_Serialization.aspx
Using Masterpages and subscribing to events.
Good PAge regarding the use of masterpages
http://www.odetocode.com/Articles/450.aspx
Also discusses the adding of Javascript to a page using the
Dim script As String = “[Label1ID].innerHTML = ‘boo!’;”
Dim scriptKey As String = “SayBoo”
Dim addScriptTags As Boolean = True
Protected Sub Page_Load(ByVal sender As Object, _
ByVal e As EventArgs)
script = script.Replace(“[Label1ID]”, Label1.ClientID)
ClientScript.RegisterStartupScript( _
Me.GetType(), scriptKey, script, addScriptTags _
)
End Sub
USEMAP attribute turns the image in to a clientside image map
usemap | URL | Defines the image as a client-side image map. Look at the ‘map’ and ‘area’ tags to figure out how it works | STF |
Detect Session Timeout ASP.NET/Javascript/SQL Server
ASP.NET:
http://www.codeproject.com/KB/aspnet/Detecting_Session_Timeout.aspx
‘HOMEPAGE’ in the above example could be referred to as the login.aspx
AJAX:
http://geekswithblogs.net/AzamSharp/archive/2008/01/05/118269.aspx
JAVASCRIPT:
Detecting Session Timeout and then using javascript to provide a warning regarding timing out
http://classicasp.aspfaq.com/general/how-do-i-warn-people-when-their-session-is-about-to-expire.html
SQL:
Using SQL to maintain Session information:
http://classicasp.aspfaq.com/general/how-do-i-count-the-number-of-current-users/sessions.html
Using the Ad-rotator control to server blank png to renew session.
http://forums.asp.net/t/1191063.aspx
Some cool javascript code
ASP.NET Server.Transfer Vs Response.Direct
In essence:
Response.Redirect simply sends a message back to the browser, telling it to move to another page.
whereas
Server.Transfer conserves server resources. Instead of telling the browser to redirect, it simply changes the “focus” on the Web server and transfers the request. This means you don’t get as many HTTP requests coming through, which should ease the pressure on your Web server and make your application run faster.
Keep in mind though, because the “transfer” process can work on only those sites running on the server, you can’t use Server.Transfer to send the user to an external site. Only Response.Redirect can do that!!
Microsoft Sandcastle
Microsoft Sandcastle used to document code