Question

asp.net如何从数据库读取一个字段的值然后赋值给一个参数

asp.net如何从数据库读取一个字段的值然后赋值给一个参数？
就像asp中的username=rs("username")一样，请问怎么是实现呀？

Answer 1

Dim conn As SqlConnection
Dim cs As SqlCommand
Dim rs As SqlDataReader
Dim sql As String
Dim UserName as string

sql = "select * from [User] where id=1"
conn = New SqlConnection(Application("conn"))
cs = New SqlCommand(sql, conn)
conn.Open()
rs = cs.ExecuteReader()
If rs.Read Then
UserName = Trim(rs("UserName"))
End if
rs.close()
conn.close()