Click Label to Access Form Control

1.Using the label element allows the user to click on the text associated with the form control instead of having to click the radio button, check box, select box, etc.

2.To associate a label with another control implicitly, the control element must be within the contents of the Label element. In this case, the Label may only contain one control element. The label itself may be positioned before or after the associated control.

Example:-

<html>
<body>
// For Radio Button
<label for="radio1">Radio Button - Click this Label</label>
<input type="radio" value="Selected" name="Radio" id="radio1">
// For CheckBox
<label for="check">Checkbox - Click this Label</label>
<input type="checkbox" value="Selected" name="check" id="check">
</body>
</html>

Demo Link

Absolute Position for Controls in Asp.net

By default for controls placed in the designer the layout position is as 'Not Set' thus we cannot drag the control to a specified location.


We have to change the layout position to absolute position to achieve that.

In Visual Studio we can make the default postion as we need.For that we have to enable the css postioning of controls.

Here is how we can do

1. Go to Layout->Position->Auto-position Options->HTML Designer–>CSS Styling

or

2. Go to Tools->Options->HTML Designer–>CSS Positioning

And check “Change positioning to the following for controls added using Toolbox, paste or drag and drop” and select the postion you perfer.Here we select Absolute Positioning.

Now we can move the controls placed in the designer with absolute positioning.

The Given Procedure is for Visual Studio 2005 which is same for Visual Studio 2008.

Using OVER() with Aggregate Functions in Sql Server 2005

1.you can now add aggregate functions to any SELECT (even without a GROUP BY clause) by specifying an OVER() partition for each function.

2.SUM(..) OVER(..) is most useful for calculating a Total or percentage of a total for each row

3.SUM() function works with any of the other aggregate functions as well, such as MIN() or AVG()

Partition by

Divides the result set into partitions. The window function is applied to each partition separately and computation restarts for each partition.

select
StudentId,
StudentName,
Subject,
Mark,
sum(Mark) OVER (Partition by StudentId) as Total
from
Student

Output
=====
StudentId StudentName Subject Mark Total
======= ========== ===== ==== =====
1 Raja Physics 80 240
1 Raja Maths 90 240
1 Raja Biology 70 240
2 Sam Physics 90 150
2 Sam Maths 60 150

Split Function in Javascript

Split Function: Delimiter :-
The space character " " we mentioned will be our delimiter and it is used by the split function as a way of breaking up the string. Every time it sees the delimiter we specified, it will create a new element in an array. The first argument of the split function is the delimiter.

Split() Function:-
The split() function splits text and puts the pieces into an array, with each piece taking up one slot in the array. For example, if you were to split "This is some text",the split() function would create an array with four slots (zero to 3). The first slot in the array would contain "This", the second slot would contain "is", the third "some" and the fourth "text".

Example:-

var stringdata= "1$2$3$4";

var splitdata = stringdata.split("$");

for(i = 0; i < splitdata .length; i++)
{
document.write("Element " + i + " = " + splitdata [i]);
}
Output
=====
Element 0 = 1
Element 1 = 2
Element 2 = 3
Element 3 = 4

Date Function in Javascript

1.create a date object and store it in a variable

var d= new Date();

2.Using the date object,Get the hour,minute,second,month,dayofmonth and year of the Current Date

var hour = d.getHours();
var minute = d.getMinutes();
var second = d.getSeconds();
var month = d.getMonth();
var dayofmonth = d.getDate();
var year = d.getYear();

Example:-
Display Next Day of Today

function getNextDate()
{
var date= new Date();
var day = date.getDate();
var month = date.getMonth();
var year = date.getYear();

var nextdate= new Date(year, month, day +1);
var nxtDate=nextdate.getMonth()+1+"/"+nextdate.getDate()+"/"+NextDate.getYear();
document.getElementById('DisplaynextDate').value=nxtDate;
//Display Next Date(today+1)
}