Mis. coding tit-bits

   
----------------------------------------------------------------------------
--:- To Autologin to a particular database in sql, in the Sql Shortcut's Target property... 

 "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" -s VIKAS-PRODUCT -u sa -p 12345678
 ----------------------------------------------------------------------------------

  protected void btnClearCache_Click(object sender, EventArgs e)
    {
        foreach (DictionaryEntry de in this.Cache)
        {
            if (de.Key.ToString() == "AllData")
            {
                this.Cache.Remove("AllData");
            }
        }
    }

 ----------------------------------------------------------------------------------

Date Formatting in C#

  <%= String.Format("{specifier}", DateTime.Now) %>

Specifier	Description	Output
d	Short Date	08/04/2007
D	Long Date	08 April 2007
t	Short Time	21:08
T	Long Time	21:08:59
f	Full date and time	08 April 2007 21:08
F	Full date and time (long)	08 April 2007 21:08:59
g	Default date and time	08/04/2007 21:08
G	Default date and time (long)	08/04/2007 21:08:59
M	Day / Month	08 April
r	RFC1123 date	Sun, 08 Apr 2007 21:08:59 GMT
s	Sortable date/time	2007-04-08T21:08:59
u	Universal time, local timezone	2007-04-08 21:08:59Z
Y	Month / Year	April 2007
dd	Day	08
ddd	Short Day Name	Sun
dddd	Full Day Name	Sunday
hh	2 digit hour	09
HH	2 digit hour (24 hour)	21
mm	2 digit minute	08
MM	Month	04
MMM	Short Month name	Apr
MMMM	Month name	April
ss	seconds	59
tt	AM/PM	PM
yy	2 digit year	07
yyyy	4 digit year	2007
:	seperator, e.g. {0:hh:mm:ss}	09:08:59
/	seperator, e.g. {0:dd/MM/yyyy}	08/04/2007

 ---------------------------------------------------------------------------------------

HtmlTextWriterStyle

          div1.Style[HtmlTextWriterStyle.FontSize] = Unit.Pixel(10).ToString();
           div1.Style[HtmlTextWriterStyle.Color] = "red";
           div1.Style[HtmlTextWriterStyle.BorderStyle] = "solid";
           div1.Style[HtmlTextWriterStyle.BorderWidth] = Unit.Pixel(1).ToString();
           div1.Style[HtmlTextWriterStyle.BorderColor] = "red";

Posted in: WRITEPAD