Get Hidden Field value in Jquery

$("#hdTest").val();

Set Hidden Field value in Jquery

$("#hdTest").val("MyValue");

Make Button visible in jquery

$("#btnTest").show();

Hide button with jquery

$("#btnTest").hide();

Set TextBox Readonly with jquery

$("#txtDemo").attr("readonly", true);

Select Day from Date in Sql Server

SELECT Day('2015-03-05 23:15:36.710')

-- Result: 5 

Select Month from Date in Sql Server

select MONTH('2015-03-05 23:15:36.710')

-- Result: 3 

Select Year from Date in Sql Server

SELECT YEAR('2015-03-05 23:15:36.710')

-- Result: 2015

Drop Down Data Binding in Asp.Net

DataTable data = GetData();

ddrLocationList.DataSource = data;

ddrLocationList.DataTextField = "Name";

ddrLocationList.DataValueField = "ID";

ddrLocationList.DataBind();