Friday, November 12, 2010

JQuery selector tutorial

     Today I read another god article about JQuery selector tutorial. Here is a link for that.

Two great articles about JQuery in one day, amazing !!!

Happy Programming  !!!

Chirag Darji
ASP.NET Consultant & Trainer

JQuery Selector, JQuery Event Binding, JQuery “this” keyword

           Today while reading about JQuery I came across really helpful and well narrated article about JQuery Selector, JQuery Event Binding and use this key word in JQuery by Elijah Manor. You can read it here.

Happy programming !!!

Chirag Darji
ASP.NET Consultant & Trainer

Monday, August 23, 2010

Find Second Saturday and Fourth Saturday of Month

       While analyzing Payroll management system, I came across an interesting question that how can we find second and fourth Saturday of every month. As in India we still do not have five days a week in most of organization, bad humm……:( . Most of organizations offer only second and fourth Saturday off. Below is the code to find particular day of week and its occurrence in given month and year,

/// <summary>

/// Returns date for specific week day and its occurrence in month.

/// </summary>

/// <param name="DesiredDay">Perticular day of week, System.DayOfWeek</param>

/// <param name="Occurrence">Its occurrence, System.Int32</param>

/// <param name="Month">Month, System.Int32</param>

/// <param name="Year">Year, System.Int32</param>

/// <returns></returns>

private int GetDateForWeekDay(DayOfWeek DesiredDay, int Occurrence,int Month,int Year)



    DateTime dtSat = new DateTime(Year, Month , 1);

    int j = 0;

    if (Convert.ToInt32(DesiredDay) - Convert.ToInt32(dtSat.DayOfWeek) >= 0)

        j = Convert.ToInt32(DesiredDay) - Convert.ToInt32(dtSat.DayOfWeek) + 1;


        j = (7 - Convert.ToInt32(dtSat.DayOfWeek)) + (Convert.ToInt32(DesiredDay) + 1);


    return j + (Occurrence - 1) * 7;




Fig - (1) Code to find Second Saturday and Fourth Saturday of Month.

Happy Programming !!!!

Chirag Darji

ASP.NET Consultant & Trainer

Saturday, August 07, 2010

Complete Installation guide for CRM 4.0 / Step by Step guide to install CRM 4.0

        Last week I installed Microsoft Dynamic 4.0 on my virtual machine and I found that it will be helpful for beginner like me, if there is a step by step installation guide. Lets start with OS selection.

1. You can use Windows Server 2003 or later server version. I had Windows Server 2003 R2.

2. Install latest service pack for OS you installed.

3. Install Internet Information Service.

4. Install Active Directory.

5. Configure DNS Server.

6. Create new user for domain and make him member of Administrators group.

7. Install SQL Server 2005 with Reporting Service and Analysis service.

8. Configure new account as service account for Report Server and Analysis server.

9. Install Visual Studio 2008.

10. Start installation of CRM 4.0

11. Enter display name for your Organization.


12. Next step is to select installation path, you can leave this as it is or select specific folder,


13. Next select website for CRM, I choose new website with different port address in my case it was 5555 as shown in image below,


14. Next you need to enter URL for Reporting server.

15. Next you have to select Organization Unit. Click on Browse button and select the root node of your domain in my case it is chirag.


16. On next step you need to specify security account, choose the one you created in step 6. Enter the password in password textbox and click next.

17. Select your local machine as Email Router setting or select specific machine on domain which you are using at email server. I chose my local machine so localhost.

18. Once you click next you will see System Requirements screen. If Domain user, SQL Server Reporting Service and ASP.NET are installed properly you will receive no error or warning else you will receive error message. I received following errors,


19. If you receive error message for SQL Server or SQL Server Reporting Service don’t be afraid. Open Services from Start – All Programs – Administrative Tools – Services. Check whether SQL Server Agent is running. If not right click on service and select property. Select Startup Type as Automatic and click on start button.

20. Another common error is for Indexing service. Follow the steps mention in point 19 to start Indexing Service.

21. You can see a warning mentioning Verify Domain User account SPN for the Microsoft Dynamics CRM ASP.NET Application Pool account. This will usually shows when you add specific domain account for security account in step 16. You can solve this warning now or after installation by following steps mentioned at

22. If System Requirements screen show no error or warning on next step installation will be started.

23. Finally you will see following screen, this means your CRM is installed.



Happy Programming !!!!

Chirag Darji

ASP.NET Consultant & Trainer

Friday, July 30, 2010

SQL Server Date Format and Convert DateTime to particular format

    I was playing with different date format in SQL Server as need to display date in YYYY-MM-DD HH:MI:SS.MMM format. I knew there is a CONVERT function which can do this however I did not have the exact parameter value to convert my date to mentioned format. I got really use full chart on internet which provides different option and parameter value for CONVERT function. For my case syntax is

SELECT CONVERT(nvarchar(23),GetDate(),121)

You can check complete table here.

Happy Programming !!!!

Chirag Darji
ASP.NET Consultant & Trainer

Saturday, March 06, 2010

SQL Server – Maximum columns in Table, Maximum Columns in Group By, Cluster Index Per Table, Max Database Size, Maximum characters in NTEXT, NVARCHAR(MAX) and all maximum in SQL SERVER

     While reading MSDN today I came across very interested topic. This is very use full specially in interview. Link shows maximum character allow in NVARCHAR(MAX), NTEXT, VARCHAR(MAX), Maximum cluster index per table, maximum columns per table, Maximum columns per Foreign Key, Maximum Columns in Group By and so on. Here is the link from MSDN

Happy Programming !!!

Chirag Darji

Wednesday, February 17, 2010

XML Parsing Error: no element found

        Today while working with JQuery-Ajax, I found an interesting error. I have used $.ajax() function to retrieve data from remote page. While testing I found that the page always show error : XML Parsing Error: no element found. Error does not contain specific information about the source of error. The common reason for XML Parsing Error: no element found is missing closing tag for one or two html element, so I double checked everything to make sure not miss any closing(</td> </tr>) tags.

        After searching for while I found that somehow ASP.NET treat the response of page as XML document and that’s why we receive XML Parsing Error: no element found error.

        To solve this error I added a line Response.ContentType = "text/HTML" to .cs page. This line tells ASP.NET runtime that response is HTML text and not XML.

Happy Programming!!!

Thursday, January 28, 2010

JQuery Conflict with Mootool and other libraries !!! Use JQuery.noConflict()

           We all may have use JQuery in our application to build rich UI. While working with JQuery today I found that JQuery is not working on some pages where I have user mootool scripts. I search on net and found a very descriptive solution at JQuery site.

           According to this article the reason for JQuery conflict is the use of $ function. mootool and prototype.js files have their own $ function. So when we use $() and try to access JQuery (as it is shorten form of jQuery()) browser is not able to resolve which $() function it has to use. To avoid JQuery conflict we have to use jQuery.noConflict() function.

           While you read JQuery site article you may have observe the order of java script files added to web page.  Read carefully and you find that you have to add other libraries first and then add JQuery library to page. If you change the order and add the JQuery library first, either mootool(or other library which you have included) or JQuery will not work. 

Happy Programming !!!