Tham khảo tài liệu 'practical database programming with visual c#.net- p7', 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 Microsoft Access 2007 Database 323 ShowFaculty A B D private string ShowFacultyfstring fName string strName switch fName case Black Anderson strName break aaae Ying Bai strName break case Satish Bhallp strName p Satishjpp break haep r strName JohpsNn .jpg j braak haep r strName braak haep r strName b raa k hajp r strName Aagieejpg b raa kr case Jeff Henry strName Henehhpa braa kr default strName NoMatc braakr 1 if strName NoMatch a strName 1 rrrName Coding for the ShowFaculty method. Figure faculty. Five label controls boundtothe associated columns in the Faculty table are updated with the queried information and the selected faculty image is also displayed in the PhotoBox control which is shown in Figure . You can try to select the different method by clicking on tbe drns-down nr row I som the Method comboSox. Yac the project works ficewitOall -Creemcthods wsSdoutany pstblcmatriO 324 Chapter 5 Data Selection Query with Visual C .NET BCSEDEPT Faculty Form Name and Method Faculty Name Jenney King luftry Method LIMQ . Object Method Figure Running status of the Faculty form. Our next jobis to do thecodingfor the Course form. QueryData Using Runtime ObjectsforCourse Form Three data query methods will be used for the data query on this form DataAdapter DataReader and wedid forthe FacultyForm wealsoneedtousethe OleDb data provider to perform the data query in this CourseForm. Thus first we need to add ongmorenamtspace intothe ncmesprcecectiononthe code window cfCOOfoem. Openthe cedewindow anb edd c i t. r r . to the narneecacepartottmisform. Next we needtocneateaslass-level textbox array. CourseTextBox 6 end a dess level DataSet object ds. The textbox array is used to temporarily save five
