ویژوال بیسیک پیشرفته ۲۰۱۰ (ویرایش پنجم)

In the Fifth Edition, Advanced Visual Basic 2010 helps those who are familiar with the fundamentals of Visual Basic 2010 programming harness its power for more advanced uses. Coverage of sophisticated tools and techniques used in the industry today include various database, ASP.NET, LINQ, WPF and Web Services topics. After studying the book and completing the programming exercises, students should be able to create small- to medium-sized Windows and Web applications that use databases. They will also gain essential concepts in object-oriented programming, event-driven programming, and test-driven development. Each subject is presented in an understandable style that makes this book a leader in the field. MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict MuPDF error: syntax error: invalid key in dict Cover 1 Title Page 2 Copyright Page 3 Contents 8 Preface 14 Acknowledgments 17 About the Authors 18 Chapter 1 Classes 20 1.1 Classes and Objects 20 1.2 Creating Your Own Classes 26 TUTORIAL 1-1: Creating a Student class 34 TUTORIAL 1-2: Adding a parameterized constructor to the Student class 39 1.3 Enumerated Types 42 TUTORIAL 1-3: Enumerated Account type 44 1.4 Focus on Program Design and Problem Solving: Bank Teller Application 45 TUTORIAL 1-4: Building the Bank Teller application 50 1.5 Manual Software Testing 53 TUTORIAL 1-5: Manually testing integer input 54 Chapter 2 Input Validation and User Interfaces 70 2.1 Input Validation 70 TUTORIAL 2-1: Using the ErrorProvider control 75 2.2 Exception Handling 78 2.3 ListBox, ComboBox, and CheckedListBox 85 2.4 Dates and Times 89 2.5 ToolStrip Control 92 TUTORIAL 2-2: Building the Coffee Shop application 95 2.6 FlowLayoutPanel, WebBrowser, SplitContainer, and TabControl 99 TUTORIAL 2-3: Creating a simple image album 101 TUTORIAL 2-4: Completing a Web browser application 105 2.7 Focus on Problem Solving: Kayak Tour Scheduling Wizard 110 TUTORIAL 2-5: Completing the Kayak Tour Wizard application 113 Chapter 3 Collections 130 3.1 ArrayLists 130 TUTORIAL 3-1: ArrayList of test scores 133 3.2 ArrayLists of Custom Objects 137 TUTORIAL 3-2: Building an ArrayList of Student objects 142 3.3 List and Dictionary Classes 145 TUTORIAL 3-3: Creating a text concordance 152 3.4 Language Integrated Query (LINQ) 158 TUTORIAL 3-4: Performing LINQ queries on a list 162 Chapter 4 Using SQL Server Databases 184 4.1 Database Basics 184 4.2 SQL SELECT Statement 189 4.3 Using the DataGridView Control 193 TUTORIAL 4-1: Showing a database table in a DataGridView control 196 4.4 Selecting DataSet Rows 204 TUTORIAL 4-2: Filtering rows in the SalesStaff table 210 4.5 Data-Bound Controls 212 TUTORIAL 4-3: Displaying the Members table in a ListBox 218 TUTORIAL 4-4: Inserting rows in the Karate Payments table 223 TUTORIAL 4-5: Adding a total to the Insert Karate Payments application 226 4.6 Focus on Problem Solving: Karate School Manager Application 227 TUTORIAL 4-6: Creating the Karate School Manager startup form 231 TUTORIAL 4-7: Karate School Manager: Listing all members 232 TUTORIAL 4-8: Karate School Manager: Adding new members 235 TUTORIAL 4-9: Karate School Manager: Finding members by name 237 TUTORIAL 4-10: Karate School Manager: Listing all payments 240 TUTORIAL 4-11: Karate School Manager: Showing payments by one member 243 Chapter 5 Database Applications 256 5.1 Creating Databases 256 TUTORIAL 5-1: Creating a SQL Server Express database 258 TUTORIAL 5-2: Adding the Appointments table to the RepairServices database 261 TUTORIAL 5-3: Adding the RepairTypes table to the RepairServices database 262 TUTORIAL 5-4: Creating relationships between the RepairTypes, Appointments, and Customers tables 266 TUTORIAL 5-5: Changing the database connection from the SQL Express server to a database file 269 5.2 DataTables 270 5.3 Updating Databases Using SQL 272 5.4 Focus on Problem Solving: Home Repair Services Application 275 TUTORIAL 5-6: Adding the Appointments class to the middle tier 275 TUTORIAL 5-7: Creating the main startup form 278 TUTORIAL 5-8: Adding classes to the middle tier 280 TUTORIAL 5-9: Adding controls to the New Appointment form 282 TUTORIAL 5-10: Searching for appointments 286 TUTORIAL 5-11: Modifying existing appointments 290 TUTORIAL 5-12: Selecting appointments to modify 294 TUTORIAL 5-13: Deleting an appointment 296 TUTORIAL 5-14: Displaying a joined appointment list 300 Chapter 6 Advanced Classes 308 6.1 Structures 308 6.2 Components 310 TUTORIAL 6-1: Creating a component and referencing it from another application 312 TUTORIAL 6-2: Adding an Advisor class to the RegistrationLib component 316 TUTORIAL 6-3: Using the Advisor and Student classes 318 6.3 Unit Testing 321 TUTORIAL 6-4: Creating a Unit Test project 325 TUTORIAL 6-5: Creating more unit tests for the IntArray class 327 TUTORIAL 6-6: Testing the Advisor.MaxCredits method 336 6.4 Events 341 TUTORIAL 6-7: The WeatherStation Events application 342 6.5 Inheritance 344 TUTORIAL 6-8: Student Inheritance application 349 Chapter 7 LINQ to SQL 360 7.1 Using LINQ to Select Data 360 TUTORIAL 7-1: Displaying the Karate Members table 366 TUTORIAL 7-2: Displaying the Karate class schedule 370 7.2 Updating Tables 374 TUTORIAL 7-3: Using a BindingSource to update the Members table 375 TUTORIAL 7-4: Using LINQ queries to add schedule entries 379 Chapter 8 Creating Web Applications 390 8.1 Programming for the Web 390 8.2 Creating ASP.NET Applications 394 TUTORIAL 8-1: Creating the Click application 400 8.3 ASP.NET Controls 404 TUTORIAL 8-2: Student Picnic application 407 TUTORIAL 8-3: Tracking server events 410 8.4 List-Type Controls 412 TUTORIAL 8-4: Signing up for a Kayak Tour 418 8.5 Designing Web Forms 421 TUTORIAL 8-5: College Advising Wizard 422 8.6 State Management 427 Chapter 9 Programming Web Forms 444 9.1 Working in Source (XHTML) Mode 444 TUTORIAL 9-1: Designing a Vacation Rentals application 446 TUTORIAL 9-2: Adding tables to the Vacation Rentals application 450 9.2 Cascading Style Sheets 454 9.3 Custom Error Handling 461 9.4 Uploading Files and Sending Email 464 9.5 Data Validation Controls 473 9.6 Working with Multiple Web Forms 484 TUTORIAL 9-3: Moving between Web forms 488 9.7 Focus on Problem Solving: Vacation Rentals Application 490 9.8 Browser Cookies 496 Chapter 10 Web Applications with Databases 510 10.1 Master-Detail Pages 510 TUTORIAL 10-1: Creating an application with a master page 513 10.2 Using the GridView Control 519 TUTORIAL 10-2: Displaying the Karate Members table in a GridView control 522 TUTORIAL 10-3: Formatting the Karate Members columns 525 10.3 Using the DetailsView Control 527 TUTORIAL 10-4: Karate member details 528 TUTORIAL 10-5: Selecting members by ID 532 10.4 Data Binding with ListControls 535 10.5 Interacting with the GridView Control 537 TUTORIAL 10-6: Displaying the Courses table in a GridView 540 TUTORIAL 10-7: Using graphical command buttons in the Courses grid 541 TUTORIAL 10-8: Displaying class rolls 544 TUTORIAL 10-9: Displaying the class roll on a separate page 548 10.6 Using JavaScript 550 TUTORIAL 10-10: Receiving user input in JavaScript 555 10.7 Using Microsoft Ajax Controls 557 TUTORIAL 10-11: Displaying the Web server time with Ajax controls 559 TUTORIAL 10-12: Using the UpdateProgress Control 561 Chapter 11 Web Services and Windows Presentation Foundation 574 11.1 Introducing XML Web Services 574 11.2 BookService Web Service 580 TUTORIAL 11-1: Creating the BookService Web Service 580 TUTORIAL 11-2: Consuming BookService from a Web application 584 TUTORIAL 11-3: Consuming BookService from a Windows Forms application 586 11.3 Windows Presentation Foundation (WPF) 592 TUTORIAL 11-4: Creating the Kayak Tour Reservations application 594 TUTORIAL 11-5: Adding Images to the Kayak Tour Reservations application 598 TUTORIAL 11-6: Publishing the Kayak Tour Reservations application 602 TUTORIAL 11-7: Publishing the Kayak Tour Reservations application to the Web 605 Chapter 12 Reports, MDI, Interfaces, and Polymorphism 616 12.1 Creating Microsoft Reports 616 TUTORIAL 12-1: Creating a Sales Order Detail Report 620 TUTORIAL 12-2: Formatting and adding totals to the Sales Details report 625 TUTORIAL 12-3: Displaying the Sales Details report in a Web page 628 TUTORIAL 12-4: Grouping the Sales Details report by product name 630 TUTORIAL 12-5: Adding group totals to the Sales Details report 632 TUTORIAL 12-6: Adding a page heading to the Sales Details report 633 12.2 Multiple Document Interface (MDI) 635 TUTORIAL 12-7: Creating the Class Registration MDI interface 637 12.3 Interfaces 641 TUTORIAL 12-8: Defining and Implementing the IPayable Interface 643 12.4 Abstract Classes and Polymorphism 648 Appendix A: Answers to Checkpoints 658 Appendix B: Optional Reference Topics 666 B.1 TimeSpan and DateTime Formatting 666 B.2 ListView Control 668 TUTORIAL B-1: Filling a ListView control with contact information 671 B.3 Guide to SQL Queries 675 B.4 Writing to the Application Log File 681 Index 682 A 682 B 683 C 683 D 684 E 685 F 685 G 686 H 686 I 686 J 687 K 687 L 687 M 688 N 689 O 689 P 689 Q 690 R 690 S 690 T 691 U 691 V 692 W 692 X 694