Finding column name on SQL Server database

SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%DocumentID%'
ORDER BY schema_name, table_name;

Sorting a Dictionary via a list

Sample of sorting a dictionary


  Dictionary dictionary = new Dictionary();
            dictionary.Add(0,"cat");
            dictionary.Add(1,"dog");
            dictionary.Add(2,"Tiger");
            dictionary.Add(3,"Rat");
           
            //// Sort the dictionary
            List> result = new List>(dictionary);
            result.Sort(delegate(KeyValuePair first, KeyValuePair second) 
            {
                return first.Value.CompareTo(second.Value);
            });

History vs Aliens

There are wonderful and curios couple of videos on history channel. It is all about the unimaginable creations of history.

ASP.NET Inline coding

http://weblogs.asp.net/ahmedmoosa/archive/2010/10/06/embedded-code-and-inline-server-tags.aspx

Entrypting SQL server database 2005

http://blogs.microsoft.co.il/blogs/applisec/archive/2008/06/15/microsoft-sql-server-2005-database-encryption-step-by-step.aspx

Send html page directly to the default printer without showing print dialog box

[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>title>
<object classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height="0" id="WB" width="0">
object>

<script language="JavaScript">
DA = (document.all) ? 1 : 0
script>

<script language="VBScript">

'sub print()
'OLECMDID_PRINT = 6
'OLECMDEXECOPT_DONTPROMPTUSER '= 2
'OLECMDEXECOPT_PROMPTUSER '= 1
'on error resume next
'IE4 object has different command structure
'if DA then
'call 'WB.ExecWB(OLECMDID_PRINT, 'OLECMDEXECOPT_DONTPROMPTUSER,1)
'else
'call 'WB.IOleCommandTarget.Exec(OLECMDID_PRINT ',OLECMDEXECOPT_DONTPROMPTUSER,"","")
'end if

'end sub

'This will be interpreted during loading.
'It will write out the correct webbrowser object depending
'on the browser version. To be sure it works, make sure you
'include this script block in between the body tags.

if DA then
'this must be IE4 or greater
wbvers="8856F961-340A-11D0-A96B-00C04FD705A2"
else
'this must be IE3.x
wbvers="EAB22AC3-30C1-11CF-A7EB-0000C05BAE0B"
end if

document.write ""

script>

<style type="text/css">
#form1
{
height: 275px;
}
style>
head>
<%----%>
<body>
<form id="form1" runat="server">
<asp:Button ID="Button1" runat="server" onclientclick="window.print();"
Text="Button" />
<br />
<iframe src="Test.pdf" width="500px" height="500px">
this is test
iframe>
form>
body>
html&gt;

Callback vs Postback

http://stackoverflow.com/questions/365100/difference-between-a-postback-and-a-callback