Data Access Hierarchical - Course ASP.NET 4 and Visual Studio 2010 - Part 44 | .net courses

Duration:  18 minutes

Summary: In the previous videos we discussed list and tabular databound controls. In the video, we will talk about Hierarchical databound controls. We will create a page that contains a menu and a treeview. The data source for these two controls is an xml file. We used the Books.xml files that we had from the xml video discussions. Then we moved to the subject of parameterized grids. In most cases you need to data in the grid to be driven by some type of parameter. For this purpose ASP.NET supports different parameters like ControlParameter, CookieParameter, FormParameter, QueryStringParameter, and SessionParameter. In our example we use the ControlParameter. We added a dropdown list that contains ‘Male’ and ‘Female’. We added a grid under the dropdown that lists the employees in the HumanResources schema. We modified the data source and added the parameter to tie the Gender field in the table to the dropdown list. That way when the user selects from the dropdown , the records in the grid will be refreshed accordingly.

Methodology of the development of example: Good coding standard and simplified design to illustrate the key points.

Technology Used: ASP.NET and Visual Studio 2010

Keyword: ASP.NET 4, Visual Studio 2010, Menu, TreeView, DataSource ControlParameter, CookieParameter, FormParameter, QueryStringParameter, and SessionParameter, XML.