Wednesday, February 18, 2015

Using jQuery validate plugin in Asp .Net to validate dropdownlist

The jQuery validate plugin can be used in HTML page validations. It can be easily integrated to ASP.Net forms validation as described below.

1. In the header (or in the content page if you are using master pages) put references for jQuery and jQery validator plugin.

2.In general it is recommended that you wire form validation in the DOM ready event of the jQuery. But if you are using update panels you should wire up these events in the pageLoad. In this example I am validation a dropdown list with a default value "(not set)".  This is achieved using the jQuery.validator.addMethod  as shown below.

              jQuery.validator.addMethod("defaultInvalid", function (value, element) {
                switch (element.value) {
                    case "(not set)":
                        if ( == "<%= ddlCountry.UniqueID %>") return false;
                        return true;

3. Next include the controls to be validated in the form validate method. Remember to include the defaultInvalid: true attribute to validate the default value.


                rules: {
                    "<%= ddlCountry.UniqueID %>": {
                        required: true,
                        defaultInvalid: true
                messages: {
                    "<%= ddlCountry.UniqueID %>": "* Required"
4. Finally define the IsValid() that is called on Update click,

 function IsValid() {
            var isValid = $("#form1").valid();

            if (isValid) {
                return true;
            return false;
The trick is to call the IsValid function on the OnClientClick event of the Update button.

Sunday, February 8, 2015

visual studio 2010/2012/2013 nuget error "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel"

I recently came across this issue when trying to launch the nuget package manager. It seems this issue is common to all  VS2010,2012 and 2013 versions. Follow these steps to solve the issue.

Go to VS2010/2012/2013  -> Tools -> Library Package Manager -> Package Manager Settings
Choose Package Manager -> Package Sources.
1. Add a new package source as:
Name= NugetSrc
2. Move Up the newly added package source to the first position.
3. UnCheck existing "Nuget official package source"
4. Restart VS2010/2012/2013


Monday, February 2, 2015

Find and replace text in a file in c#

The easiest way to find and replace text in a file is to use the Replace method of string as shown below.

string content= File.ReadAllText("FileName.txt");
text =
content.Replace("find text", "replace text");
FileName.txt", text);

You can use the Regex.Replace method for more complex replacements


Thursday, January 22, 2015 Closing child windows from JavaScript

These maybe situations where we use some of the additional information displayed  using method. It can cause issue if we keep these open widows when dealing with different user logins within the system.

The solution is to store all opened windows in an Javascript array and close them on logout or navigation to other links or menu options.

 var openWindows = new Array();

function OpenWindow(url){

We can use the window.onbeforeunload event to close the opened windows as shown below.

   window.onbeforeunload = function () {

 function closeWindows() {
            for (i = 0; i < openWindows .length; i++) if (openWindows [i] && !openWindows[i].closed)


Friday, January 16, 2015

SQL Server check nemeric

There can be situations where you want to check whether a field is a numeric or not. SQL Server provides ISNUMERIC() function to achieve that purpose as shown below.

SELECT case when IsNumeric(cmp) = 1
       then cast(cmp as int)
       else 0 end   FROM Transactions)

This can be easily included in a where clause as follows

select * from Transactions 
where (case when IsNumeric(cmp) = 1
       then cast(
cmp as int)
       else 0 end) >= 7


Friday, December 19, 2014

Easy clipboard management tool for .Net

Ditto is an extension to the standard windows clipboard. It saves each item placed on the clipboard allowing you access to any of those items at a later time.

Read more and download