Number type input fields validation using JQuery

Using JQuery it is easy to validate numeric data in input fields.

Below code validates numeric input in the input type fields.
For this we only need to add .number as class for the input html tags in which we need to validate numeric data.

$('input.number').blur(function () {

    var value = $(this).val();

    if (value == undefined || value == "") {

        $(this).parent().find("span").remove();

        return;

    }

    if (isNaN(value)) {

        $(this).parent().find("span").remove();

        $(this).parent().find("br").remove();

        $(this).parent().append("</br><span class='error'>Please Enter Number</span>");

    }

});

Above blur event shows the Please Enter Number error message just after user moves cursor from input field.

Creating SharePoint 2010 List Instances in Visual Studio 2010

We can easily create SharePoint 2010 List instances using visual studio 2010

Advantages:- 

• If there is no need of custom list in any other SiteCollection other than in one site, it is no meaning to create list definitions. Instead we can create one list instance and deploy it to site directly.

• After creating the new list instance we can add list data to Element file which will reduce the burden of creating list items every time that we deploy solution and even it will helps in the time of production site deployment.

Steps to Create:-

1. In visual studio 2010 click on File -> New project then new project window will open.
2. Then in Installed templates section of opened window select                     Visual C# ->SharePoint ->2010 -> then Empty SharePoint Project -> enter project name  -> then Ok - > Enter your site name and click on create. It will create project in visual studion.                                                                    
3. After this in Solution Explorer Right click on your project then click on Add -> New item.
4. Now in opened window select Online Templates -> List Instance and name your List then click on Add. 
5. Now new List instance is added to your folder.

SSRS 2008 R2 Export to Excel Hiding Columns

When I started working on SSRS in my learning days it took lot of my time to solve empty/hidden columns in excel after exporting from report.

Normally if you use only list control in your report without any other controls, we can export clean excel without any empty columns. But if there are any controls along with list control in your report, you have to concentrate more on alignment of each control to get proper excel export.

Hidden columns are result of small deviations in widths of controls.

For Example let us take one rectangle control for header and list control for users information in one Report as shown in Picture-1

Picture -1

Picture - 2

As shown in Picture 1, rectangle width is 1.0025 inches and list column width is 1.00 inches so because of 0.0025 difference in widths we will get column B as hidden in exported excel sheet as shown in Picture 2.

• To avoid hidden columns maintain widths with rounded values.
• If there are two or more controls above the list control, make sure each control is side by side and the width of each control is as integral multiple of list column width.

Calling synchronous method asynchronously in .Net 3.5

• We can call the methods asynchronously using custom  delegate that has an exact signature of method that you want to call asynchronously.

• To know the completion status of the asynchronous method AsyncCallback delegate can be used.

      Below example illustrates the Asynchronous method execution.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace AsyncDemo

{

    class Program

    {

        static void Main(string[] args)

        {

            AsyncDemo ad = new AsyncDemo();

            AsyncDelegate asyncDelegate = new AsyncDelegate(ad.AsyncDelegate);

            AsyncCallback callback = new AsyncCallback(ad.Status);

            IAsyncResult result = asyncDelegate.BeginInvoke(callback, null);

            Console.WriteLine("Async method execution is running and status of completion is {0}", result.IsCompleted);

            Console.ReadLine();

        }

    }

    public delegate void AsyncDelegate();

    public class AsyncDemo

    {

        /// <summary>

        /// Method that executes asynchronously

        /// </summary>

        public void AsyncDelegate()

        {

            int a = 0;

            for (int i = 0; i < 2000000000; i++)

            {

                a += i;

            }

            Console.WriteLine("total  {0}", a);

        }

        /// <summary>

        /// Callback method that is invoked after the completion of async method execution

        /// </summary>

        /// <param name="result"></param>

        public void Status(IAsyncResult result)

        {

            Console.WriteLine("Async method execution is completed");

        }

    }

}

For more information follow the link http://msdn.microsoft.com/en-us//library/2e08f6yc.aspx

How to read CSV file using FileHelperEngine


In below program File.csv contains the all the info of students.

"ReadAllText" static method of  File class is used to read all the csv file

then resulted string is passed as a parameter to ReadString instance method 

of FileHelperEngine class which returns the Student type array.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using FileHelpers;

using System.Configuration;

namespace My_console_app

{

    class Program

    {

        static void Main(string[] args)

        {

            string fileData = File.ReadAllText("C:\\File.csv");

            FileHelperEngine engine = new FileHelperEngine(typeof(Student));

            engine.ErrorManager.ErrorMode = ErrorMode.SaveAndContinue;

            Student[] records = (Student[])engine.ReadString(fileData.Replace("\0", ""));

        }

    }

    [DelimitedRecord(",")]

    [IgnoreEmptyLines(true)]

    public class Student

    {

        [FieldQuoted('"', QuoteMode.OptionalForBoth)]

        public int Id;

        [FieldQuoted('"', QuoteMode.OptionalForBoth)]

        public string Name;

        [FieldQuoted('"', QuoteMode.OptionalForBoth)]

        public string Email;

    }

}

Here Student[] records contains all the students info as array.