Microsoft ADO.NET Professional Projects (Professional Projects)

✍ Scribed by Sanjeev Rohilla, Surbhi Malhotra,

• Publisher: Course Technology PTR
• Year: 2002
• Tongue: English
• Leaves: 969
• Edition: 1
• Category: Library

✦ Synopsis

Use ADO.NET to accomplish real-world, professional tasks. ADO.NET Professional Projects is your key to unlocking the power of ADO.NET. Each project focuses on a specific concept and is based on a real-world situation. Enhance your skills as you work through eleven projects including creating a MyEvents application, designing a credit card application, developing a score updates application, and creating a movie ticket booking application. When you are finished, you will have the skills necessary to modify projects to fit your professional needs.

✦ Table of Contents

Contents at a Glance......Page 10
Contents......Page 12
Introduction......Page 30
Part I - ADO.NET Overview......Page 32
Overview of Data- Centric Applications......Page 34
Evolution of Data- Centric Applications......Page 36
DAO......Page 37
RDO......Page 38
OLE DB and ADO......Page 39
Overview of the .NET Framework......Page 41
CLR......Page 43
.NET Framework Class Library......Page 44
Evolution of ADO. NET from ADO......Page 46
Disconnected Data Architecture......Page 48
Data in Datasets......Page 49
In- Memory Data Representation......Page 50
Use of Cursors......Page 51
Benefits of ADO. NET......Page 52
Programmability......Page 53
Performance......Page 54
Summary......Page 55
The ADO. NET Architecture......Page 56
Using Data- Related Namespaces......Page 57
The Dataset......Page 59
The .NET Data Provider......Page 61
ADO. NET and XML......Page 64
Summary......Page 65
Connecting to a SQL Server and Other Data Sources......Page 68
The OleDbConnection Object......Page 69
The SqlConnection Object......Page 77
in Visual Studio .NET......Page 78
Creating a Data Connection Using the Server Explorer......Page 79
the Properties Window......Page 82
Creating a Connection Using Data Form Wizard......Page 86
Connecting to a SQL Server Database......Page 93
Connecting to an OLE DB Data Source......Page 94
Summary......Page 95
ADO. NET Data Adapters......Page 96
Data Adapters— An Overview......Page 97
Managing Related Tables......Page 98
Data Adapter Properties......Page 99
Table Mappings......Page 100
The DataAdapter Objects......Page 101
Data Adapters......Page 108
Using the Server Explorer......Page 109
Using Data Adapter Configuration Wizard......Page 112
Creating Data Adapters Manually......Page 121
Configuring Data Adapters Using the Properties Window......Page 122
Previewing Data Adapter Results......Page 126
Adapter Programmatically......Page 128
Creating Table Mappings......Page 131
Using the Properties Window......Page 132
Writing the Code......Page 134
Selection Parameters......Page 136
Summary......Page 137
ADO. NET Datasets......Page 138
Datasets— An Overview......Page 139
The DataSet Object Model......Page 140
Datasets and XML......Page 142
Comparing Dataset Types......Page 143
Visual Studio. NET Design Tools— An Overview......Page 145
Creating Typed Datasets Using the Design Tools......Page 148
Creating Untyped Datasets Using the Design Tools......Page 153
Creating Datasets Programmatically......Page 162
Summary......Page 163
Working with Data Tables......Page 164
The DataTable Object......Page 165
The DataTableCollection Class......Page 167
The DataColumnCollection Class......Page 168
The DataRow Object......Page 169
Defining the Data Table Structure......Page 170
Creating the Columns of a Data Table......Page 171
Adding Constraints......Page 175
Adding Data......Page 178
Editing Data......Page 180
Deleting a Row......Page 183
Identifying Error Information for the Rows......Page 184
Summary......Page 185
Part II - Professional Project 1 - Using ADO.NET......Page 186
Project Case Study- SalesData Application......Page 190
Project Life Cycle......Page 192
Requirements Analysis......Page 193
Testing......Page 194
The Database Structure......Page 195
Summary......Page 196
Creating the SalesData Application......Page 198
The Main Form......Page 199
How It Works......Page 208
The Code behind the Application......Page 211
Summary......Page 228
Using Data Adapter Configuration Wizard to Create a Simple Data Access Application......Page 230
The Forms for the Application......Page 231
Wizard......Page 234
Wizard Generates......Page 245
Summary......Page 256
Project Case Study- MyEvents Application......Page 258
Micro- Level Design......Page 260
Summary......Page 262
Creating the MyEvents Application......Page 264
for the Application......Page 265
Using the HTML Table Control......Page 273
Using the Calendar Control......Page 274
The Functioning of the Application......Page 275
Displaying Events Data for the Current Date......Page 276
Adding Events......Page 283
Viewing Events......Page 291
The Complete Code......Page 294
Summary......Page 306
Part III - Professional Project 2 - Using Data Relationships......Page 308
Using Data Relationships in ADO. NET......Page 312
to Data Relationships......Page 315
Tables in a Dataset......Page 317
Adding Relations to a Dataset......Page 318
The ChildTable Property......Page 323
The ParentTable Property......Page 324
The ChildKeyConstraint Property......Page 325
The ParentKeyConstraint Property......Page 326
The DataRelationCollection Class......Page 327
of the DataTable Class......Page 328
Data Relations......Page 329
Create Relationships......Page 331
Summary......Page 333
Project Case Study- CreditCard Application......Page 334
High- Level Design......Page 337
Low- Level Design......Page 338
The Customers Table......Page 339
The TransactionDetails Table......Page 340
Relationships Among the Tables......Page 341
Summary......Page 342
Creating the CreditCard Application......Page 344
The Basic Format......Page 345
Group Boxes......Page 346
Text Boxes......Page 347
Validations......Page 349
Populate the Data in Datasets......Page 351
Creating Data Relationships......Page 355
Traversing through Related Tables......Page 356
Closing the Form......Page 358
The Complete Code......Page 359
Summary......Page 375
Part IV - Professional Project 3 - Working with Data in Datasets......Page 376
Working with Data in Datasets......Page 380
Filtering and Sorting Data in Datasets......Page 381
Filtering and Sorting Directly in Data Tables......Page 382
Introduction to Data Views......Page 383
Adding Data Views to Forms or Components......Page 384
Filtering and Sorting Data Using Data Views......Page 386
Reading Records in a Data View......Page 388
Finding Records in a Data View......Page 389
Updating Records in a Data View......Page 391
Inserting Records in a Data View......Page 392
Using Data Views to Handle Related Tables......Page 393
Data View Managers......Page 395
Data Update Events......Page 396
Checking the Changed Rows......Page 398
Accessing the Changed Rows......Page 399
Data Validation in Datasets......Page 400
Validating Data during Row Changes......Page 401
Summary......Page 402
Project Case Study- PizzaStore Application......Page 404
Project Life Cycle......Page 405
Macro- Level Design......Page 406
Micro- Level Design......Page 407
Summary......Page 409
Creating the PizzaStore Application......Page 410
for the Application......Page 411
PizzaStore Application......Page 416
Configuring Data Adapters......Page 418
Generating the Dataset......Page 421
Code Generated by the Wizard......Page 422
Populating the Dataset......Page 425
Adding Items to the DdlState Drop- Down List Controls......Page 426
Displaying the Pizza Store Details......Page 428
The Complete Code......Page 430
Summary......Page 437
Project Case Study - UniversityCourse-Reports Application......Page 438
Project Life Cycle......Page 439
Macro- Level Design......Page 440
The Database Structure......Page 441
Summary......Page 445
Creating the UniversityCourse-Reports Application......Page 448
Form for the Application......Page 449
The Functioning of the Application......Page 453
Configuring Data Adapters......Page 457
Generating the Dataset......Page 460
Code Generated by the Wizard......Page 463
Populating the Dataset......Page 468
Retrieving Course and University Details......Page 469
Summary......Page 483
Part V - Professional Project 4 - Performing Direct Operations with the Data Source......Page 484
Performing Direct Operations with the Data Source......Page 488
Direct Data Access......Page 490
Command Objects......Page 491
The SqlCommand Class......Page 492
The OleDbCommand Class......Page 497
The DataReader Object......Page 500
The SqlDataReader Class......Page 501
The OleDbDataReader Class......Page 504
Adding the SqlCommand Object by Using the Toolbox......Page 507
Adding the OleDbCommand Object by Using the Toolbox......Page 509
Creating Data Command Objects Programmatically......Page 511
Using Parameters in DataCommand Objects......Page 513
Using Stored Procedures with......Page 515
Summary......Page 517
Project Case Study- Score Updates Application......Page 518
Requirements Analysis......Page 519
The Database Structure......Page 520
Summary......Page 522
Creating the Score Updates Application......Page 524
for the Application......Page 526
The btnGetScore_ Click Procedure......Page 534
The Complete Code......Page 537
Summary......Page 544
Part VI - Professional Project 5 - Updating Data in the Data Source......Page 546
Updating Data in the Data Source......Page 550
to Update Data......Page 552
Modifying Data in a Dataset......Page 556
Updating Existing Records in a Dataset......Page 557
Inserting New Rows in a Dataset......Page 558
Deleting Records from a Dataset......Page 559
Merging Two Datasets......Page 560
Data Validation Checks......Page 562
Maintaining Change Information in a Dataset......Page 563
Committing Changes to a Dataset......Page 565
Updating a Data Source from Datasets......Page 566
Using the DataAdapter Object to Modify Data......Page 567
Updating Related Tables in a Dataset......Page 574
Summary......Page 575
Project Case Study- MyEvents Application— II......Page 578
Macro- Level Design......Page 579
Summary......Page 580
The MyEvents Application— II......Page 582
for the Application......Page 583
The Page_ Load Event Procedure......Page 588
The ShowEventDetails Procedure......Page 589
The MappedTable Procedure......Page 591
The BtnSave_ Click Event Procedure......Page 592
The BtnShow_ Click Event Procedure......Page 595
Modifying Events......Page 599
Deleting Events......Page 614
The Complete Code......Page 619
Summary......Page 639
Part VII - Professional Project 6 - Managing Data Concurrency......Page 640
Managing Data Concurrency......Page 644
The Version Number Approach......Page 646
The Saving All Values Approach......Page 647
with Dynamic SQL......Page 648
with Stored Procedures......Page 653
Creating Transactions......Page 656
Summary......Page 658
Project Case Study- Movie Ticket Bookings Application......Page 660
The Structure of the Database......Page 662
Summary......Page 667
Creating the Movie Ticket Bookings Application......Page 668
of the Application......Page 669
Connecting to a Database......Page 671
Generating a Dataset......Page 674
Validating Data Entry......Page 676
The Code for the Form......Page 684
Summary......Page 688
Part VIII - Professional Project 7 - XML and Datasets......Page 690
XML and Datasets......Page 694
XML— An Overview......Page 695
XML Specifications......Page 696
Components of an XML Schema......Page 703
Elements with XSD......Page 705
Creating an XML Schema......Page 707
XML Schemas and Datasets......Page 709
Filling a Dataset......Page 710
Writing XML Data from a Dataset......Page 711
Loading a Dataset with XML Data......Page 714
Loading a Dataset Schema from XML......Page 716
Representing Dataset Schema Information as XSD......Page 717
Related Data in a Dataset......Page 718
XSL and XSLT Transformations......Page 719
Summary......Page 720
Project Case Study- XMLDataSet......Page 722
Project Life Cycle......Page 723
The Database Structure......Page 724
Summary......Page 726
Creating the XMLDataSet Application......Page 728
Designing the XMLDataSet Application......Page 730
The btnGetXML_ Click Procedure......Page 732
The btnWriteInvoice_ Click Procedure......Page 734
The Complete Code......Page 737
Summary......Page 742
Exceptions and Error Handling......Page 744
Exceptions Overview......Page 745
The Try ... Catch Block......Page 746
The Exception Class......Page 747
The DataException Class......Page 748
Summary......Page 758
Part IX - Professional Project 8 - Creating and Using an XML Web Service......Page 760
Creating and Using an XML Web Service......Page 764
Introduction to XML Web Services......Page 766
The Role of XML in Web Services......Page 767
UDDI......Page 768
WSDL......Page 769
Creating a Web Service......Page 770
Creating Web Service Clients......Page 777
Testing a Web Service......Page 782
Deploying a Web Service......Page 783
Summary......Page 788
Project Case Study- MySchedules Application......Page 790
The Database Structure......Page 792
Summary......Page 797
Creating the MySchedules Application......Page 798
of the Application......Page 799
MySchedules Application......Page 807
The Complete Code......Page 828
Summary......Page 836
Part X - Appendixes......Page 838
Introduction to Microsoft .NET Framework......Page 840
Overview of Microsoft .NET Framework......Page 841
Benefits of the .NET Framework......Page 842
Visual Studio .NET......Page 843
Implementation of a Project- Independent Object Model......Page 844
Enhanced IDE......Page 845
the .NET Framework......Page 847
Language (MSIL)......Page 848
Overview of Common Language Specification (CLS)......Page 849
Overview of the Common Type System (CTS)......Page 850
Introduction to Visual Basic .NET......Page 852
Overview of Visual Basic .NET......Page 853
Data Types......Page 858
Variable Declarations......Page 860
Variable Scope......Page 863
Working with Constants......Page 864
Working with Operators......Page 865
Arithmetic Operators......Page 866
Comparison Operators......Page 871
Logical/ Bitwise Operators......Page 873
Creating an Instance of a Class......Page 880
Working with Shared Members......Page 887
Visual Basic .NET......Page 888
Creating Collections......Page 890
Conditional Logic......Page 894
The If ... Then ... Else Statement......Page 895
The Select ... Case Statement......Page 898
Loop Structures......Page 901
The Do ... Loop Statement......Page 902
The For . . . Next Statement......Page 905
The For Each ... Next Statement......Page 907
Built- in Functions......Page 908
The String Functions......Page 909
Date Functions......Page 914
Working with Procedures......Page 918
Passing Arguments by Value......Page 925
Passing Arguments by Reference......Page 926
Optional Arguments......Page 927
Event Handling in Visual Basic .NET......Page 928
Design Applications......Page 931
Visual Basic .NET......Page 937
Creating ASP. NET Web Applications......Page 938
Creating the Project and Form......Page 939
Adding Controls and Text......Page 940
Visual Basic .NET......Page 942
A......Page 944
C......Page 945
D......Page 948
E......Page 953
F......Page 954
H......Page 955
L......Page 956
M......Page 957
N......Page 958
P......Page 959
R......Page 961
S......Page 962
U......Page 964
V......Page 965
W......Page 967
X......Page 968