这个程序会打开几次数据库。1次还是100次 Private Sub backAddtree()
conn = New SqlConnection(mysqlDB)
conn.Open()
strSQL = "Select * From T_sort"
Adpt = New SqlDataAdapter(strSQL, conn)
Ds = New DataSet
Adpt.Fill(Ds, "T_sort")
ViewState("ds") = Ds
AddTree(0, Nothing)
conn.Close()
End Sub
Private Function GetSubFid(ByVal myNodeID As Integer) As Boolean
Dim r As Integer
Dim row As DataRow
Dim tmp As Boolean
For r = 0 To Ds.Tables("t_sort").Rows.Count - 1
row = Ds.Tables("t_sort").Rows(r)
If myNodeID = row.Item("so_fid") Then
tmp = False
Exit For
Else
tmp = True
End If
Next
Return tmp
End Function Private sub fid()
Dim i As Integer
For i = 0 To 100
Response.Write(GetSubFid(i)) '<--会不会打开100次数据库
Next
End Function Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
If Not IsPostBack Then
backAddtree()
fid()
End If
End Sub
==================随便再问一个Cache回调例子。
conn = New SqlConnection(mysqlDB)
conn.Open()
strSQL = "Select * From T_sort"
Adpt = New SqlDataAdapter(strSQL, conn)
Ds = New DataSet
Adpt.Fill(Ds, "T_sort")
ViewState("ds") = Ds
AddTree(0, Nothing)
conn.Close()
End Sub
Private Function GetSubFid(ByVal myNodeID As Integer) As Boolean
Dim r As Integer
Dim row As DataRow
Dim tmp As Boolean
For r = 0 To Ds.Tables("t_sort").Rows.Count - 1
row = Ds.Tables("t_sort").Rows(r)
If myNodeID = row.Item("so_fid") Then
tmp = False
Exit For
Else
tmp = True
End If
Next
Return tmp
End Function Private sub fid()
Dim i As Integer
For i = 0 To 100
Response.Write(GetSubFid(i)) '<--会不会打开100次数据库
Next
End Function Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
If Not IsPostBack Then
backAddtree()
fid()
End If
End Sub
==================随便再问一个Cache回调例子。
解决方案 »
- Windows控件应用于ASP.net的权限问题
- VS2008安装后找不到运行文件
- repeat控件这种写法怎么报错???请教
- MVC下要传入多个参数该怎么写??
- 新手请教TreeView的问题,在线等,急!!!!!!!!!!!1
- 从网上下载了一个三层架构的OA系统,如何着手开始研究啊?
- asp.net连接mysql...没分了。能者多劳,来帮忙啊。
- 请问一下dropdownlist选择的问题~~~
- 有关.net framework的问题
- 按钮上同时使用onClientClick()和onclick()时,onclick()不会被执行,即使onClientClick返回True
- 字符串怎样转化为字节!!!
- 这样的表格怎摸动态生成呀?!100分!超级简单!
GetSubFid 方法再循环一万次,也只open一次而已
http://blog.csdn.net/chengking/archive/2005/10/03/494545.aspx