html读取文本框变量,将变量放入html文本框

我有一个从SQL数据库中提取数据的脚本，将数据存储到变量中。现在我需要获取这些数据并将它们放入HTML表单(文本框？)以便他们编辑它们，然后我将运行UPDATE查询进行更新。

' Create a DataReader and execute the command

objDR = objCmd.ExecuteReader

While objDR.Read()

sale_id = objDR(0)

cust_id = objDR(1)

agent_id = objDR(2)

saledate = objDR(3)

actualamount = objDR(4)

contractid = objDR(5)

homeid = objDR(6)

End While

strSuccess.Text = "

Sale ID #" & agent_id & " and " & actualamount & "

"

strSuccess.Visible = "True"

' Close all objects

objDR.Close

objCmd.Dispose

objDBConn.Close

End Sub

CUSTOMERS table

Oracle sales table contents

Sale Amount: