Grid Javascript

function CheckBoxForScreenEmpty()
{
var flag=false;
var TargetBaseControl = document.getElementById('ctl00_ContentPlaceHolder1_grdTransaction');
for(var i=0; i< TargetBaseControl.rows.length;i++)
{
if(TargetBaseControl.rows(i).cells(0).children(0)!=null)
{
var theGridViewCheckBox = TargetBaseControl.rows(i).cells(0).children(0);
var ckb=TargetBaseControl.rows(i).cells(0).children(0).all[0].checked;
var txt=trim(TargetBaseControl.rows(i).cells(2).all(0).value);
if ( ckb == true && txt=='')
{
alert('transaction view name cannot be empty!');
TargetBaseControl.rows(i).cells(2).all(0).value=txt;
TargetBaseControl.rows(i).cells(2).all(0).focus();
return false;
}
}
}
}

Cursor Use

This is my First Blog on Database, that how to use the Cursor.
simple example of cursor is:-


--Copy Department for ScenarioId
DECLARE Cur_Department CURSOR
FOR SELECT DepartmentID FROM Department
WHERE ScenarioID=@intScenarioID AND (Deleted IS NULL OR Deleted=0)
OPEN Cur_Department
FETCH NEXT FROM Cur_Department INTO @intOldDepartmentID
WHILE @@FETCH_STATUS=0
BEGIN
INSERT INTO Department
(
ScenarioID,
DepartmentName,
DepartmentX,
DepartmentY,
DepartmentW,
DepartmentDescription
)
SELECT @intNewScenarioID,
DepartmentName,
DepartmentX,
DepartmentY,
DepartmentW,
DepartmentDescription
FROM Department
WHERE ScenarioID=@intScenarioID AND DepartmentID=@intOldDepartmentID AND (Deleted IS NULL OR Deleted=0)
FETCH NEXT FROM Cur_Department INTO @intOldDepartmentID
END
CLOSE Cur_Department
DEALLOCATE Cur_Department


this simple example show how to copy the previous record.

Thanks And Regards
MAHINDRAKAR G GANGADHAR