Compared to the previous use of the shortcomings: 1. It is not possible to limit the number of records returned; 2. It is inconvenient to the bond, and it is not possible to order; 3. Simple program, but it is not easy to understand. 4. It is possible to not be easily implemented for the three or more nestings. The nested solution given this time is very easy to understand, which is easy to understand. And solve the above four problems.
The following is the main code:
ItemStyle HorizontalAlign = Left CssClass = "nav"> ItemStyle> asp: BoundColumn>
string [] strSqlArray = new string [3] { "select Top 10 IOrder, ILevel, IParentID, NavigatorID, NodeCaption, ModuleID, ModuleType from NavigatorNodes where IParentID in (", itemIndex, ");"}; string strSql = string.Concat STRSQLARRAY; String Tablename = "Subclass" itemindex;
This.dbclass.adapterfill (DS, CommandType.Text, Strsql, TableName, New OledbParameter [0]);
Dg.itemdatabase = new system.web.ui.webcontrols.dataGriditeMeventHandler (this.dg_subclass_itemdatabase;
DG.DataSource = DS.TABLES [TABLENAME] .defaultView; Dg.Database ();}} ==================== More content, welcome to visit ms.mblogger .cn / nono