Converting Text to Proper Case or Capital Case or Lower Case in Access

Problem:
Convert text in different format like CAPITAL CASE, lower case and Proper Case in access.

Solution:
You user StrConv fuction for all case.

OR

For UPPER CASE Use UCASE();
For lower case use LCASE();

Syntax:

1) StrConv Function:
StrConv(Target String, Conversion Type)

Target String is a string which you want to convert the string in different case.
Coversion Type:
1 – Converts the string to uppercase characters.
2 – Converts the string to lowercase characters.
3 – Converts the first letter of every word in string to uppercase.

2) UCASE and LCASE

UCASE(Target String)

LCASE(Target String)

Examples:

For CAPITAL CASE.

Select StrConv("Target String", 1); Return: TARGET STRING

For lower case.

Select StrConv("Target String", 2); Return: target string

For Proper case.

Select StrConv("target string", 3);  Return:  Target String

Extension method to check Null or Not Null in C#

we follow to check null reference.

if (o != null)
{    //Do Something}else{    //Do Something completely different}

but we follow extension method then make it easy coding like.

public static class ExtensionCommon  {    public static bool IsNull(this object obj)    {      return obj == null;    }     public static bool IsNotNull(this object obj)    {      return obj != null;    }     public static bool HasValue(this string obj)    {      return !string.IsNullOrWhiteSpace(obj);    }  }

and do code like that

if (obj.IsNotNull)
{    //Do Something.}else{    //Do Something.}

OR

if (!obj.IsNull)
{    //Do Something.}else{    //Do Something.}

Create Setup Project in Visual Studio.

I show basic setup step.

Steps:
1.Create sample windows application project.
2.Now add Setup project in same solution.

3.Select setup project.

4. Now add project output by right click on Application Folder.

Certificate's private key grants access to the application pool user

• Open the certificates MMC.

             Download file hear and open it or manual Step below.

• Open MMC
• Click File –> Add/Remove Snap-in…
• Choose Certificates and click Add
• Select Computer Account and click Finish

• Check if the certificate is available in the "Local Computer\Personal" cert store.
• 
  
• Right click on the certificate and choose "All Tasks --> Manage Private Keys" and "IIS_IUSRS" or other user or app pool account that the IIS 7.5 app pool is using (ApplicationPoolIdentity).

>> Click on Location and select top most item.

>> Then write "IIS_IUSRS" in object box. then click ok.

Enjoy........

Source: http://bartwullems.blogspot.in/2012/02/grant-iis-75-access-to-certificate-in.html

Solving Error 1001 : The specified service has been marked for deletion

If you are creating Windows Services you may run into this annoying little error from time to time,

Error 1001. The specified service has been marked for deletion

At first I used to restart my machine to get rid of it, but there is a (much) simpler way.  

Simply closing the Services Manager (services.msc or the mmc.exe tool) will solve it 

Enjoy it.....

Source : http://www.laxdal.org/node/30

Regular Expression for US Phone Number

>>  Criteria


Validates a U.S. phone number. It must consist of 3 numeric characters,
optionally enclosed in parentheses, followed by a set of 3 numeric characters and
then a set of 4 numeric characters.


>>  For Example


(425) 555-0123

425-555-0123

425 555 0123

1-425-555-0123

>>  Regular Expression

"^[01]?[- .]?(\([2-9]\d{2}\)|[2-9]\d{2})[- .]?\d{3}[- .]?\d{4}$"

Refence:

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

Make 'Associate' the default checkin action in TFS

Problem:

I don't like to change every time 'Resolved' to 'Associate' when I m check –in in TFS so I am start googling for this issue and finally I got the solution.

Solution:

 There is no alternate way to change registry, so change the registry for TFS configuration. 

Change value the following key to “False”.

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\TeamFoundation\SourceControl\Behavior 

Set value of ResolveAsDefaultCheckinAction = False.

OR

One Click Solution

If u doesn’t want to change manually then download this file and just double click on this file.

now u enjoy..............

Download File Here

Ref:

http://www.ewaldhofman.nl/post/2010/11/19/Make-e28098Associatee28099-the-default-checkin-action.aspx

http://blogs.msdn.com/b/mitrik/archive/2010/12/03/how-to-make-associate-the-default-action-for-work-items.aspx