SqlDataReader
时间:2021-07-01 10:21:17
帮助过:25人阅读
‘新線直接(瑋柏)
2 Dim conn
As New SqlConnection(WebConfigurationManager.ConnectionStrings(
"testConnectionString").ConnectionString)
3 ‘軒瑞德
4 Dim dr
As SqlDataReader
5 ‘軒擀麵
6 Dim cmd
As SqlCommand
7 ‘擀麵=新史闊(SQL,線)
8 cmd =
New SqlCommand(
"select * from test ", conn)
9
10 ‘開線
11 conn.Open()
12 ‘瑞德=擀麵點毒
13 dr =
cmd.ExecuteReader
14
15 ‘開始毒
16 If dr.HasRows
Then
17 dr.Read()
18 Response.Write(dr(
"title").ToString)
19 End If
20 ‘關毒
21 dr.Close()
22 ‘面取消
23 cmd.Cancel()
24 ‘線關掉
25 conn.Close()
26 ‘線釋放
27 conn.Dispose()
SqlDataReader
标签:class 取消 new manage tar stc sql response str