How to set Start Date not to be less than today in jQuery DatePicker

minDate” parameter of datepicker widget requires to be set to achieve this purpose.

Below is a sample code on how to do this:
jQuery UI Datepicker - Default functionality
$(function() {
$( "#datepicker" ).datepicker({minDate:0});




How to maintain concurrency in SQLite Database

If you’re planning to use embedded database for your small data needs, SQLite is just a go to option. It’s faster, supports transactional (ACID) queries.

SQLite FAQs page says-“… no other embedded SQL database engine that supports as much concurrency as SQLite. SQLite allows multiple processes to have the database file open at once, and for multiple processes to read the database at once. When any process wants to write, it must lock the entire database file for the duration of its update. But that normally only takes a few milliseconds. Other processes just wait on the writer to finish then continue about their business. Other embedded SQL database engines typically only allow a single process to connect to the database at once.” (refer to:

Execute these commands before the actual query executes:

PRAGMA locking_mode = EXCLUSIVE;

This will lock whole database until you execute a:


You can use the syntax below to implement this in your code:

command.CommandText=”PRAGMA locking_mode = EXCLUSIVE; BEGIN EXCLUSIVE;“++” COMMIT;”;command.ExecuteNonQuery();



What is API and How to use it?

Have you ever used a library in C#? Yes, that’s an API. An API (Application Programming Interface is something that let’s you interact with something or with an interface.

They are just a set of functions you can call. They have their documentation on what they do, how they behave, what input(s) they need to perform as intended.

For example, using Win32 API you can interact with Windows, using Twitter API you can interact with Twitter… etc. They could be Interacting with Windows as well as Web both.

Its a doorway into the programming model that a company exposes so you can enhance or extend some capability they provide. For example, Facebook wants to help programmers develop applications that work with their platform. So they offer a library that you include with your application to access data in the Facebook system.

Basically you start using an API by downloading it’s library or development kit (SDK), reading it’s Manual (Documentation). Let’s take Facebook for an example. Go to Search for “SDK”. Download the version for your platform. Look at the samples. Try them. Change them to do something slightly different.

Refer to this link for example: demonstrates to the various use of Google Maps API.


Get Pan Card Holder Name using Pan No.

You will be able to get following details using a PAN #:

1. Sur name  2. Middle Name  3. First Name  4. Area Code  5. AO Type  6. Range Code  7. AO Number
8. Jurisdiction  9. Building Name 

Visit this link:

Enter the PAN No. If it’s a correct PAN No. you will get all the details as above. 

Enjoy !