Sunday, June 30, 2013

Jquery Date Picker in dd/mm/yyyy Format.

$(document).ready(function () {
        $('.datepicker').datepicker({
            numberOfMonths: 2,
            dateFormat: 'dd/mm/yy',
            changeMonth: true,
            changeYear: true,
            autoSize: true,
            minDate: new Date(),
            maxDate: '+363d',
            showAnim: 'fadeIn',
            yearRange: '2013:2020',
            showOn: 'focus',
            buttonImage: '/Content/images/calendar.gif',
            buttonImageOnly: 'false'
        });
    })

SQL Optimization

  SQL Optimization  1. Add where on your query  2. If you remove some data after the data return then remove the remove condition in the sel...