Practical Database Programming with Visual Basic.NET

Cover......Page 1
Half-title......Page 3
Title......Page 5
Copyright......Page 6
Contents......Page 9
Preface......Page 29
Acknowledgments......Page 31
1 Introduction......Page 35
1.2 WHOM THIS BOOK IS FOR......Page 36
1.3 WHAT THIS BOOK COVERS......Page 37
1.4 HOW THIS BOOK IS ORGANIZED AND HOW TO USE THIS BOOK......Page 39
1.5 HOW TO USE THE SOURCE CODE AND SAMPLE DATABASES......Page 40
1.6 INSTRUCTOR AND CUSTOMER SUPPORT......Page 41
1.7 HOMEWORK SOLUTIONS......Page 42
2 Introduction to Databases......Page 44
2.1.1 A file processing system......Page 45
2.1.2 Integrated Databases......Page 46
2.2 DEVELOPING A DATABASE......Page 47
2.3.1 Relational Data Model......Page 48
2.3.2 Entity-Relationship (ER) Model......Page 51
2.4.1 Primary Key and Entity Integrity......Page 52
2.5.1 Connectivity......Page 53
2.7 DATA NORMALIZATION......Page 57
2.7.2 Second Normal Form......Page 58
2.7.3 Third Normal Form......Page 59
2.8 DATABASE COMPONENTS IN SOME POPULAR DATABASES......Page 60
2.8.1 Microsoft Access Databases......Page 62
2.8.1.3 Queries......Page 63
2.8.2.2 Tables......Page 64
2.8.2.5 Keys and Relationships......Page 65
2.8.2.7 Transaction Log Files......Page 66
2.8.3.2 Tables......Page 67
2.8.3.4 Stored Procedures......Page 68
2.8.3.7 Control Files......Page 69
2.9.1 Create the LogIn Table......Page 70
2.9.2 Create the Faculty Table......Page 71
2.9.3 Create the Other Tables......Page 73
2.10 CREATE MICROSOFT SQL SERVER 2005 SAMPLE DATABASE......Page 75
2.10.1 Create the Logln Table......Page 82
2.10.2 Create the Faculty Table......Page 83
2.10.3 Create Other Tables......Page 84
2.10.4 Create Relationships Among Tables......Page 89
2.10.4.1 Create Relationship Between the LogIn and Faculty Tables......Page 90
2.10.4.2 Create Relationship Between the LogIn and Student Tables......Page 92
2.10.4.3 Create Relationship Between the Faculty and Course Tables......Page 93
2.10.4.4 Create Relationship Between the Student and StudentCourse Tables......Page 94
2.10.4.5 Create Relationship Between the Course and StudentCourse Tables......Page 95
2.11 CREATE ORACLE 10G XE SAMPLE DATABASE......Page 96
2.11.1 Create the LogIn Table......Page 98
2.11.2 Create the Faculty Table......Page 102
2.11.3 Create Other Tables......Page 106
2.11.4.1 Create the Foreign Key Between the LogIn and Faculty Tables......Page 108
2.11.4.2 Create the Foreign Key Between the LogIn and Student Tables......Page 113
2.11.4.4 Create the Foreign Key Between the StudentCourse and Student Tables......Page 114
2.11.4.5 Create the Foreign Key Between the StudentCourse and Course Tables......Page 116
2.13 HOMEWORK......Page 118
3.1 ADO AND ADO.NET......Page 121
3.2 OVERVIEW OF ADO.NET......Page 122
3.3 THE ARCHITECTURE OF ADO.NET......Page 123
3.4.1 The Data Provider......Page 125
3.4.1.1 The ODBC Data Provider......Page 126
3.4.1.4 The Oracle Data Provider......Page 127
3.4.2 The Connection Class......Page 128
3.4.2.1 The Open() Method of the Connection Class......Page 130
3.4.2.3 The Dispose() Method of the Connection Class......Page 131
3.4.3 The Command and Parameter Classes......Page 132
3.4.3.2 The Constructors and Properties of the Parameter Class......Page 133
3.4.3.3 Parameter Mapping......Page 134
3.4.3.4 The Methods of the ParameterCollection Class......Page 136
3.4.3.5 The Constructor of the Command Class......Page 138
3.4.3.6.1 The ExecuteReader Method......Page 139
3.4.3.6.3 The ExecuteNonQuery Method......Page 140
3.4.4 The DataAdapter Class......Page 141
3.4.4.3 The Methods of the DataAdapter Class......Page 142
3.4.4.4 The Events of the DataAdapter Class......Page 143
3.4.5 The DataReader Class......Page 144
3.4.6 The DataSet Component......Page 147
3.4.6.4 The DataSet Events......Page 149
3.4.7 The DataTable Component......Page 152
3.4.7.1 The DataTable Constructor......Page 153
3.4.7.3 The DataTable Methods......Page 154
3.4.7.4 The DataTable Events......Page 156
3.5 CHAPTER SUMMARY......Page 158
3.6 HOMEWORK......Page 159
4 Data Selection Query with Visual Basic.NET......Page 163
4.1 A COMPLETED SAMPLE DATABASE APPLICATION EXAMPLE......Page 164
4.2.1 Data Components in the Toolbox Window......Page 167
4.2.1.1 DataSet......Page 168
4.2.1.3 BindingSource......Page 169
4.2.1.5 TableAdapter......Page 170
4.2.2.1 Add New Data Source......Page 171
4.2.2.2 Data Source Configuration Wizard......Page 172
4.2.2.3 DataSet Designer......Page 177
4.3 BUILD A SAMPLE DATABASE PROJECT – SELECTWIZARD......Page 178
4.3.1.1 The LogIn Form......Page 179
4.3.1.3 The Faculty Form......Page 181
4.3.1.4 The Course Form......Page 182
4.3.1.5 The Student Form......Page 183
4.4.1 Add and Configure a New Data Source......Page 185
4.5.1 View the Entire Table......Page 189
4.5.2 View Each Record or the Specified Columns......Page 191
4.6 USE DATASET DESIGNER TO EDIT THE STRUCTURE OF THE DATASET......Page 193
4.7 BIND DATA TO ASSOCIATED CONTROLS IN THE LOGIN FORM......Page 195
4.8 DEVELOP CODE TO QUERY DATA USING THE FILL() METHOD......Page 199
4.9 USE RETURN A SINGLE VALUE TO QUERY DATA FOR THE LOGIN FORM......Page 202
4.10 CODING FOR THE SELECTION FORM......Page 205
4.11 BIND DATA TO THE ASSOCIATED CONTROLS IN THE FACULTY FORM......Page 207
4.12 DEVELOP CODE TO QUERY DATA USING THE FILL() METHOD......Page 209
4.13 DISPLAY PICTURES FOR THE FACULTY FORM......Page 212
4.13.1 Modify the Code for the Select Button Event Procedure......Page 213
4.13.2 Create a Function to Select the Matched Faculty Image......Page 214
4.14 BINDING DATA TO ASSOCIATED CONTROLS IN THE COURSE FORM......Page 215
4.15 DEVELOP CODE TO QUERY DATA FOR THE COURSE FORM......Page 219
4.16 INTRODUCTION TO RUNTIME OBJECTS......Page 223
4.16.1 Procedure of Building a Data-Driven Application Using Runtime Objects......Page 225
4.17.1 Query Data Using Runtime Objects for the LogIn Form......Page 226
4.17.1.2 Connect to the Data Source with the Runtime Object......Page 227
4.17.1.3 Coding for Method 1: Using DataSet-TableAdapter to Query Data......Page 228
4.17.1.4 Coding for Method 2: Using the DataReader to Query Data......Page 230
4.17.1.5 Clean Up the Objects Used......Page 231
4.17.3 Query Data Using Runtime Objects for the Faculty Form......Page 233
4.17.4 Query Data Using Runtime Objects for the Course Form......Page 241
4.17.5.1 Coding for the Student Form Load Event Procedure......Page 253
4.17.5.2 Coding for the Student Select Button Event Procedure......Page 254
4.18.1 Migrating from Access to SQL Server and Oracle Databases......Page 260
4.18.2 Query Data Using Runtime Objects for the LogIn Form......Page 263
4.18.2.1 Declare the Runtime Objects......Page 264
4.18.2.2 Connect to the Data Source with the Runtime Object......Page 265
4.18.2.3 Coding for Method 1: Using the TableAdapter to Query Data......Page 266
4.18.2.4 Coding for Method 2: Using the DataReader to Query Data......Page 267
4.18.4 Query Data Using Runtime Objects for the Faculty Form......Page 269
4.18.5 Query Data Using Runtime Objects for the Course Form......Page 273
4.18.6 Retrieve Data from Multiple Tables Using Joined Tables......Page 274
4.18.7 Query Data Using Runtime Objects for the Student Form......Page 279
4.18.8 Query Data Using Stored Procedures......Page 280
4.18.8.1 Create the Stored Procedure......Page 281
4.18.8.2 Call the Stored Procedure......Page 282
4.18.8.3 Query Data Using Stored Procedures for the Student Form......Page 283
4.18.9 Query Data Using More Complicated Stored Procedures......Page 292
4.18.10 Query Data Using Nested Stored Procedures......Page 297
4.19.1 Install Oracle Database 10g Express Edition......Page 300
4.19.2 Configure the Oracle Database Connection String......Page 301
4.19.3 Query Data Using Runtime Objects for the LogIn Form......Page 302
4.19.3.2 Connect to the Data Source with the Runtime Object......Page 303
4.19.3.3 Coding for Method 1: Using the TableAdapter to Query Data......Page 304
4.19.3.4 Coding for Method 2: Using the DataReader to Query Data......Page 306
4.19.4 The Coding for the Selection Form......Page 307
4.19.5 Query Data Using Runtime Objects for the Faculty Form......Page 308
4.19.6 Query Data Using Runtime Objects for the Course Form......Page 311
4.19.7.1 The Syntax of Creating a Stored Procedure in Oracle......Page 314
4.19.7.2 The Syntax for Creating a Package in Oracle......Page 315
4.19.8 Create the Faculty Course Package for the Course Form......Page 317
4.19.9 Query Data Using the Oracle Package for the Course Form......Page 320
4.20 CHAPTER SUMMARY......Page 328
4.21 HOMEWORK......Page 329
5 Data Insertion with Visual Basic.NET......Page 335
5.1 INSERT NEW DATA INTO A DATABASE......Page 336
5.1.1 Insert New Records into a Database Using the TableAdapter.Insert Method......Page 337
5.2 INSERT DATA INTO THE ACCESS DATABASE USING A SAMPLE PROJECT – INSERTWIZARD......Page 338
5.2.3 Create the Insert Faculty Form Window......Page 339
5.2.4.1 Visual Basic Collection and .NET Framework Collection Classes......Page 342
5.2.4.2 Validate Data Using the Generic Collection......Page 343
5.2.5 Initialization and Termination Coding for the Data Insertion......Page 346
5.2.6.1 Configure the TableAdapter and Build the Data Insertion Query......Page 348
5.2.7 Develop Code to Insert Data Using the TableAdapter.Insert......Page 349
5.2.8 Develop Code to Insert Data Using the TableAdapter.Update Method......Page 352
5.2.9 Validate Data After the Data Insertion......Page 356
5.2.9.1 Develop Code to Retrieve the Newly Inserted Records......Page 357
5.2.9.2 Data Binding for All Faculty-Information-Related TextBoxes......Page 358
5.2.9.3 Develop Code to Display the Newly Inserted Faculty Photo......Page 361
5.3 INSERT DATA INTO THE SQL SERVER DATABASE USING A SAMPLE PROJECT – SQLINSERTWIZARD......Page 364
5.3.2 Create a New Form Window to Insert Data for the Course Form......Page 365
5.3.3 Project Initialization and Data Validation Before Data Insertion......Page 366
5.3.4 Configure the TableAdapter and Build the Data Insertion Query......Page 370
5.3.5 Develop the Code to Insert Data Using the TableAdapter.Insert Method......Page 371
5.3.6 Perform Data Bindings for the Insert Course Form Window......Page 375
5.3.7 Develop the Code to Insert Data Using the TableAdapter.Update Method......Page 376
5.3.8 Data Validation for Newly Inserted Records......Page 378
5.3.8.1 Develop Code to Perform the Data Validation......Page 379
5.3.8.2 Use the Select Button in the Course Form to Perform the Data Validation......Page 382
5.3.9 Insert Data into the Database Using the Stored Procedures......Page 383
5.3.9.2 Modify the Code to Perform the Data Insertion Using the Stored Procedure......Page 384
5.4 INSERT DATA INTO THE ORACLE DATABASE USING A SAMPLE PROJECT – ORACLEINSERTWIZARD......Page 386
5.5 THE RUNTIME OBJECT METHOD......Page 387
5.6.1.1 Add a Data Insertion Form Window – Insert Faculty Form......Page 389
5.6.1.2.1 Validate Data Before the Data Insertion and Startup Coding......Page 391
5.6.1.2.2 Insert Data into the Faculty Table......Page 395
5.6.1.2.3 Validate Data After the Data Insertion......Page 399
5.6.2 Insert a New Faculty Photo......Page 403
5.6.3 Insert Data into the Microsoft Access Database Using Runtime Objects......Page 406
5.6.3.2 Modify the Database Connection String......Page 407
5.6.3.3 Modify the LogIn Query Strings......Page 408
5.6.3.4 Modify the Faculty Query String......Page 409
5.6.3.5 Modifications to Other Forms......Page 411
5.6.4 Insert Data into the Oracle Database Using Runtime Objects......Page 413
5.6.4.2 Modify the Database Connection String......Page 414
5.6.4.3 Modify the LogIn Query Strings......Page 415
5.6.4.4 Modify the Faculty Query String......Page 417
5.6.4.5 Modifications to Other Forms......Page 418
5.7.1.1 Add an Insert Data Form Window – Insert Course Form......Page 420
5.7.1.2 Develop Stored Procedures for the SQL Server Database......Page 422
5.7.1.3.1 Validate Data Before the Data Insertion and Startup Coding......Page 424
5.7.1.3.2 Develop Code to Call Stored Procedures......Page 427
5.7.1.3.3 Validate Data After the Data Insertion......Page 430
5.7.2 Insert Data into the Oracle Database Using Stored Procedures......Page 431
5.7.2.1 Develop Stored Procedures in the Oracle Database......Page 432
5.7.2.2.2 Develop Code to Call Stored Procedures......Page 435
5.8 CHAPTER SUMMARY......Page 439
5.9 HOMEWORK......Page 440
6 Data Updating and Deleting with Visual Basic.NET......Page 445
PART I DATA UPDATING AND DELETING WITH VISUAL BASIC.NET DESIGN TOOLS AND WIZARDS......Page 446
6.1.1 Updating and Deleting Data from Related Tables in a DataSet......Page 447
6.1.3 Update or Delete Data from a Database by Using the TableAdapter.Update Method......Page 448
6.2 UPDATE AND DELETE DATA FROM AN ACCESS DATABASE BY USING THE SAMPLE PROJECT ACCESSUPDATEDELETEWIZARD......Page 449
6.2.2.1 Modify the Faculty Form Window......Page 450
6.2.2.2 Bind Data for All Text Boxes of the Faculty Form Window......Page 451
6.2.4.1 Configure TableAdapter and Build the Data Updating Query......Page 452
6.2.4.2 Build the Data Deletion Query......Page 453
6.2.5.1 Coding Modifications......Page 454
6.2.5.3 Update Coding......Page 455
6.2.6 Develop Code to Update Data by Using the TableAdapter.Update Method......Page 457
6.2.7 Develop Code to Delete Data by Using the TableAdapter DBDirect Method......Page 459
6.2.8 Develop Code to Delete Data by Using the TableAdapter.Update Method......Page 460
6.2.9 Validate the Data After Data Updating and Deleting......Page 461
6.3 UPDATE AND DELETE DATA FROM AN SQL SERVER DATABASE BY USING THE SAMPLE PROJECT SQLUPDATEDELETEWIZARD......Page 464
6.4 UPDATE AND DELETE DATA FROM AN ORACLE DATABASE BY USING THE SAMPLE PROJECT ORACLEUPDATEDELETEWIZARD......Page 467
6.5 THE RUNTIME OBJECT METHOD......Page 468
6.6.1 Update Data in the Faculty Table for the SQL Server Database......Page 470
6.6.1.1 Modify the Faculty Form Window......Page 471
6.6.1.2.1 Modify the Coding for the Faculty Form......Page 472
6.6.1.3 Develop Code to Update Data......Page 475
6.6.2 Delete Data from the Faculty Table for an SQL Server Database......Page 477
6.6.2.1 Develop Code to Delete Data......Page 478
6.6.2.2 Validate the Data Updating and Deleting......Page 479
6.7 UPDATE AND DELETE DATA FROM AN ORACLE DATABASE BY USING RUNTIME OBJECTS......Page 481
6.7.2.2 Modify the SELECT Query String in the TabLogIn Button Event Procedure......Page 483
6.7.3.1 Modify the SELECT Query String for the Select Button Event Procedure......Page 484
6.7.4.1 Modify the SELECT Query String for the Select Button Event Procedure......Page 485
6.7.6 Other Modifications......Page 486
6.8 UPDATE AND DELETE DATA FROM A DATABASE BY USING STORED PROCEDURES......Page 488
6.8.1.1 Modify the Existing Project......Page 489
6.8.1.1.3 Modify the Query Strings for the Select and Update Button Event Procedures......Page 490
6.8.1.2 Create Stored Procedures in the Access Database......Page 491
6.8.1.3 Call the Stored Procedure to Update the Faculty Information......Page 493
6.8.1.4 Confirm the Faculty Information Updating......Page 494
6.8.2.1 Modify the Existing Project to Create a New Project......Page 496
6.8.2.2 Develop the Stored Procedure in the SQL Server Database......Page 499
6.8.2.3 Call the Stored Procedure to Perform the Data Updating and Validate the Updated Information......Page 501
6.8.3.1 Modify the Existing Project to Create a New Project......Page 503
6.8.3.2 Develop the Stored Procedure in the Oracle Database......Page 506
6.8.3.3 Call the Stored Procedure to Perform the Data Updating and Validation......Page 509
6.8.4 Delete Data from the Oracle Database by Using Stored Procedures......Page 510
6.8.4.1 Create the Stored Procedure in the Oracle Database......Page 511
6.8.4.2 Develop the Code to Call the Stored Procedure to Delete Records......Page 514
6.9 CHAPTER SUMMARY......Page 515
6.10 HOMEWORK......Page 516
7 Accessing Data in ASP.NET......Page 521
7.1 WHAT IS THE .NET FRAMEWORK?......Page 522
7.2 WHAT IS ASP.NET?......Page 523
7.2.2 ASP.NET Execution Model......Page 525
7.2.3 What Really Happens When a Web Application Is Executed?......Page 526
7.2.4 The Requirements to Test and Run the Web Project......Page 527
7.3 DEVELOP AN ASP.NET WEB APPLICATION TO SELECT DATA FROM SQL SERVER DATABASES......Page 528
7.3.1 Create the User Interface – LogIn Form......Page 529
7.3.2 Develop the Code to Access and Select Data from the Database......Page 530
7.3.3 Validate the Data in the Client Side......Page 535
7.3.4 Create the Second User Interface – Selection Page......Page 536
7.3.5 Develop the Code to Open the Other Pages......Page 537
7.3.6 Create the Third User Interface – Faculty Page......Page 539
7.3.7.1 Develop the Code for the Page Load Event Procedure......Page 542
7.3.7.2 Develop the Code for the Select Button Event Procedure......Page 543
7.3.7.3 Develop the Code for Other Procedures......Page 544
7.3.8 Create the Fourth User Interface – Course Page......Page 548
7.3.8.1 The AutoPostBack Property of the List Box Control......Page 549
7.3.9 Develop the Code to Select the Desired Course Information......Page 550
7.3.9.1 Coding for the Course Page Loading and Ending Event Procedures......Page 551
7.3.9.2 Coding for the Select Button’s Click Event Procedure......Page 553
7.3.9.3 Coding for the SelectedIndexChanged Event Procedure of the List Box Control......Page 556
7.3.9.4 Coding for Other User-Defined Procedures......Page 557
7.4 DEVELOP AN ASP.NET WEB APPLICATION TO SELECT DATA......Page 559
7.4.1 Modify the Connection String in the LogIn Page......Page 560
7.4.2 Modify the Query String in the LogIn Page......Page 561
7.4.3 Modify the Query String in the Faculty Page......Page 562
7.4.4 Modify the Query String in the Course Page......Page 564
7.5.1 Create a New Web Page – Insert.aspx......Page 568
7.5.2 Develop the Code to Perform the Data Insertion Functionality......Page 569
7.5.2.1 Develop the Code for the Page Load and Back Button Event Procedures......Page 570
7.5.2.2 Develop the Code for the Insert Button’s Click Event Procedure......Page 571
7.5.3 Validate the Data Insertion......Page 573
7.6 DEVELOP AN ASP.NET WEB APPLICATION TO INSERT DATA INTO ORACLE DATABASES......Page 578
7.6.1 Create the Insert Web Page and Develop the Code......Page 579
7.6.1.2 Modifications to the Code of Subroutines and Procedures......Page 580
7.6.2 Modify the Code for the Faculty Page......Page 582
7.7 DEVELOP WEB APPLICATIONS TO UPDATE AND DELETE DATA IN SQL SERVER DATABASES......Page 585
7.7.2 Modify the Code for the Faculty Page......Page 586
7.7.3 Develop the Code for the Update Button Event Procedure......Page 587
7.7.4.1 Relationships Between Five Tables in Our Sample Database......Page 591
7.7.4.2 Data Deletion Sequence......Page 592
7.7.4.3 Use the Cascade Deleting Option to Simplify the Data Deletion......Page 593
7.7.4.4 Create the Stored Procedure to Perform the Data Deletion......Page 595
7.7.4.5 Develop the Code to Call the Stored Procedure to Perform the Data Deletion......Page 598
7.8.1.1 Modifications to the Select Button’s Click Event Procedure......Page 601
7.8.1.2 Add the Code to the Update Button and UpdateParameters Procedures......Page 602
7.8.2 Develop Stored Procedures to Perform the Data Deletion......Page 604
7.8.2.1 Delete an Existing Record from the Faculty Table......Page 605
7.8.2.2 Develop the Code for the Delete Button’s Click Event Procedure......Page 606
7.8.2.3 Validate the Data Deleting Actions......Page 608
7.8.2.4 The On Delete Cascade Constraint in the Data Table......Page 609
7.9 CHAPTER SUMMARY......Page 611
7.10 HOMEWORK......Page 612
8 ASP.NET Web Services......Page 616
8.1 WHAT ARE WEB SERVICES AND THEIR COMPONENTS?......Page 617
8.2.1 The Structure of a Typical Web Service Project......Page 619
8.2.2 The Real Considerations When Building a Web Service Project......Page 620
8.2.3 Procedures to Build an ASP.NET Web Service......Page 621
8.3.1 Files and Items Created in the New Web Service Project......Page 622
8.3.2 A Feeling of the HelloWorld Web Service Project As It Runs......Page 624
8.3.3 Modify the Default Web Service Project......Page 628
8.3.4 Create a Base Class to Handle Error Checking for Our Web Service......Page 629
8.3.5 Create the Real Web Service Class......Page 630
8.3.6 Add Web Methods into Our Web Service Class......Page 631
8.3.7.1 Web Service Connection Strings......Page 632
8.3.7.2 Modify the Existing Web Method......Page 634
8.3.7.3 Develop the Code to Perform the Database Queries......Page 636
8.3.7.4 Develop the Code for Subroutines Used in the Web Method......Page 638
8.3.8.1 Develop the Stored Procedure WebSelectFacultySP......Page 641
8.3.8.2 Add Another Web Method to Call the Stored Procedure......Page 642
8.3.9 Use DataSet as the Returning Object for the Web Method......Page 643
8.3.10.1 Create a Web Service Proxy Class......Page 646
8.3.10.2 Develop the Graphical User Interface for the Windows-Based Client Project......Page 648
8.3.10.3 Develop the Code to Consume the Web Service......Page 650
8.3.10.3.1 Develop the Code for the Form Load Event Procedure......Page 651
8.3.10.3.2 Develop the Code for the Select Button’s Click Event Procedure......Page 652
8.3.10.3.3 Develop the Code for Other Subroutines......Page 653
8.3.10.3.4 Develop a Subroutine ShowFaculty to Display the Faculty Image......Page 655
8.3.11 Build Web-Based Web Service Clients to Consume the Web Service......Page 657
8.3.11.2 Add a Web Service Reference and Modify the Web Form Window......Page 658
8.3.11.3 Modify the Code for the Related Event Procedures......Page 659
8.3.11.3.2 Modify the Code in the Select Button Event Procedure......Page 660
8.3.11.3.3 Add Three User-Defined Subroutines......Page 662
8.3.11.3.4 Modify the Code for the Back Button Event Procedure......Page 663
8.3.12 Deploy the Completed Web Service to Production Servers......Page 664
8.3.12.1 Copy Web Service Files to the Virtual Directory......Page 665
8.3.12.2 Publish a Precompiled Web Service......Page 666
8.4.1 Modify an Existing Web Service Project......Page 667
8.4.3 Develop and Modify the Code for the Code-Behind Page......Page 669
8.4.3.1 Develop and Modify the First Web Method – SetSQLInsertSP......Page 670
8.4.3.2 Develop the Second Web Method – GetSQLInsert......Page 674
8.4.3.3 Develop and Modify the Third Web Method – SQLInsertDataSet......Page 676
8.4.3.4 Develop the Fourth Web Method – GetSQLInsertCourse......Page 681
8.4.3.4.1 Create the Stored Procedure WebSelectCourseSP......Page 682
8.4.3.4.2 Develop the Code to Call This Stored Procedure......Page 683
8.4.4.1 Create a Web Service Proxy Class......Page 687
8.4.4.2 Develop the Graphical User Interface for the Client Project......Page 688
8.4.4.3.1 Develop the Code to Initialize and Terminate the Client Project......Page 691
8.4.4.3.2 Develop the Code to Insert a New Course Record into the Database......Page 692
8.4.4.3.3 Develop the Code to Perform the Inserted Data Validation......Page 696
8.4.4.3.4 Develop the Code to Get the Detailed Information for a Specific Course......Page 700
8.4.5 Build Web-Based Web Service Clients to Consume the Web Services......Page 702
8.4.5.1 Create a New Web Site Project and Add an Existing Web Page......Page 703
8.4.5.2 Add a Web Service Reference and Modify the Web Form Window......Page 704
8.4.5.3 Modify the Code for the Related Event Procedures......Page 705
8.4.5.3.1 Modify the Code in the Page Load Event Procedure......Page 706
8.4.5.3.2 Develop Code for the Insert Button Event Procedure......Page 707
8.4.5.3.3 Develop Code for TextChanged Event Procedure of the CourseID Text Box......Page 708
8.4.5.3.4 Modify the Code in the Select Button’s Click Event Procedure......Page 709
8.4.5.3.5 Modify the Code in the SelectedIndexChanged Event Procedure......Page 712
8.4.5.3.6 Modify the Code in the Back Button’s Click Event Procedure......Page 714
8.5.1 Modify an Existing Web Service Project......Page 716
8.5.2 Modify Related Web Methods......Page 717
8.5.2.1 Modify the Web Method from SetSQLInsertSP to SQLUpdateSP......Page 718
8.5.2.2 Modify the Web Method GetSQLInsert to GetSQLCourse......Page 720
8.5.2.3 Modify the Web Method GetSQLInsertCourse to GetSQLCourseDetail......Page 721
8.5.2.4 Add a New Web Method – SQLDeleteSP......Page 723
8.5.3.1 Develop the Stored Procedure WebUpdateCourseSP......Page 725
8.5.3.2 Develop the Stored Procedure WebDeleteCourseSP......Page 727
8.6.1 Modifications to the File Folder and Project Files......Page 736
8.6.2 Add a New Web Reference to Our Client Project......Page 737
8.6.3 Modifications to the Graphical User Interface......Page 738
8.6.4.1 Modify the Code for the Form Load Event Procedure and Form-Level Variables......Page 739
8.6.4.2 Develop the Code for the Update Button Event Procedure......Page 740
8.6.4.3 Develop the Code for the Delete Button Event Procedure......Page 741
8.6.4.4 Modify the Code for the Select Button Event Procedure......Page 742
8.6.4.5 Modify the Code for the SelectedIndexChanged Event Procedure......Page 743
8.7 BUILD WEB-BASED WEB SERVICE CLIENTS TO CONSUME THE WEB SERVICES......Page 747
8.7.2 Add a Web Service Reference and Modify the Web Form Window......Page 748
8.7.3.2 Develop Code for the Update Button Event Procedure......Page 750
8.7.3.3 Develop Code for the Delete Button’s Click Event Procedure......Page 751
8.7.3.4 Modify Code for the Select Button Event Procedure and Related Subroutines......Page 753
8.7.3.5 Modify Code for the SelectedIndexChanged Event Procedure of the Course List Box Control and Related Subroutines......Page 754
8.8 BUILD AN ASP.NET WEB SERVICE PROJECT TO ACCESS AN ORACLE DATABASE......Page 758
8.8.1 Build a Web Service Project – WebServiceOracleSelect......Page 759
8.8.4 Modify the Web Method GetSQLSelect and Related Subroutines......Page 760
8.8.5 Modify the Web Method GetSQLSelectSP and Related Subroutines......Page 762
8.8.5.1 Modifications to the Stored Procedure WebSelectFacultySP......Page 763
8.8.5.2 Modifications to the Code for the Web Method GetSQLSelectSP......Page 767
8.8.6 Modify the Web Method GetSQLSelectDataSet......Page 768
8.9 BUILD WEB SERVICE CLIENTS TO CONSUME THE WEB SERVICE WEBSERVICEORACLESELECT......Page 773
8.10.1 Build a Web Service Project – WebServiceOracleInsert......Page 774
8.10.3 Modify the Namespace Directories......Page 775
8.10.4 Modify the Web Method SetSQLInsertSP and Related Subroutines......Page 776
8.10.5 Modify the Web Method GetSQLInsert and Related Subroutines......Page 778
8.10.6 Modify the Web Method SQLInsertDataSet......Page 780
8.10.7 Modify the Web Method GetSQLInsertCourse and Related Subroutines......Page 782
8.11 BUILD WEB SERVICE CLIENTS TO CONSUME THE WEB SERVICE WEBSERVICEORACLEINSERT......Page 791
8.12.1 Build a Web Service Project – WebServiceOracleUpdateDelete......Page 792
8.12.3 Modify the Namespace Directories......Page 793
8.12.4 Modify the Web Method SQLUpdateSP and Related Subroutines......Page 794
8.12.4.1 Develop the Stored Procedure UpdateCourse_SP......Page 796
8.12.5 Modify the Web Method GetSQLCourse and Related Subroutines......Page 799
8.12.6 Modify the Web Method GetSQLCourseDetail and Related Subroutines......Page 800
8.12.7 Modify the Web Method SQLDeleteSP......Page 802
8.12.7.1 Develop the Stored Procedure WebDeleteCourseSP......Page 804
8.13 BUILD WEB SERVICE CLIENTS TO CONSUME THE WEB SERVICE WEBSERVICEORACLEUPDATEDELETE......Page 808
8.14 CHAPTER SUMMARY......Page 809
8.15 HOMEWORK......Page 810
Index......Page 815