Mirth : Add parameter in database query

Problem:

Insert / Update database field value using param.

Solution:

//Add param.
params = new java.util.ArrayList();

var paramValue = 'SomeValue';

//Add param Value in param array.

params.add(paramValue);

//Insert / Update in DB.
dbCon.executeUpdate('INSERT INTO tableName (?) VALUES ("' + SomeValue + '")', params);

$(document).ready vs. $(window).load

jQuery offers two powerful methods to execute code and attach event handlers: $(document).ready and $(window).load. The document ready event executes already when the HTML-Document is loaded and the DOM is ready, even if all the graphics haven’t loaded yet. If you want to hook up your events for certain elements before the window loads, then $(document).ready is the right place.

$(document).ready(function() {
 // executes when HTML-Document is loaded and DOM is ready
 alert("document is ready");
});

The window load event executes a bit later when the complete page is fully loaded, including all frames, objects and images. Therefore functions which concern images or other page contents should be placed in the load event for the window or the content tag itself.

$(window).load(function() {
 // executes when complete page is fully loaded, including all frames, objects and images
 alert("window is loaded");
});

Format dates in SSRS reports

Displaying dates in different formats in your reports is a very common requirement that one faces while working with Sql Server Reporting Services (SSRS).

Let us see how we can display dates in different formats :

=Format(Fields!myDate.Value, “M/d/yy”) - 2/11/08

=Format(Fields!myDate.Value, “MM/dd/yyyy”) - 02/11/2008

=Format(Fields!myDate.Value, “d-MMMM-yy”) - 11-December-08

=Format(Fields!myDate.Value, “d-MMM-yyyy”) - 11-Dec-2008 =Format(Fields!myDate.Value, “M/d/yyyy H:mm”) - 2/11/2008 13:50

=Format(Fields!myDate.Value, “MMM-dd-yyyy”) - Feb-11-2008

Original Source: http://www.sqlservercurry.com/2008/02/format-dates-in-ssrs-reports.html

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