Tham khảo tài liệu 'practical database programming with visual c#.net- p8', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Query Data Using Runtime Objects to SQL Server Database 373 SQLSelectRTObject - Microsoft Visual Studio 8 File Edit View Project Build Debug Data Tools Test Window Help _ J -J a - .TA X Output r 4 X Show output from Database Output 33 Running dbo . StudentCourseInfo 0StudentID J77896 . course id CSC-335 CSC-234A CSC-439 CSC-432 CSB-439 CSC-333A No rows affected. 6 row s returned 0RHTUPN_VALUB - 0 Finished running dbo . StudentCourseInfo . I Ready Ln 15 Col 1 Ch 1 INS Figure Testing result for our second stored procedure. C. The FindName function is executed to get the student s photo file based on the student s name. There t urnedstudent si mageii leis assignedtothe local string variable strName. D. The user-defined method BuildCommand is called to initialize the first Command object with the coiTeetComiseti . as dGoosmandTexi execute our storedptoesnsottthenaopertist shouldbesetaalollowsi CommanOTape CommandTmee .StonedPrTceeLumd CommanTTeTt sSO The contentoftheCommandTe xtmustbeequal tothenameofthe stored procedure we developed above. E. The unique input parameter to the stored procedure is StudentName which will lisi dbytSeiiser item Sha stdilenS same ammOont e as the p imjseS. runs. Thiedynamic parameter must be added into the Parameters collection gEs One point you need to note is that if you are using SQL Server Management Studio Express to build your database in some situations you cannot connect the server to open the database if you are performing some tasks with the Server Explorer such as creating stored procedures be raeseyourseimeehae Omt. csneected ondthedatabeseis openwSen yee creete stored procedsee ere or meesagewsuee im eSsplayed iey .entile do detsinca thissesston only allowt 11 . eStheseeeerto ie esnnecied at connectionfirstdyeeboettngyour seenputee. 374
