| | |
save dynamically created table in sql using asp
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
hiii
i am using the following functions in javascript to dynamically add and remove rows from a table...
i need to store these values in sql server...
can anyone show me the way to do that ??
thanks....
i am using the following functions in javascript to dynamically add and remove rows from a table...
ASP Syntax (Toggle Plain Text)
function addRow() { //add a row to the rows collection and get a reference to the newly added row var newRow = document.all("applications").insertRow(); //add 3 cells (<td>) to the new row and set the innerHTML to contain text boxes var oCell = newRow.insertCell(); oCell.innerHTML = "<input type='text' name='application_name' class='cellData' maxlength='20' style='width:220px;height:17px'size='45' title='Enter Application Name'>"; oCell = newRow.insertCell(); oCell.innerHTML = "<input type='text' name='application_add_ticket_no' class='cellData' maxlength='20' style='width:220px;height:17px'size='45' title='Enter Application Access Ticket Number'>"; oCell = newRow.insertCell(); oCell.innerHTML = "<input type='text' name='application_add_date' class='cellData' maxlength='10' style='width:220px;height:17px'size='45' title='Enter Applicatin Access Date' value='mm/dd/yyyy'>"; oCell = newRow.insertCell(); oCell.innerHTML = "<a href='javascript:void();' onclick='removeRow(this);'><font color='red' size='5'>-</font></a>"; oCell = newRow.insertCell(); oCell.innerHTML = "<a href='javascript:void();' onclick='addRow(this);'><font color='blue' size='4'>+</font></a>"; } function removeRow(src) { var oRow = src.parentElement.parentElement; document.all("applications").deleteRow(oRow.rowIndex); }
i need to store these values in sql server...
can anyone show me the way to do that ??
thanks....
rEaLITy iS aN iLLUSIOn cAUSED bY lACk oF aLCOHOL....
You can use following code to fetch form details
' Request("application_name").count to get the number of rows
For count=1 to Request("application_name").count
application_name = Request("application_name ")(count)
application_add_ticket_no = Request("application_add_ticket_no")(count)
application_add_date = Request("application_add_date")(count)
' code to store details in sqlserver will come here.
next![]() |
Similar Threads
- how to delete duplicate record in a table by using SQL query (MS SQL)
- Invalid Object error, yet Table already created. (VB.NET)
- How to access DOM table objects in an iframe with VBScript (ASP)
- filling combobox with data stored in a table in sql server (VB.NET)
- Saving multiline text in sqlserver7.0 table from vb6 apps (Visual Basic 4 / 5 / 6)
- Creating Table using SQL query from wondows Form (VB.NET)
- Is it compulsory to have atleast one Unique per table in Sql Server2000? (MS SQL)
- i have created these table can you please look at them and tell me if there are right (Visual Basic 4 / 5 / 6)
Other Threads in the ASP Forum
- Previous Thread: page redirects on ASPxMenu
- Next Thread: ASP Email Form Sending but Content Not Being Sent
| Thread Tools | Search this Thread |
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7





