外文翻译 英文文献 使用两个DropDownList过滤的主从报表Word文件下载.docx
- 文档编号:14717397
- 上传时间:2022-10-24
- 格式:DOCX
- 页数:25
- 大小:963.68KB
外文翻译 英文文献 使用两个DropDownList过滤的主从报表Word文件下载.docx
《外文翻译 英文文献 使用两个DropDownList过滤的主从报表Word文件下载.docx》由会员分享,可在线阅读,更多相关《外文翻译 英文文献 使用两个DropDownList过滤的主从报表Word文件下载.docx(25页珍藏版)》请在冰豆网上搜索。
scontentsbeingtheordersplacedbytheselectedcustomer.AGridViewwouldlistthelineitemsfromtheselectedorder.
WhiletheNorthwinddatabaseincludethecanonicalcustomer/order/orderdetailsinformationinitsCustomers,Orders,andOrderDetailstables,thesetablesaren'
tcapturedinourarchitecture.Nonetheless,wecanstillillustrateusingtwodependentDropDownLists.ThefirstDropDownListwilllistthecategoriesandthesecondtheproductsbelongingtotheselectedcategory.ADetailsViewwillthenlistthedetailsoftheselectedproduct.
Step1:
CreatingandPopulatingtheCategoriesDropDownList
OurfirstgoalistoaddtheDropDownListthatliststhecategories.Thesestepswereexaminedindetailintheprecedingtutorial,butaresummarizedhereforcompleteness.
OpentheMasterDetailsDetails.aspxpageintheFilteringfolder,addaDropDownListtothepage,setitsIDpropertytoCategories,andthenclicktheConfigureDataSourcelinkinitssmarttag.FromtheDataSourceConfigurationWizardchoosetoaddanewdatasource.
Figure1:
AddaNewDataSourcefortheDropDownList(Clicktoviewfull-sizeimage)
Thenewdatasourceshould,naturally,beanObjectDataSource.NamethisnewObjectDataSourceCategoriesDataSourceandhaveitinvoketheCategoriesBLLobject'
sGetCategories()method.
Figure2:
ChoosetoUsetheCategoriesBLLClass(Clicktoviewfull-sizeimage)
Figure3:
ConfiguretheObjectDataSourcetoUsetheGetCategories()Method(Clicktoviewfull-sizeimage)
AfterconfiguringtheObjectDataSourcewestillneedtospecifywhichdatasourcefieldshouldbedisplayedintheCategoriesDropDownListandwhichoneshouldbeconfiguredasthevalueforthelistitem.SettheCategoryNamefieldasthedisplayandCategoryIDasthevalueforeachlistitem.
Figure4:
HavetheDropDownListDisplaytheCategoryNameFieldandUseCategoryIDastheValue(Clicktoviewfull-sizeimage)
AtthispointwehaveaDropDownListcontrol(Categories)that'
spopulatedwiththerecordsfromtheCategoriestable.WhentheuserchoosesanewcategoryfromtheDropDownListwe'
llwantapostbacktooccurinordertorefreshtheproductDropDownListthatwe'
regoingtocreateinStep2.Therefore,checktheEnableAutoPostBackoptionfromthecategoriesDropDownList'
ssmarttag.
Figure5:
EnableAutoPostBackfortheCategoriesDropDownList(Clicktoviewfull-sizeimage)
Step2:
DisplayingtheSelectedCategory'
sProductsinaSecondDropDownList
WiththeCategoriesDropDownListcompleted,ournextstepistodisplayaDropDownListofproductsbelongingtotheselectedcategory.Toaccomplishthis,addanotherDropDownListtothepagenamedProductsByCategory.AswiththeCategoriesDropDownList,createanewObjectDataSourcefortheProductsByCategoryDropDownListnamedProductsByCategoryDataSource.
Figure6:
AddaNewDataSourcefortheProductsByCategoryDropDownList(Clicktoviewfull-sizeimage)
Figure7:
CreateaNewObjectDataSourceNamedProductsByCategoryDataSource(Clicktoviewfull-sizeimage)
SincetheProductsByCategoryDropDownListneedstodisplayjustthoseproductsbelongingtotheselectedcategory,havetheObjectDataSourceinvoketheGetProductsByCategoryID(categoryID)methodfromtheProductsBLLobject.
Figure8:
ChoosetoUsetheProductsBLLClass(Clicktoviewfull-sizeimage)
Figure9:
ConfiguretheObjectDataSourcetoUsetheGetProductsByCategoryID(categoryID)Method(Clicktoviewfull-sizeimage)
InthefinalstepofthewizardweneedtospecifythevalueofthecategoryIDparameter.AssignthisparametertotheselecteditemfromtheCategoriesDropDownList.
Figure10:
PullthecategoryIDParameterValuefromtheCategoriesDropDownList(Clicktoviewfull-sizeimage)
WiththeObjectDataSourceconfigured,allthatremainsistospecifywhatdatasourcefieldsareusedforthedisplayandvalueoftheDropDownList'
sitems.DisplaytheProductNamefieldandusetheProductIDfieldasthevalue.
Figure11:
SpecifytheDataSourceFieldsUsedforth
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 外文翻译 英文文献 使用两个DropDownList过滤的主从报表 外文 翻译 英文 文献 使用 两个 DropDownList 过滤 主从 报表