Question

.aspx中怎样取出具有指定属性值的一行中的某个属性值

比如说在user表中取出name="张三 "的一行的password属性的值
不要说用select password from user where name=“张三”；我是说怎样用这句话后把查到的结果取出来

Answer 1

Dim conn As New ADODB.Connection
Dim xsxx As New ADODB.Recordset
xsxx.CursorLocation = ADODB.CursorLocationEnum.adUseClient
conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./") & "\app_data\kczb.mdb")
xsxx.Open("select password from user where name='张三'"), conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockBatchOptimistic)
response.write(xsxx.fields("password")

追问

谢了，我已经搞定了，用的ExecuteReader()