Ad:

ASP Discussion Thread
Marked Solved
Views: 1434

Jul 7th, 2009

save dynamically created table in sql using asp

Expand Post »

hiii
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);  
 
   }
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<b></b>:void();'  onclick='removeRow(this);'><font color='red' size='5'>-</font></a>";
oCell = newRow.insertCell();
oCell.innerHTML = "<a href='javascript<b></b>: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....

Similar Threads

filling combobox with data stored in a table in sql server in VB.NET
how to delete duplicate record in a table by using SQL query in MS SQL
Invalid Object error, yet Table already created. in VB.NET
How to access DOM table objects in an iframe with VBScript in ASP
Saving multiline text in sqlserver7.0 table from vb6 apps in Visual Basic 4 / 5 / 6

aashishn86

Reputation Points: 10

Solved Threads: 9

Junior Poster

Offline

184 posts
since Jun 2008

Permalink

Jul 14th, 2009

Re: save dynamically created table in sql using asp

You can use following code to fetch form details

(Toggle Plain Text)

'  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

punitdam

Reputation Points: 12

Solved Threads: 3

Light Poster

Offline

32 posts
since May 2008

Permalink

Jul 15th, 2009

Re: save dynamically created table in sql using asp

yups
figured that out.............
thanks...

aashishn86

Reputation Points: 10

Solved Threads: 9

Junior Poster

Offline

184 posts
since Jun 2008

Permalink

Jul 16th, 2009

Re: save dynamically created table in sql using asp

no probs.
Please mark thread as solved.

punitdam

Reputation Points: 12

Solved Threads: 3

Light Poster

Offline

32 posts
since May 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: page redirects on ASPxMenu

Next Thread in ASP Forum Timeline: ASP Email Form Sending but Content Not Being Sent

DaniWeb Message

Cancel Changes

User Name
Password