String.Format(“{0:X}”, args[]) Function : C#.Net

Example: String.Format("{0:D}", DateTime.Now) = 17 Mar 2009

Symbol	Type	Representation
C	Currency:	(123.00)
D	Decimal	-123
E	Scientific	-1.234500E+002
F	Fixed point	-123.45
G	General (default)	-123 (default = 'G')
N	Number	-123.00
P	Percent	-12,345.00 %
R	Round-trip	-123.45
X	Hexadecimal	FFFFFF85
Date Time Formatting
Symbol	Type	Representation
d	Short date	07/09/2007
D	Long date	Monday, 09 July 2007
t	Short time	13:42
T	Long time	13:42:50
f	Full date/short time	Monday, 09 July 2007 13:42
F	Full date/long time	Monday, 09 July 2007 13:42:50
g	General date/short time	07/09/2007 13:42
G	General date/long time (default)	07/09/2007 13:42:50 (default = 'G')
M	Month	July 20
R	RFC1123	Mon, 09 Jul 2007 13:42:50 GMT
s	Sortable	2007-07-09T13:42:50
u	Universal sortable	2007-07-09 13:42:50Z (invariant)
U	Universal full	Monday, 09 July 2007 20:42:50
Y	Year	2007 July
Standard Enumeration Formatting
G	General (default)	Green (default = 'G')
F	Flags	Green (flags or integer)
D	Decimal number	3
X	Hexadecimal	00000003

Reference: String.Format - MSDN

Login Failed The user is not associated with a trusted SQL Server connection: SQL Server 2005

This occurs when you try to login using SQL Server user cardinals without configuring SQL Server to use Windows and SQL Server authentication.

Resolution:

[1] Open SQL Server management studio – [2] Login to SQL server using windows authentication – [3] Right click on SQL Server instance and go to properties – [4] Expand security tab and select 'SQL Server and Windows authentication mode' under 'Server Authentication'

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding - Microsoft SQL Server 2005

Symptom:

SQL Server throws an exception 'Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2) when try to connect from a remote computer. Most probable symptom for the error is TCP Port 1433 being blocked by the windows firewall in a computer running windows XP(SP2).

Solution

Scenario 1

Make sure you have enabled remote connections from the SQL Server surface area configuration and allow TCP/IP, Named Pipe protocol or combination as necessary.

• To Enable Remote connections: [1] SQL Server 2005 – [2] Configuration Tools – [3] SQL Server Surface area configuration – [4] Click on 'Surface area configuration for services and connections'.
  
• Expand [1] Database Engine – [2] Remote Connections – [3] Select Local and remote connections – [4] Select the desired protocol (In this scenario I have used TCP/IP and Named Pipes)
  
• Restart the SQL Server.
  

Scenario 2

Open TCP Port 1433 – This is the default port that SQL server use for remote connections. By default windows XP firewall deny access of this port:

• Open [1] Control Panel – [2] Windows Firewall – [4] Click on 'Add Port'
  
• Add: Name = SQL Server (Any meaningful name), Port Number = 1433 (by default, if you have changed the default port you have to make sure you enter the corresponding port number)

DATEDIFF Function - TSQL - Microsoft SQL Server 2000/2005

Ex: DATEDIFF(yyyy, applicant.DateOfBirth, GETDATE()) = 28 [age of applicant in years]

datepart - Abbriviation
year - yy, yyyy
quarter - qq, q
month - mm, m
dayofyear - dy, y
day - dd, d
week - wk, ww
hour - hh
minute - mi, n
second - ss, s
millisecond - ms
microsecond - mcs
nanosecond - ns

Managed Debugging Assistants - Microst .NET Framework

Symptom:
The CLR has been unable to transition from COM context 0x1a1a90 to COM context 0x1a1c00 for 60 seconds.
The thread that owns the destination context/apartment is most likely either doing a none pumping. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.


Possible Reasions:

1. Deadlock
2. A very long operation, which worth more than 60 seconds.

Resolution:
If execution does not trap in a deadlock
It is possible to execute an very long operation by Disabling Visual Studio’s MDA (Managed Debug Assistant)
Visual Studio 2005: To disable MDA please add or edit following registry key:

1. Run > regedit
2. Navigate to > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework
3. Set [MDA=”0”]
4. Or create MDADisable.reg file and paste following text and run it

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework]
"MDA"="0"

Please note: Always it is useful to leave MDA enable for efficient debugging. To enable MDA please set MDA=”1”


References:
Diagnosing Errors with Managed Debugging Assistants (MSDN)

New Job at Bis-Web Group

Started a new job at Bis-Web Group - Bicester

www.bis-web.com

Adding page specific scripts (java scripts), styles to web content pages: Microsoft ASP.NET

protected void Page_Load(object sender, EventArgs e)
{
    ///
    /// modify existing meta defined in master page 
    /// 
    HtmlMeta meta = Page.Header.FindControl("metaRedirect") as HtmlMeta;
    foreach (string metadata in MetaDataCollection)
        meta.Content += metadata;
    ///
    /// adding content specific styles into content page's header 
    /// 
    HtmlLink link = new HtmlLink();
    link.Href = "~/styles/default.css";
    link.Attributes["rel"] = "stylesheet";
    Page.Header.Controls.Add(link);
    ///
    /// adding content specific scripts into content page’s header 
    /// 
    HtmlGenericControl script = new HtmlGenericControl("script");
    script.Attributes["src"] = Page.ResolveUrl("~/scripts/default.js");
    Page.Header.Controls.Add(script);
}
public IEnumerable<string> MetaDataCollection { get; set; }

Could not find part of the path: Microsoft ASP.NET

Symptom: When try to view the source of an .aspx or asp.net masterpage it highlight the first line (page or master) and in the little popup it says "could not find part of the path"

Resolution: clear the content of the folder
C:\Documents and Settings\{USERNAME}\Application Data\Microsoft\VisualStudio\8.0\ReflectedSchemas

Protect file types (.xml, .doc, .html, .pdf etc.) using ASP.NET authentication: Microsoft ASP.NET

Because requests to .xml, .doc, .html, .pdf etc handled by the IIS instead of asp.net ISAPI module first it is required to configure specified extensions to be handled by the asp.net ISAPI module

How to configure custom file extension to be handled by the asp.net ISAPI module

In IIS (run ‘inetmgr’)

1. Locate the website (or virtual directory, which configured as a web application) you want to configure custom file extensions to be secured.
2. Right click and find the ‘Virtual Directory’ tab under properties
3. In ‘Virtual Directory’ tab click configuration
4. Add extension (ex: .xml) and browse aspnet_isapi.dll from the usual location (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727). If you can’t find the exact directory perform a search and locate it.
5. Uncheck ‘check that file exist’ checkbox just in case of request to a non existing file. then press ok
6. If it is local it is recommend to do a IIS reset (run ‘iisreset’) if not if it is the production server or UAT, recycle the application pool

For securing asp web applications: please review my previous post - ASP.NET Authentication

The following module was built either with optimizations enabled or without debug information: Microsoft ASP.NET

Symptom: Solution includes a web project and a class library(may be more). But can not hit any break points in class library as it says ‘no symbols has been loaded’

• Try 'Configuration Manager' – make sure all project configurations are set to ‘debug mode’ and clean the solution
• Try web config – make sure you have set [debug=’true’] in compilation section.
• Remove the assembly reference and try adding it again.

Oracle replace (XML) - Oracle 10.2 E

update affiliate set config = REPLACE(config, 'old.text', 'new.text') where id ='SADB12345';