capture data from table 1

[discusmania]

hello...

Is it possible for me to capture data from a table in web page and store the value in a table in database. for example the table field in the web page is Name , Id And Address. i want to capture the data which is listed in the table in the web page and store it in mytable in database. is it possible to do so?. If yes, how?. Hope someone can help....


thanks in advance,
Nor.

 

[FRANDAZZO]

what i would do is put text boxes in the table cells. Example:

<table border=&quot;1&quot; width=&quot;100%&quot; cellpadding=&quot;1&quot; cellspacing=&quot;1&quot;>

<tr>
<td><input type=&quot;text&quot; name=&quot;name&quot;></td>
<td><input type=&quot;text&quot; name=&quot;id&quot;></td>
</tr>

</table>

now make sure that this table is within a <form> tag. If you use the &quot;post&quot; method then you will want to use Rquest.Form , if you use the &quot;get&quot; method then you will use Request.Querystring to get the values that are inside the <input>(&quot;textboxes&quot.

To insert the values into the database read about ADO. ActiveX Data Objects. ADO allows you deal with data inside a database. There are 4 objects the:
1- Connection - is what you use to connect to the database
2-Recordset - is where your data is held when returning a resultset
3-Command - usually updates,addes,delets records
4-Parameters - is a ways to pass values to the command object that is expecting parameters as search criteria.

Good Luck,
frandazzo