How To:Update a textbox with the current record of a database.

aviles22 · Sep 4, 2000

I have been trying to do this for quite some time. I am very stumped and anxious to learn the solution. I am using vb script with an access 2000 database. I know how to change the recordsets navigate through it and display the current record using response.write. But how can I assign a textbox to bind to my recordset or simply just use textbox1.text = recordset1.fields("fieldname1&quot

. ANY INFO WOULD BE HIGHLY APPRECIATED! THANK YOU

FengShui1998 · Sep 12, 2000

<html>
<body>

<%
' Try this as an ASP page.
' Make your connection first to your database
Set Conn = "Connection object here"
Set rs = Server.CreateObject("ADODB.Recordset&quot

strSQL = "SELECT * FROM dbtable WHERE rec='rec_id'"
rs.Open strSQL, Conn
Do While NOT rs.EOF
response.write "<input type=text name=textbox1 value='" & rs.field("field1&quot

.value & "'>"
response.write "<input type=text name=textbox2 value='" & rs.field("field2&quot

.value & "'>"
rs.movenext
Set rs = nothing
conn.close
Set conn = nothing

%>
</body>
</html>

------------
Fengshui1998 [sig][/sig]

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How To:Update a textbox with the current record of a database.

aviles22

Programmer

FengShui1998

MIS

Similar threads

Part and Inventory Search

Sponsor