使用存储过程

软件技术国家教学资源库建设项目软件开发素材之C源代码一、功能简介使用存储过程二、创建或搜集相关信息搜集单位重庆电子工程职业学院搜集时间20120805来源互联网三、适用对象学生、教师、C及ASPNET项目开发人员、相关技术人员等。四、功能简介存储过程的使用。五、程序代码程序名称FORM1CSUSINGSYSTEMUSINGSYSTEMDRAWINGUSINGSYSTEMCOLLECTIONSUSINGSYSTEMCOMPONENTMODELUSINGSYSTEMWINDOWSFORMSUSINGSYSTEMDATAUSINGSYSTEMDATASQLCLIENTNAMESPACESTOREDPROCEDUREAPP/FORM1的摘要说明。/PUBLICCLASSFORM1SYSTEMWINDOWSFORMSFORMPRIVATESYSTEMWINDOWSFORMSLISTVIEWLISTVIEW1PRIVATESYSTEMWINDOWSFORMSLABELLABEL1PRIVATESYSTEMWINDOWSFORMSBUTTONBUTTON1PRIVATESYSTEMWINDOWSFORMSTEXTBOXTEXTBOX1PRIVATESYSTEMDATASQLCLIENTSQLCONNECTIONSQLCONNECTION1/必需的设计器变量。/PRIVATESYSTEMCOMPONENTMODELCONTAINERCOMPONENTSNULLPUBLICFORM1INITIALIZECOMPONENT/应用程序的主入口点。/STATHREADSTATICVOIDMAINAPPLICATIONRUNNEWFORM1PRIVATEVOIDBUTTON1_CLICKOBJECTSENDER,SYSTEMEVENTARGSETRY/CLEARTHELISTVIEWLISTVIEW1COLUMNSCLEARLISTVIEW1ITEMSCLEAR/CREATEACONNECTIONSQLCONNECTIONCNNEWSQLCONNECTION“DATASOURCELOCAL“INTEGRATEDSECURITYSSPIDATABASENORTHWIND“/CREATEACOMMANDOBJECTSQLCOMMANDCMDCNCREATECOMMAND/SPECIFYTHESTOREDPROCEDURETHATISTOBEEXECUTEDCMDCOMMANDTYPECOMMANDTYPESTOREDPROCEDURECMDCOMMANDTEXT“ORDERS_BYEMPLOYEEID“/CREATEAPARAMETEROBJECTTOPROVIDETHEINPUTSQLPARAMETERPARINPUTCMDPARAMETERSADD“EMPLOYEEID“,SQLDBTYPEINTPARINPUTDIRECTIONPARAMETERDIRECTIONINPUTPARINPUTVALUECONVERTTOINT32TEXTBOX1TEXT/OPENTHECONNECTIONCNOPEN/EXECUTETHECOMMANDANDDISPLAYTHERESULTS/CREATEADATAREADEROBJECTSQLDATAREADERDRCMDEXECUTEREADER/GETTHECOLUMMNNAMESOFTHEDATAREADERANDSHOWINTHELISTVIEWSCOLUMNSFORINTI0IDRFIELDCOUNTICOLUMNHEADERCNEWCOLUMNHEADERCTEXTDRGETNAMEILISTVIEW1COLUMNSADDC/GETTHEVALUESOFEACHROWINTHEDATAREADERANDSHOWTHEMINTHELISTVIEWLISTVIEWITEMITMXWHILEDRREAD/CREATETHELISTVIEWITEMITMXNEWLISTVIEWITEM/SPECIFYTHETEXTANDSUBITEMSOFTHELISTVIEWITMXTEXTDRGETVALUE0TOSTRINGFORINTI1IDRFIELDCOUNTIITMXSUBITEMSADDDRGETVALUEITOSTRING/ADDTHEITEMTOTHELISTVIEWSITEMSCOLLECTIONLISTVIEW1ITEMSADDITMX/CLOSETHEREADERDRCLOSECNCLOSECATCHSYSTEMDATASQLCLIENTSQLEXCEPTIONE1/DISPLAYTHEERRORME