Add Html Control and Get Contro Value (javascript)

// JScript File

//Add Html Control

 

function add(sender,q)

{

 

var tr = sender.offsetParent.parentNode.parentNode;

var table =document.getElementById ("tableselect");

if(sender.src.indexOf("delete_24.gif")>0)

{

table.deleteRow(tr.rowIndex);

}

else

 

{

var newtr=table.insertRow(tr.rowIndex+1);

var cell=newtr.insertCell(0);

cell.innerHTML=tr.innerHTML;

cell.getElementsByTagName("input")[0].value="";

var selt=cell.getElementsByTagName("select");

selt[0].options[0].selected=true;

selt[1].options[0].selected=true;

selt[2].options[0].selected=true;

sender.src="Images/delete_24.gif";

}

}

 

//Get Control Value

 

function sql(a)

{

var where=" where ";

var selt;

var table=document.getElementById("tableselect");

for(var i=0;i<table.rows.length-1;i++)

{

selt=table .rows[i].getElementsByTagName("select");

where += selt[0].options [selt[0].selectedIndex].value+" ";

where += selt[1].options [selt[1].selectedIndex].value+" '";

where +=table .rows[i].getElementsByTagName("input")[0].value+"' ";

where += selt[2].options [selt[2].selectedIndex].value+" ";

}

selt=table .rows[table .rows.length -1]. getElementsByTagName("select");

where += selt[0].options [selt[0].selectedIndex].value+" ";

where += selt[1].options [selt[1].selectedIndex].value+" '";

where +=table .rows[table .rows.length -1].getElementsByTagName("input")[0].value+"' ";

document.getElementById(a).innerHTML=where ;

}