asp.net如何从数据库读取一个字段的值然后赋值给一个参数
答案:1 悬赏:70 手机版
解决时间 2021-01-30 03:33
- 提问者网友：十年饮冰
- 2021-01-29 05:32
asp.net如何从数据库读取一个字段的值然后赋值给一个参数？就像asp中的username=rs("username")一样，请问怎么是实现呀？
最佳答案
- 五星知识达人网友：举杯邀酒敬孤独
- 2021-01-29 06:08
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()
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()
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯