The use of unlimited-class extension of TreeView nodes (original)
vb.net and oracle9i operating environment
As a result of a large amount of data, so can not use the result set rs read out, in the treeview nodes to fill.
Tree nodes need to fill in data fields in the form of "." Partition
Such as: 01 01.01 01.02 01.01.01 02 02.01 02.01 ............................
Instr function using its own oracle, you can press "." Partition number. And return the required result set, initialized to load non-reads. "" Field, the first reading with a "." ... ... ... ...
sql statement broadly written as follows:
If pDotCount = 0 Then
sqlString = "select t. was necessary to split the field, t.cname from table t where Instr (t.icsn,''''.'''', 1, 1) = 0"
sqlString = "select t. was necessary to split the field, t.cname from table t where Instr (t.icsn,''''.'''', 1," & pDotCount & ")> 0 and Instr (t . icsn,''''.'''', 1, "& (pDotCount + 1) &") = 0 and Instr (t.icsn ,''''" & pParent & "'''', 1, 1) = 1 "
pDotCount need to read the field "." the number of
And then by double-clicking the event was the father of the node (the node is selected), sql statement pParent, to return to the parent node is a subset of the nodes, so that one can double-click an unlimited expansion of the data up until the last layer of until
Search position any node
The main node is the initial choice of location. Omitted here, who are interested can contact me directly and, learn from each other.
.Net Windows development Articles
- Record some information about testing tools NUNIT link to information, interested friends can jump in the past to see if
- Given natural number four 1-9, calculate the number of 4 obtained after 24 +,-,*,/ computing algorithm
- Writing and. NET Properties window to interact RAD components (preface)
- Certificates and signatures - try Microsoft certification testing tools provided by the series of
- Solution "does not allow the type System.DelegateSerializationHolder and derived from the type (for example, System.DelegateSerializationHolder) at this security level by the anti -
- Traversal ArrayList pitfalls
- Traversal ArrayList pitfalls
- Using a Custom Action to Create a Database During Installation
- ActiveX control is packaged release [No certificate of release] (1)
- Visual SourceSafe 6.0 Consideration of the problem
- RTF expression in the image and expression of the code where the reciprocal
- WEB application using VS.NET2003 making the installation package
- Your application for registration together with the restrictions
- WEB using VS.NET2003 production application installation package (collection)
- [dotNET] how to read the configuration file ConfigurationSettings.AppSettings.GetValues more than the value with the Key
- My collection -. NET development Web site commonly used [Finishing] [top! ]
- Smart Client Case Study Source Code Download from MSDN China
- The use of unlimited-class extension of TreeView nodes (original)
- You greatly increase the speed of the page
- insert r in richtextbox Animation / control
Can't Find What You're Looking For?
Rating: Not yet rated