Verfügbarkeit: Applied ADO.NET

Applied ADO.NET: building data-driven solutions

Gespeichert in:

Bibliographische Detailangaben
Hauptverfasser:	Chand, Mahesh (VerfasserIn), Talbot, David (VerfasserIn)
Format:	Buch
Sprache:	English
Veröffentlicht:	[S.l.] Apress 2003
Online-Zugang:	Inhaltsverzeichnis
Beschreibung:	XXXIV, 887 S. graph. Darst.
ISBN:	1590590732

Internformat

MARC


LEADER	00000nam a2200000zc 4500
001	BV023528495
003	DE-604
005	20091214
007	t
008	030522s2003 xxud\|\|\| \|\|\|\| 00\|\|\| eng d
020			\|a 1590590732 \|9 1-59059-073-2
035			\|a (OCoLC)249481670
035			\|a (DE-599)BVBBV023528495
040			\|a DE-604 \|b ger
041	0		\|a eng
044			\|a xxu \|c XD-US
049			\|a DE-521
082	0		\|a 005.117
084			\|a ST 250 \|0 (DE-625)143626: \|2 rvk
100	1		\|a Chand, Mahesh \|e Verfasser \|4 aut
245	1	0	\|a Applied ADO.NET \|b building data-driven solutions \|c Mahesh Chand and David Talbot
264		1	\|a [S.l.] \|b Apress \|c 2003
300			\|a XXXIV, 887 S. \|b graph. Darst.
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
700	1		\|a Talbot, David \|e Verfasser \|4 aut
856	4	2	\|m SWB Datenaustausch \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016848697&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
999			\|a oai:aleph.bib-bvb.de:BVB01-016848697

Datensatz im Suchindex

_version_	1804138173169664000
adam_text	CONTENTS ABOUT THE AUTHORS .............................................................................................XXI ABOUT THE TECHNICAL REVIEWER ...................................................................XXIII ACKNOWLEDGMENTS .................................................................................................XXV INTRODUCTION .....................................................................................................XXVII CHAPTER 1 ADO.NET BASICS .....................................................................1 OVERVIEW OF MICROSOFT DATA ACCESS TECHNOLOGIES .................................2 ODBC .............................................................................. .....................................2 DAO .............................................................................. ........................................4 MFC ODBC AND DAO CLASSES ............................................................................5 RDO .............................................................................. ........................................5 OLE DB ................................................................................................................5 ADO .............................................................................. ........................................6 ADO.NET .............................................................................................................6 WHAT IS ADO.NET? .............................................................................. ..................7 WHY ADO.NET WAS DESIGNED ...............................................................................8 ADVANTAGES OF ADO.NET .............................................................................. .......9 SINGLE OBJECT-ORIENTED API .............................................................................. .9 MANAGED CODE ..................................................................................................10 XML SUPPORT .....................................................................................................10 VISUAL DATA COMPONENTS .................................................................................11 PERFORMANCE AND SCALABILITY ...........................................................................11 COMPARING ADO.NET AND ADO ...........................................................................11 CONNECTIONS AND DISCONNECTED DATA .............................................................11 RECORDSETS VS. DATASETS ....................................................................................12 XML SUPPORT .....................................................................................................12 OVERVIEW OF ADO.NET NAMESPACES AND CLASSES .....................................13 UNDERSTANDING ADO.NET COMPONENTS ...........................................................15 THE CONNECTION OBJECT ....................................................................................16 THE COMMAND OBJECT ......................................................................................17 THE COMMAND BUILDER .............................................................................. ......19 THE DATAADAPTER OBJECT .............................................................................. ....19 DATASET STRUCTURE .............................................................................. ...............20 DATASETS IN DATAVIEWS .............................................................................. .......21 VII WRITING ADO.NET APPLICATIONS ....................................................................22 CHOOSING A .NET DATA PROVIDER .......................................................................22 ADDING NAMESPACE REFERENCES .......................................................................23 ESTABLISHING A CONNECTION ...............................................................................24 CREATING A COMMAND OR DATAADAPTER OBJECT ................................................25 FILLING DATA TO A DATASET OR DATAREADER OBJECT .............................................25 DISPLAYING DATA .............................................................................. ..................25 CLOSING THE CONNECTION .............................................................................. .....26 CREATING A SIMPLE ADO.NET APPLICATION ................................................26 USING A DATASET TO READ DATA ....................................................................28 SUMMARY ..................................................................................................................31 CHAPTER 2 DATA COMPONENTS IN VISUAL STUDIO .NET .......33 CREATING AN ADO.NET PROJECT ........................................................................33 USING THE SERVER EXPLORER ...........................................................................34 ADDING A NEW CONNECTION ...............................................................................35 MANAGING AND VIEWING DATA ...........................................................................36 USING VISUAL DATA COMPONENTS ....................................................................37 UNDERSTANDING DATA CONNECTIONS ..................................................................38 UNDERSTANDING CONNECTION STRINGS ................................................................40 WORKING WITH SQL DATAADAPTERS .....................................................................40 USING DATASET AND DATAVIEW COMPONENTS ................................................51 UNDERSTANDING TYPED DATASETS IN VS .NET ....................................................51 UNDERSTANDING THE DATAVIEW ..........................................................................54 USING THE DATA FORM WIZARD ........................................................................57 DATA FORM WIZARD: LOOKING UNDER THE HOOD .................................................66 UNDERSTANDING MYDS.XSD ................................................................................67 UNDERSTANDING DATAFORM1.VB ........................................................................67 SUMMARY ....................................................................................................................71 CHAPTER 3 ADO.NET IN DISCONNECTED ENVIRONMENTS .........73 UNDERSTANDING THE ADO.NET ARCHITECTURE ................................................75 EXPLORING THE ADO.NET CLASS HIERARCHY ...................................................76 CHOOSING A DATA PROVIDER ...............................................................................80 UNDERSTANDING ADO.NET DISCONNECTED CLASSES ........................................81 THE SYSTEM.DATA NAMESPACE ..........................................................................81 THE SYSTEM.DATA.COMMON NAMESPACE .........................................................82 WORKING WITH DATATABLES .................................................................................83 THE DATACOLUMN .............................................................................. ................85 THE DATAROW .............................................................................. ......................94 CONTENTS VIII THE DATARELATION ..............................................................................................99 THE DATATABLE .................................................................................................100 MORE DATATABLE OPERATIONS ..........................................................................106 THE ROW AND COLUMN COLLECTIONS ................................................................115 THE DATAROW STATES AND VERSIONS .................................................................117 USING DATASET, DATAVIEW, AND DATAVIEWMANAGER ...............................120 THE DATASET: THE HEART OF ADO.NET ............................................................121 TYPED AND UNTYPED DATASETS ........................................................................127 THE DATAVIEW .............................................................................. ...................128 THE DATAVIEWMANAGER .............................................................................. ....132 SUMMARY ..................................................................................................................133 CHAPTER 4ADO.NET IN CONNECTED ENVIRONMENTS ................135 UNDERSTANDING THE GENERIC DATA PROVIDER MODEL ...............................135 IMPORTING A NAMESPACE ....................................................................................137 EXPLORING THE SYSTEM.SQLCLIENT NAMESPACE ..........................................137 THE CONNECTION: CONNECTING TO A DATA SOURCE ...................................139 CREATING A CONNECTION .............................................................................. .....139 UNDERSTANDING THE CONNECTION PROPERTIES AND METHODS ...........................140 OPENING AND CLOSING A CONNECTION ..............................................................142 UNDERSTANDING CONNECTION POOLING .............................................................145 USING THE CREATECOMMAND AND CHANGEDATABASE METHODS ......................149 THE COMMAND: EXECUTING SQL STATEMENTS ..............................................150 CREATING A COMMAND OBJECT .........................................................................151 CREATING AND USING OLEDBCOMMAND ...........................................................153 USING THE COMMANDTYPE ENUMERATION ......................................................154 CALLING A STORED PROCEDURE ............................................................................15 5 USING TABLEDIRECT .............................................................................. .............157 EXECUTING A COMMAND ...................................................................................158 USING OTHER COMMAND METHODS ..................................................................160 THE DATAREADER: WALKING THROUGH THE DATA ........................................160 INITIALIZING A DATAREADER .............................................................................. .161 UNDERSTANDING DATAREADER PROPERTIES AND METHODS .................................161 READING WITH THE DATAREADER ........................................................................162 INTERPRETING BATCHES OF QUERIES ....................................................................164 UNDERSTANDING COMMAND BEHAVIORS ...........................................................165 THE DATAADAPTER: ADAPTING TO YOUR ENVIRONMENT .............................166 CONSTRUCTING A DATAADAPTER OBJECT .............................................................166 UNDERSTANDING DATAADAPTER PROPERTIES .......................................................168 UNDERSTANDING DATAADAPTER METHODS .........................................................170 FILLING THE DATASET .............................................................................. ............170 ADDING A DATATABLE TO A DATASET ...................................................................172 CONTENTS IX LOOKING AT A DATAADAPTER EXAMPLE ..............................................................172 FILLING THE DATAADAPTER FROM A RECORDSET ....................................................175 UPDATING THE DATABASE USING THE UPDATE METHOD .....................................176 TABLE AND COLUMN MAPPING ..........................................................................178 COMMANDBUILDER: EASING THE WORK OF PROGRAMMERS ...........................181 CREATING A COMMANDBUILDER OBJECT ............................................................182 USING SQLCOMMANDBUILDER MEMBERS ..........................................................182 USING SQLCOMMANDBUILDER ...........................................................................182 STAYING WITHIN THE PARAMETERS ................................................................184 THE DATASET IN CONNECTED ENVIRONMENTS ..............................................188 FILLING A DATASET FROM MULTIPLE TABLES ..........................................................188 USING A SQL STATEMENT TO READ DATA FROM TWO OR MORE TABLES ................190 ADDING, UPDATING, AND DELETING DATA THROUGH THE DATASET .......................190 ACCEPTING AND REJECTING CHANGES THROUGH THE DATASET .............................191 SAVING CHANGED DATA ONLY ............................................................................19 2 USING A DATASET VS. USING A DATAREADER .......................................................193 FETCHING DATA BASED ON WILDCARD CHARACTERS ..............................................194 THE DATAVIEW IN CONNECTED ENVIRONMENTS ............................................194 CREATING MULTIPLE VIEWS .................................................................................195 USING TRANSACTIONS IN ADO.NET ...................................................................200 USING CONCURRENCY IN ADO.NET ...................................................................201 UNDERSTANDING ROLLBACK, COMMIT, AND SAVEPOINTS ....................................204 EXECUTING BATCHES .............................................................................. ............206 SUMMARY ..................................................................................................................208 CHAPTER 5 HANDLING ADO.NET EVENTS .........................................209 WORKING WITH CONNECTION EVENTS ...............................................................211 WORKING WITH DATAADAPTER EVENTS ...........................................................215 WORKING WITH DATASET EVENTS ....................................................................220 WORKING WITH DATATABLE EVENTS ................................................................221 WORKING WITH XMLDATADOCUMENT EVENTS ...................................................226 WORKING WITH DATAVIEW AND DATAVIEWMANAGER EVENTS ......................229 SUMMARY ..................................................................................................................231 CHAPTER 6 INTEGRATING XML WITH ADO.NET .............................233 UNDERSTANDING MICROSOFT .NET AND XML ...................................................233 USING THE SYSTEM.XML NAMESPACE ...............................................................234 USING THE SYSTEM.XML.SCHEMA NAMESPACE .................................................235 USING THE SYSTEM.XML.SERIALIZATION NAMESPACE .........................................236 USING THE SYSTEM.XML.XPATH NAMESPACE ....................................................236 CONTENTS X USING THE SYSTEM.XML.XSL NAMESPACE .........................................................236 USING THE DOCUMENT OBJECT MODEL INTERFACES ............................................237 LOOKING AT THE XML .NET ARCHITECTURE .........................................................237 ADDING A SYSTEM.XML NAMESPACE REFERENCE ...............................................238 READING XML .............................................................................. ...........................238 GETTING NODE INFORMATION .............................................................................239 MOVING TO A CONTENT NODE .............................................................................242 USING THE GETATTRIBUTES OF A NODE ................................................................243 SEARCHING FOR A NODE .............................................................................. ........244 CLOSING THE DOCUMENT .............................................................................. .....245 UNDERSTANDING THE XMLWRITER CLASSES ...................................................246 SETTING XMLWRITER PROPERTIES .........................................................................247 WRITING XML ITEMS .........................................................................................247 SEEING XMLWRITER IN ACTION ...........................................................................248 USING THE CLOSE METHOD .................................................................................250 USING THE XMLCONVERT CLASS ......................................................................251 UNDERSTANDING THE DOM IMPLEMENTATION .................................................251 USING THE XMLNODE CLASS .............................................................................. 252 USING THE XMLDOCUMENT CLASS .....................................................................252 SAVING A DOCUMENT .............................................................................. .........253 USING THE XMLDOCUMENTFRAGMENT CLASS .....................................................253 USING THE XMLELEMENT CLASS .........................................................................254 ADDING ATTRIBUTES TO A NODE .........................................................................259 UNDERSTANDING TRANSFORMATION AND XSLT ..............................................260 USING THE TRANSFORM METHOD ........................................................................261 LOOKING AT AN EXAMPLE ...................................................................................261 USING ADO.NET AND XML TOGETHER ..............................................................262 READING XML USING A DATASET .......................................................................262 WRITING XML USING A DATASET ........................................................................264 USING XMLDATADOCUMENT AND XML .............................................................267 DISPLAYING XML DATA IN A DATASET FORMAT ...................................................270 SAVING DATA FROM A DATASET TO XML ..............................................................271 XMLDATADOCUMENT: LOOKING UNDER THE HOOD ............................................272 NAVIGATING IN XML ..........................................................................................272 USING THE XPATHNAVIGATOR CLASS ....................................................................273 USING XPATHNAVIGATOR MOVE METHODS .........................................................274 SEARCHING USING XPATHNAVIGATOR ..................................................................276 WORKING WITH SCHEMAS ....................................................................................277 GENERATING A NEW SCHEMA .............................................................................277 ADDING SCHEMA FROM A DATABASE OBJECTS ....................................................283 GENERATING A TYPED DATASET FROM A SCHEMA ................................................285 SUMMARY ..................................................................................................................286 CONTENTS XI CHAPTER 7 DATA BINDING AND WINDOWS FORMS DATA-BOUND CONTROLS ....................................................287 UNDERSTANDING DATA BINDING ......................................................................287 USING THE BINDING CLASS .............................................................................. ...288 UNDERSTANDING THE BINDINGMANAGERBASE FUNCTIONALITY ............................293 UNDERSTANDING BINDINGCONTEXT ....................................................................296 BUILDING A RECORD NAVIGATION SYSTEM ...........................................................296 WORKING WITH COMPLEX DATA-BOUND CONTROLS ........................................301 THE ROLE OF CONTROL CLASS IN DATA BINDING ...................................................301 USING THE LISTCONTROL CLASS ...........................................................................301 LISTCONTROL DATABINDING-RELATED EVENTS .....................................................302 DATA BINDING IN COMBOBOX AND LISTBOX CONTROLS ......................................304 DATA BINDING IN A DATAGRID CONTROL .............................................................306 DELETING DATA BINDING ....................................................................................307 THE DATAGRID: SUPER DATA-BOUND CONTROL ............................................307 UNDERSTANDING THE DATAGRID CLASS MEMBERS ..............................................309 EXPLORING THE DATAGRID HELPER OBJECTS ........................................................312 UNDERSTANDING THE DATAGRID AND DATAGRID COLUMN STYLES .......................313 SEEING DATAGRIDTABLESTYLE AND DATAGRIDCOLUMNSTYLE IN ACTION ..............321 SEEING HITTEST IN ACTION .................................................................................324 IMPLEMENTING CUSTOM SORTING IN A DATAGRID ..............................................334 BUILDING A DATAGRID RECORD NAVIGATION SYSTEM ..........................................335 IMPLEMENTING SEARCH IN A DATAGRID .............................................................338 INSERTING, UPDATING, AND DELETING DATA THROUGH DATAGRIDS ......................342 SUMMARY ..................................................................................................................344 CHAPTER 8 CONSTRAINTS AND DATA RELATIONS ........................345 UNDERSTANDING CONSTRAINTS ...........................................................................345 IMPLEMENTING THE CONSTRAINT CLASSES ..........................................................346 IMPLEMENTING THE FOREIGNKEYCONSTRAINT CLASS ...........................................346 UNDERSTANDING DATA RELATIONS ..................................................................353 UNDERSTANDING THE DATARELATION AND DATARELATIONCOLLECTION OBJECTS ................................................................354 SUMMARY ..................................................................................................................358 CHAPTER 9 ADO.NET EXCEPTION HANDLING ..................................359 WHY USE EXCEPTION HANDLING? ......................................................................360 USING TRY...CATCH STATEMENTS .........................................................................361 USING TRY...CATCH...FINALLY STATEMENTS ..........................................................362 CONTENTS XII NESTING TRY...CATCH STATEMENTS .....................................................................363 USING TRY WITH MULTIPLE CATCH STATEMENTS ...................................................363 DEFINING CUSTOM FILTERS AND ERROR MESSAGES ...............................................364 UNDERSTANDING THE EXCEPTION CLASSES ...................................................365 USING THE EXCEPTION CLASS: MOTHER OF ALL EXCEPTIONS ..................................365 UNDERSTANDING OTHER EXCEPTION CLASSES ......................................................366 EXCEPTION HANDLING IN ADO.NET ................................................................366 RECOGNIZING SQL SERVER 2000 ERRORS .............................................................368 USING SQL SERVER ERROR LOGS ..........................................................................370 USING THE SQLEXCEPTION CLASS ........................................................................371 USING THE SQLERROR AND SQLERRORCOLLECTION CLASSES .....................................373 SUMMARY ..................................................................................................................374 CHAPTER 10 WORKING WITH THE ODBC .NET DATA PROVIDER .......................................................375 USING THE ODBC .NET DATA PROVIDER .........................................................375 INSTALLING THE ODBC .NET DATA PROVIDER ......................................................376 UNDERSTANDING THE ODBC .NET DATA PROVIDER ............................................377 ACCESSING ACCESS DATABASES .........................................................................378 ACCESSING MYSQL DATABASES ...........................................................................380 ACCESSING MYSQL DATABASES ...........................................................................381 ACCESSING TEXT FILE DATABASES ................................................................382 EXPORTING AN ACCESS TABLE TO A TEXT FILE .......................................................383 ACCESSING A TEXT FILE .............................................................................. .........385 ACCESSING EXCEL DATABASES .........................................................................389 IMPLEMENTING TWO .NET 1.1 UPDATES .........................................................391 SUMMARY ..................................................................................................................391 CHAPTER 11 STORED PROCEDURES AND VIEWS ...............................393 WORKING WITH STORED PROCEDURES ................................................................393 CREATING A STORED PROCEDURE ..........................................................................393 EXECUTING A STORED PROCEDURE FROM VS .NET ................................................397 EXECUTING A STORED PROCEDURE PROGRAMMATICALLY .......................................399 UNDERSTANDING SQL INJECTION ....................................................................405 WORKING WITH VIEWS ........................................................................................406 CREATING A VIEW .............................................................................. .................406 EXECUTING A VIEW FROM VS .NET .....................................................................409 RETRIEVING DATA FROM A VIEW PROGRAMMATICALLY ...........................................409 FILLING A DATASET FROM MULTIPLE VIEWS ..........................................................411 SUMMARY ..................................................................................................................411 CONTENTS XIII CHAPTER 12 ORACLE, SQLXML, AND OTHER .NET DATA PROVIDERS ....................................................413 USING ORACLE .NET DATA PROVIDERS ...........................................................413 ADDING A REFERENCE TO THE ORACLE .NET DATA PROVIDER ................................415 USING THE ORACLE .NET DATA PROVIDER CLASSES ..............................................416 USING THE SQLXML AND SQL XML .NET DATA PROVIDERS ......................426 USING THE FOR XML KEYWORD ........................................................................427 USING THE SQLXMLADAPTER OBJECT ..................................................................428 USING THE SQLXMLPARAMETER OBJECT ..............................................................429 USING THE SQLXMLCOMMAND OBJECT ..............................................................430 USING A MYSQL DATABASE AND THE .NET DATA PROVIDER ....................435 SUMMARY ..................................................................................................................435 CHAPTER 13 DEVELOPING A CUSTOM DATA PROVIDER ................437 OVERVIEW OF THE DATA PROVIDER INTERFACES ..........................................438 UNDERSTANDING THE CONNECTION OBJECT ........................................................439 UNDERSTANDING THE COMMAND OBJECT ..........................................................440 UNDERSTANDING THE READER OBJECT ................................................................441 UNDERSTANDING THE ADAPTER OBJECT ...............................................................443 BUILDING A CUSTOM DATA PROVIDER ...........................................................446 CREATING THE PIPEDDATACONNECTION OBJECT .................................................446 CREATING THE PIPEDDATACOMMAND OBJECT ...................................................449 CREATING THE PIPEDDATAREADER OBJECT ..........................................................453 CREATING THE PIPEDDATAADAPTER OBJECT ........................................................460 TESTING THE PIPEDDATAPROVIDER APPLICATION .................................................462 DEBUGGING YOUR CUSTOM DATA PROVIDER ...................................................464 SUMMARY ..................................................................................................................464 CHAPTER 14 DEVELOPING DATABASE WEB APPLICATIONS USING ASP.NET ....................................................................465 INTRODUCING ASP.NET ........................................................................................465 ASP.NET PLATFORM REQUIREMENTS ..................................................................466 ASP.NET LANGUAGE SUPPORT ...........................................................................466 INSTALLING ASP.NET .............................................................................. ............466 ASP.NET EDITORS ..............................................................................................466 ASP.NET: AN EVOLUTION OF ASP .......................................................................467 WEB FORMS AND WEB SERVICES ........................................................................468 CONTENTS XIV DEVELOPING YOUR FIRST ASP.NET WEB APPLICATION .............................468 CREATING A WEB APPLICATION PROJECT ..............................................................469 ADDING WEB CONTROLS TO A WEB FORM ............................................................472 SETTING CONTROL PROPERTIES .............................................................................4 74 USING DOCUMENT OUTLINE ...............................................................................475 WRITING CODE ON THE BUTTON CLICK EVENT HANDLER ........................................477 CREATING YOUR FIRST ADO.NET WEB APPLICATION .................................478 USING ASP.NET SERVER-SIDE CONTROLS .....................................................480 HTML SERVER CONTROLS .............................................................................. .....481 VALIDATION CONTROLS .............................................................................. ..........482 USER CONTROLS .............................................................................. ....................483 SERVER CONTROLS AND THE .NET FRAMEWORK LIBRARY ......................................483 WHY ARE WEB FORMS CONTROLS CALLED SERVER-SIDE CONTROLS? .......................485 ADDING SERVER-SIDE CONTROLS TO A WEB FORM ................................................485 UNDERSTANDING DATA BINDING IN ASP.NET ..............................................487 DATA-BOUND CONTROLS .....................................................................................488 DATAGRID AND DATALIST CONTROLS ...................................................................490 PAGING IN THE DATAGRID CONTROL .....................................................................499 ENABLING PAGING PROGRAMMATICALLY ...............................................................500 ADDING, EDITING, AND DELETING DATA IN WEB FORMS ......................................502 ADDING DATA .............................................................................. ......................505 UPDATING DATA .............................................................................. ..................506 DELETING DATA ..................................................................................................507 CREATING A GUEST BOOK IN ASP.NET .........................................................507 DEFAULT WEB FORM: MYGUESTBOOK.ASPX ........................................................508 ADDING FORMS TO THE GUEST BOOK ..................................................................511 COMPILING AND RUNNING THE GUEST BOOK PROJECT .........................................514 SUMMARY ..................................................................................................................516 CHAPTER 15 USING ADO.NET IN XML WEB SERVICES ................517 EXPLORING WEB SERVICES AND THE .NET FRAMEWORK LIBRARY ..............518 CREATING A WEB SERVICE IN VS .NET .........................................................518 TESTING YOUR WEB SERVICE .............................................................................521 CREATING THE WEB SERVICE CONSUMER .......................................................524 ADDING DATA TO A DATABASE THROUGH A WEB SERVICE .....................................529 ADDING MORE FUNCTIONALITY TO THE WEB SERVICE ............................................534 SUMMARY ..................................................................................................................535 CONTENTS XV CHAPTER 16 ASP.NET SERVER CONTROLS AND DATA BINDING ............................................................537 DATA BINDING IN WEB FORMS, REVISITED .................................................537 READ-ONLY DATA BINDING ................................................................................537 SIMPLE AND COMPLEX DATA BINDING ...............................................................538 THE ROLES OF THE CONTROL AND PAGE CLASSES IN DATA BINDING .......................539 DATA BINDING IN SIMPLE WEB FORMS CONTROLS ......................................540 USING THE BUTTON CONTROL ...............................................................................540 USING THE CALENDAR CONTROL ...........................................................................542 UNDERSTANDING WEB SERVER CONTROL TEMPLATES ............................................546 USING THE REPEATER CONTROL ...........................................................................552 UNDERSTANDING THE ROLE OF THE LISTCONTROL CLASS ........................................555 USING THE LISTBOX CONTROL ..............................................................................556 USING THE DROPDOWNLIST CONTROL .................................................................558 DATA BINDING IN OTHER SIMPLE CONTROLS ........................................................560 DATA BINDING IN COMPLEX WEB FORMS CONTROLS ...................................562 UNDERSTANDING THE BASEDATALIST CLASS ........................................................562 USING THE DATAKEYCOLLECTION CLASS ...............................................................563 USING THE DATALIST WEB SERVER CONTROL ........................................................564 USING THE DATAGRID WEB SERVER CONTROL .......................................................582 SUMMARY ..................................................................................................................608 CHAPTER 17 BUILDING REAL-WORLD WEB APPLICATIONS ........609 INTRODUCING THE JOB BOARD APPLICATION SPECIFICATIONS ..............609 UNDERSTANDING THE DATABASE SCHEMA .......................................................610 DEVELOPING THE ONLINE JOB BOARD APPLICATION .................................611 CREATING THE LOGIN.ASPX PAGE ........................................................................612 CREATING THE REGISTER.ASPX PAGE .....................................................................615 CREATING THE CONTACT.ASPX PAGE .....................................................................617 CREATING THE POSTJOB.ASPX PAGE .....................................................................618 CREATING THE POSTRESUME.ASPX PAGE .............................................................620 CREATING THE DISPLAYDATA.ASPX AND RESUMES.ASPX PAGES ...........................623 CREATING THE DNJHEADER.ASPX PAGE ................................................................632 RUNNING THE APPLICATION ................................................................................633 IMPROVING AND MODIFYING THE APPLICATION ............................................635 SUMMARY ..................................................................................................................636 CONTENTS XVI CHAPTER 18 OBJECT-RELATIONAL MAPPING IN .NET ................637 WHY NOT JUST USE A DATASET? ......................................................................638 UNDERSTANDING OBJECT DATABASES ................................................................639 WHY OBJECT RELATIONAL MAPPING? ................................................................640 CREATING THE BASIC DESIGN OF THE VIDEO STORE APPLICATION .......640 UNDERSTANDING THE BASIC ARCHITECTURE ..........................................................641 CREATING THE DATABASE DESIGN OF THE VIDEO STORE ........................................641 CREATING THE DATA OBJECT .............................................................................. .643 CREATING THE MAPPED OBJECT .........................................................................644 CREATING THE DATA ACCESS COMPONENT ..........................................................648 BUILDING THE VIDEOTAPE TEST CASE .................................................................652 USING THE USER COMPONENT ...........................................................................654 CREATING THE USER TEST CASE ...........................................................................659 MANAGING DEPENDENCIES ...............................................................................661 CREATING THE CHECK IN/CHECK OUT COMPONENT ...........................................663 SEEING HOW IT WORKS .......................................................................................664 MAKING DESIGN TRADEOFFS .............................................................................665 UNDERSTANDING LOGIC IN STORED PROCEDURES .................................................665 UNDERSTANDING COMPONENT ISOLATION ..........................................................666 CREATING A WORKAROUND ON PART OF THE PROBLEM ...........................................667 CREATING THE VIDEOCHECKINCHECKOUT TEST CASE ..........................................670 SUMMARY ................................................................................................................673 CHAPTER 19 MAPPED OBJECTS: PERFORMANCE CONSIDERATIONS AND DATA BINDING .....................675 USING DATA BINDING AND MAPPED OBJECTS .................................................675 DIRECTLY ACCESSING A BOUND OBJECTS PROPERTIES ..........................................678 USING LOGIC WITH BOUND OBJECTS ...................................................................680 UNDERSTANDING PROBLEMATIC MASTER-DETAIL RELATIONSHIPS ..............684 WORKING WITH HIGHLY NESTED STRUCTURES .......................................................685 WORKING WITH A MUCH LARGER TREE .................................................................691 A FINAL NOTE ON TREE OPTIMIZATION ...............................................................693 WORKING WITH LARGE MASTER-DETAIL RELATIONSHIPS ...........................694 IMPLEMENTING LAZY LOADING .........................................................................695 IMPLEMENTING AN INCREMENTAL LAZY LOADING SCHEME ................................700 LOADING THE DETAIL WHEN THE MASTER IS LOADED ...........................................705 USING A NEAR-ZERO-IMPACT CACHING MECHANISM ......................................706 SUMMARY ..................................................................................................................708 CONTENTS XVII CHAPTER 20 COM INTEROPERABILITY AND ADO.NET ..................709 EXPLORING THE .NET INTEROP TOOLS ...........................................................710 USING VISUAL STUDIO .NET .............................................................................. .710 USING THE TYPE LIBRARY IMPORTER AND EXPORTER (TLBIMP.EXE) .....................711 USING THE TYPE LIBRARY EXPORTER (TLBEXP.EXE) .............................................712 USING THE ADO RECORDSET IN ADO.NET .....................................................712 USING ADOX WITH ADO.NET .............................................................................716 ACCESSING OLAP SERVER DATA WITH ADO.NET ..........................................718 SUMMARY ................................................................................................................724 CHAPTER 21 MESSAGING ..............................................................................725 INTRODUCING TYPES OF QUEUES ......................................................................725 USING USER QUEUES .............................................................................. ...........726 USING SYSTEM QUEUES .....................................................................................726 INSTALLING MESSAGE QUEUING ......................................................................726 USING THE SYSTEM.MESSAGING NAMESPACE .................................................727 WORKING WITH MESSAGE QUEUES ....................................................................729 USING THE MESSAGEQUEUE PROPERTIES ............................................................729 MANAGING QUEUES USING VS .NET .................................................................731 RETRIEVING AVAILABLE QUEUES ..........................................................................732 FILTERING QUEUES USING MESSAGEQUEUECRITERIA ...........................................734 CREATING AND DELETING MESSAGE QUEUES PROGRAMMATICALLY ........................735 CREATING A SAMPLE APPLICATION ................................................................736 CREATING A MESSAGEQUEUE INSTANCE ..............................................................738 SETTING A QUEUES PATH ....................................................................................739 SENDING AND RECEIVING MESSAGES ..................................................................740 WALKING THROUGH SIMPLE MESSAGING APPLICATION ........................................741 WORKING WITH MESSAGES .............................................................................. ...745 CREATING AND REMOVING MESSAGES ................................................................745 SETTING QUEUE AND MESSAGE PRIORITIES ..........................................................746 UNDERSTANDING TRANSACTIONAL MESSAGING ..............................................747 USING THE MESSAGEQUEUETRANSACTION CLASS .................................................747 CREATING TRANSACTIONAL QUEUES .....................................................................748 SENDING AND RECEIVING TRANSACTIONAL MESSAGES ..........................................748 ENCRYPTING MESSAGES ......................................................................................750 SUMMARY ................................................................................................................752 CONTENTS XVIII CHAPTER 22 SQL SERVER AND ADO.NET: NOTES ON PERFORMANCE .................................................753 IMPROVING SQL SERVER PERFORMANCE ...........................................................753 USING INDEXES .............................................................................. ...................753 CHOOSING WHICH COLUMNS TO INDEX ..............................................................757 UNDERSTANDING THE SQL SERVER PROFILER ........................................................758 OPTIMIZING AUTOMATICALLY WITH THE SQL SERVER PROFILER ..............................760 OPTIMIZING YOUR TRANSACT-SQL QUERIES FOR PERFORMANCE ...........................762 AVOIDING EXCESSIVE STORED PROCEDURE RECOMPILATION .................................765 AVOIDING LOCKS ................................................................................................766 DESIGNING YOUR TABLES FOR OPTIMAL PERFORMANCE .........................................766 CHECKING THE SIZE OF DATABASE PAGES ............................................................767 UNDERSTANDING DENORMALIZATION ..................................................................768 UNDERSTANDING THE DANGERS OF DATABASE DESIGN SLIPPAGE .........................768 UNDERSTANDING ADO.NET PERFORMANCE ISSUES AND USING BEST PRACTICES ...........................................................................769 SELECTING DATA PROVIDERS .............................................................................. ..769 WRITING A GENERIC DATA ACCESS COMPONENT .................................................770 CHOOSING A DEVELOPMENT MODE: DESIGNER VS. MANUAL ...............................775 RETRIEVING DATA: DATAREADER, XMLREADER, AND DATASET ..............................775 UPDATING A DATA SOURCE: COMMAND VS. DATASET .........................................776 SAVING DATA AND USING GETCHANGES .............................................................777 RETRIEVING DATA WITH THE SELECT STATEMENT ...............................................777 USING STORED PROCEDURES ................................................................................777 USING CONNECTION STRINGS AND POOLING .........................................................777 SUMMARY ................................................................................................................778 APPENDIX A RELATIONAL DATABASES: SOME BASIC CONCEPTS ....................................................779 UNDERSTANDING NORMALIZATION ......................................................................780 FIRST NORMAL FORM (1NF) .............................................................................. .780 SECOND NORMAL FORM (2NF) ..........................................................................782 THIRD NORMAL FORM (3NF) .............................................................................7 84 BOYCE-CODD NORMAL FORM (BCNF) ...............................................................785 FOURTH NORMAL FORM (4NF) ...........................................................................785 FIFTH NORMAL FORM (5NF OR PJ/NF) ...............................................................786 INTRODUCING SETS, CURSORS, AND ADO.NET ............................................786 CONTENTS XIX USING LOCKING ...................................................................................................788 ISOLATION LEVELS .............................................................................. .................788 LOCKING MODES ................................................................................................790 SUMMARY ................................................................................................................792 APPENDIX B COMMONLY USED SQL STATEMENTS .............................793 UNDERSTANDING SQL REFERENCES ....................................................................793 USING THE SELECT STATEMENT ........................................................................796 USING THE UPDATE STATEMENT .......................................................................802 USING THE DELETE STATEMENT ........................................................................802 USING THE CREATE TABLE STATEMENT ............................................................803 USING THE DROP TABLE STATEMENT ...............................................................803 USING THE TRUNCATE TABLE STATEMENT ......................................................804 USING THE INSERT STATEMENT .........................................................................805 USING JOINS AND ALIASES .............................................................................. ....806 UNDERSTANDING VIEWS ......................................................................................807 USING SQL SERVER*S SELECT...FOR XML CLAUSE ......................................809 SUMMARY ..................................................................................................................810 APPENDIX C ADO.NET FREQUENTLY ASKED QUESTIONS .............811 SUMMARY ..................................................................................................................845 INDEX ....................................................................................................................847 CONTENTS XX
adam_txt	CONTENTS ABOUT THE AUTHORS .XXI ABOUT THE TECHNICAL REVIEWER .XXIII ACKNOWLEDGMENTS .XXV INTRODUCTION .XXVII CHAPTER 1 ADO.NET BASICS .1 OVERVIEW OF MICROSOFT DATA ACCESS TECHNOLOGIES .2 ODBC . .2 DAO . .4 MFC ODBC AND DAO CLASSES .5 RDO . .5 OLE DB .5 ADO . .6 ADO.NET .6 WHAT IS ADO.NET? . .7 WHY ADO.NET WAS DESIGNED .8 ADVANTAGES OF ADO.NET . .9 SINGLE OBJECT-ORIENTED API . .9 MANAGED CODE .10 XML SUPPORT .10 VISUAL DATA COMPONENTS .11 PERFORMANCE AND SCALABILITY .11 COMPARING ADO.NET AND ADO .11 CONNECTIONS AND DISCONNECTED DATA .11 RECORDSETS VS. DATASETS .12 XML SUPPORT .12 OVERVIEW OF ADO.NET NAMESPACES AND CLASSES .13 UNDERSTANDING ADO.NET COMPONENTS .15 THE CONNECTION OBJECT .16 THE COMMAND OBJECT .17 THE COMMAND BUILDER . .19 THE DATAADAPTER OBJECT . .19 DATASET STRUCTURE . .20 DATASETS IN DATAVIEWS . .21 VII WRITING ADO.NET APPLICATIONS .22 CHOOSING A .NET DATA PROVIDER .22 ADDING NAMESPACE REFERENCES .23 ESTABLISHING A CONNECTION .24 CREATING A COMMAND OR DATAADAPTER OBJECT .25 FILLING DATA TO A DATASET OR DATAREADER OBJECT .25 DISPLAYING DATA . .25 CLOSING THE CONNECTION . .26 CREATING A SIMPLE ADO.NET APPLICATION .26 USING A DATASET TO READ DATA .28 SUMMARY .31 CHAPTER 2 DATA COMPONENTS IN VISUAL STUDIO .NET .33 CREATING AN ADO.NET PROJECT .33 USING THE SERVER EXPLORER .34 ADDING A NEW CONNECTION .35 MANAGING AND VIEWING DATA .36 USING VISUAL DATA COMPONENTS .37 UNDERSTANDING DATA CONNECTIONS .38 UNDERSTANDING CONNECTION STRINGS .40 WORKING WITH SQL DATAADAPTERS .40 USING DATASET AND DATAVIEW COMPONENTS .51 UNDERSTANDING TYPED DATASETS IN VS .NET .51 UNDERSTANDING THE DATAVIEW .54 USING THE DATA FORM WIZARD .57 DATA FORM WIZARD: LOOKING UNDER THE HOOD .66 UNDERSTANDING MYDS.XSD .67 UNDERSTANDING DATAFORM1.VB .67 SUMMARY .71 CHAPTER 3 ADO.NET IN DISCONNECTED ENVIRONMENTS .73 UNDERSTANDING THE ADO.NET ARCHITECTURE .75 EXPLORING THE ADO.NET CLASS HIERARCHY .76 CHOOSING A DATA PROVIDER .80 UNDERSTANDING ADO.NET DISCONNECTED CLASSES .81 THE SYSTEM.DATA NAMESPACE .81 THE SYSTEM.DATA.COMMON NAMESPACE .82 WORKING WITH DATATABLES .83 THE DATACOLUMN . .85 THE DATAROW . .94 CONTENTS VIII THE DATARELATION .99 THE DATATABLE .100 MORE DATATABLE OPERATIONS .106 THE ROW AND COLUMN COLLECTIONS .115 THE DATAROW STATES AND VERSIONS .117 USING DATASET, DATAVIEW, AND DATAVIEWMANAGER .120 THE DATASET: THE HEART OF ADO.NET .121 TYPED AND UNTYPED DATASETS .127 THE DATAVIEW . .128 THE DATAVIEWMANAGER . .132 SUMMARY .133 CHAPTER 4ADO.NET IN CONNECTED ENVIRONMENTS .135 UNDERSTANDING THE GENERIC DATA PROVIDER MODEL .135 IMPORTING A NAMESPACE .137 EXPLORING THE SYSTEM.SQLCLIENT NAMESPACE .137 THE CONNECTION: CONNECTING TO A DATA SOURCE .139 CREATING A CONNECTION . .139 UNDERSTANDING THE CONNECTION PROPERTIES AND METHODS .140 OPENING AND CLOSING A CONNECTION .142 UNDERSTANDING CONNECTION POOLING .145 USING THE CREATECOMMAND AND CHANGEDATABASE METHODS .149 THE COMMAND: EXECUTING SQL STATEMENTS .150 CREATING A COMMAND OBJECT .151 CREATING AND USING OLEDBCOMMAND .153 USING THE COMMANDTYPE ENUMERATION .154 CALLING A STORED PROCEDURE .15 5 USING TABLEDIRECT . .157 EXECUTING A COMMAND .158 USING OTHER COMMAND METHODS .160 THE DATAREADER: WALKING THROUGH THE DATA .160 INITIALIZING A DATAREADER . .161 UNDERSTANDING DATAREADER PROPERTIES AND METHODS .161 READING WITH THE DATAREADER .162 INTERPRETING BATCHES OF QUERIES .164 UNDERSTANDING COMMAND BEHAVIORS .165 THE DATAADAPTER: ADAPTING TO YOUR ENVIRONMENT .166 CONSTRUCTING A DATAADAPTER OBJECT .166 UNDERSTANDING DATAADAPTER PROPERTIES .168 UNDERSTANDING DATAADAPTER METHODS .170 FILLING THE DATASET . .170 ADDING A DATATABLE TO A DATASET .172 CONTENTS IX LOOKING AT A DATAADAPTER EXAMPLE .172 FILLING THE DATAADAPTER FROM A RECORDSET .175 UPDATING THE DATABASE USING THE UPDATE METHOD .176 TABLE AND COLUMN MAPPING .178 COMMANDBUILDER: EASING THE WORK OF PROGRAMMERS .181 CREATING A COMMANDBUILDER OBJECT .182 USING SQLCOMMANDBUILDER MEMBERS .182 USING SQLCOMMANDBUILDER .182 STAYING WITHIN THE PARAMETERS .184 THE DATASET IN CONNECTED ENVIRONMENTS .188 FILLING A DATASET FROM MULTIPLE TABLES .188 USING A SQL STATEMENT TO READ DATA FROM TWO OR MORE TABLES .190 ADDING, UPDATING, AND DELETING DATA THROUGH THE DATASET .190 ACCEPTING AND REJECTING CHANGES THROUGH THE DATASET .191 SAVING CHANGED DATA ONLY .19 2 USING A DATASET VS. USING A DATAREADER .193 FETCHING DATA BASED ON WILDCARD CHARACTERS .194 THE DATAVIEW IN CONNECTED ENVIRONMENTS .194 CREATING MULTIPLE VIEWS .195 USING TRANSACTIONS IN ADO.NET .200 USING CONCURRENCY IN ADO.NET .201 UNDERSTANDING ROLLBACK, COMMIT, AND SAVEPOINTS .204 EXECUTING BATCHES . .206 SUMMARY .208 CHAPTER 5 HANDLING ADO.NET EVENTS .209 WORKING WITH CONNECTION EVENTS .211 WORKING WITH DATAADAPTER EVENTS .215 WORKING WITH DATASET EVENTS .220 WORKING WITH DATATABLE EVENTS .221 WORKING WITH XMLDATADOCUMENT EVENTS .226 WORKING WITH DATAVIEW AND DATAVIEWMANAGER EVENTS .229 SUMMARY .231 CHAPTER 6 INTEGRATING XML WITH ADO.NET .233 UNDERSTANDING MICROSOFT .NET AND XML .233 USING THE SYSTEM.XML NAMESPACE .234 USING THE SYSTEM.XML.SCHEMA NAMESPACE .235 USING THE SYSTEM.XML.SERIALIZATION NAMESPACE .236 USING THE SYSTEM.XML.XPATH NAMESPACE .236 CONTENTS X USING THE SYSTEM.XML.XSL NAMESPACE .236 USING THE DOCUMENT OBJECT MODEL INTERFACES .237 LOOKING AT THE XML .NET ARCHITECTURE .237 ADDING A SYSTEM.XML NAMESPACE REFERENCE .238 READING XML . .238 GETTING NODE INFORMATION .239 MOVING TO A CONTENT NODE .242 USING THE GETATTRIBUTES OF A NODE .243 SEARCHING FOR A NODE . .244 CLOSING THE DOCUMENT . .245 UNDERSTANDING THE XMLWRITER CLASSES .246 SETTING XMLWRITER PROPERTIES .247 WRITING XML ITEMS .247 SEEING XMLWRITER IN ACTION .248 USING THE CLOSE METHOD .250 USING THE XMLCONVERT CLASS .251 UNDERSTANDING THE DOM IMPLEMENTATION .251 USING THE XMLNODE CLASS . 252 USING THE XMLDOCUMENT CLASS .252 SAVING A DOCUMENT . .253 USING THE XMLDOCUMENTFRAGMENT CLASS .253 USING THE XMLELEMENT CLASS .254 ADDING ATTRIBUTES TO A NODE .259 UNDERSTANDING TRANSFORMATION AND XSLT .260 USING THE TRANSFORM METHOD .261 LOOKING AT AN EXAMPLE .261 USING ADO.NET AND XML TOGETHER .262 READING XML USING A DATASET .262 WRITING XML USING A DATASET .264 USING XMLDATADOCUMENT AND XML .267 DISPLAYING XML DATA IN A DATASET FORMAT .270 SAVING DATA FROM A DATASET TO XML .271 XMLDATADOCUMENT: LOOKING UNDER THE HOOD .272 NAVIGATING IN XML .272 USING THE XPATHNAVIGATOR CLASS .273 USING XPATHNAVIGATOR MOVE METHODS .274 SEARCHING USING XPATHNAVIGATOR .276 WORKING WITH SCHEMAS .277 GENERATING A NEW SCHEMA .277 ADDING SCHEMA FROM A DATABASE OBJECTS .283 GENERATING A TYPED DATASET FROM A SCHEMA .285 SUMMARY .286 CONTENTS XI CHAPTER 7 DATA BINDING AND WINDOWS FORMS DATA-BOUND CONTROLS .287 UNDERSTANDING DATA BINDING .287 USING THE BINDING CLASS . .288 UNDERSTANDING THE BINDINGMANAGERBASE FUNCTIONALITY .293 UNDERSTANDING BINDINGCONTEXT .296 BUILDING A RECORD NAVIGATION SYSTEM .296 WORKING WITH COMPLEX DATA-BOUND CONTROLS .301 THE ROLE OF CONTROL CLASS IN DATA BINDING .301 USING THE LISTCONTROL CLASS .301 LISTCONTROL DATABINDING-RELATED EVENTS .302 DATA BINDING IN COMBOBOX AND LISTBOX CONTROLS .304 DATA BINDING IN A DATAGRID CONTROL .306 DELETING DATA BINDING .307 THE DATAGRID: SUPER DATA-BOUND CONTROL .307 UNDERSTANDING THE DATAGRID CLASS MEMBERS .309 EXPLORING THE DATAGRID HELPER OBJECTS .312 UNDERSTANDING THE DATAGRID AND DATAGRID COLUMN STYLES .313 SEEING DATAGRIDTABLESTYLE AND DATAGRIDCOLUMNSTYLE IN ACTION .321 SEEING HITTEST IN ACTION .324 IMPLEMENTING CUSTOM SORTING IN A DATAGRID .334 BUILDING A DATAGRID RECORD NAVIGATION SYSTEM .335 IMPLEMENTING SEARCH IN A DATAGRID .338 INSERTING, UPDATING, AND DELETING DATA THROUGH DATAGRIDS .342 SUMMARY .344 CHAPTER 8 CONSTRAINTS AND DATA RELATIONS .345 UNDERSTANDING CONSTRAINTS .345 IMPLEMENTING THE CONSTRAINT CLASSES .346 IMPLEMENTING THE FOREIGNKEYCONSTRAINT CLASS .346 UNDERSTANDING DATA RELATIONS .353 UNDERSTANDING THE DATARELATION AND DATARELATIONCOLLECTION OBJECTS .354 SUMMARY .358 CHAPTER 9 ADO.NET EXCEPTION HANDLING .359 WHY USE EXCEPTION HANDLING? .360 USING TRY.CATCH STATEMENTS .361 USING TRY.CATCH.FINALLY STATEMENTS .362 CONTENTS XII NESTING TRY.CATCH STATEMENTS .363 USING TRY WITH MULTIPLE CATCH STATEMENTS .363 DEFINING CUSTOM FILTERS AND ERROR MESSAGES .364 UNDERSTANDING THE EXCEPTION CLASSES .365 USING THE EXCEPTION CLASS: MOTHER OF ALL EXCEPTIONS .365 UNDERSTANDING OTHER EXCEPTION CLASSES .366 EXCEPTION HANDLING IN ADO.NET .366 RECOGNIZING SQL SERVER 2000 ERRORS .368 USING SQL SERVER ERROR LOGS .370 USING THE SQLEXCEPTION CLASS .371 USING THE SQLERROR AND SQLERRORCOLLECTION CLASSES .373 SUMMARY .374 CHAPTER 10 WORKING WITH THE ODBC .NET DATA PROVIDER .375 USING THE ODBC .NET DATA PROVIDER .375 INSTALLING THE ODBC .NET DATA PROVIDER .376 UNDERSTANDING THE ODBC .NET DATA PROVIDER .377 ACCESSING ACCESS DATABASES .378 ACCESSING MYSQL DATABASES .380 ACCESSING MYSQL DATABASES .381 ACCESSING TEXT FILE DATABASES .382 EXPORTING AN ACCESS TABLE TO A TEXT FILE .383 ACCESSING A TEXT FILE . .385 ACCESSING EXCEL DATABASES .389 IMPLEMENTING TWO .NET 1.1 UPDATES .391 SUMMARY .391 CHAPTER 11 STORED PROCEDURES AND VIEWS .393 WORKING WITH STORED PROCEDURES .393 CREATING A STORED PROCEDURE .393 EXECUTING A STORED PROCEDURE FROM VS .NET .397 EXECUTING A STORED PROCEDURE PROGRAMMATICALLY .399 UNDERSTANDING SQL INJECTION .405 WORKING WITH VIEWS .406 CREATING A VIEW . .406 EXECUTING A VIEW FROM VS .NET .409 RETRIEVING DATA FROM A VIEW PROGRAMMATICALLY .409 FILLING A DATASET FROM MULTIPLE VIEWS .411 SUMMARY .411 CONTENTS XIII CHAPTER 12 ORACLE, SQLXML, AND OTHER .NET DATA PROVIDERS .413 USING ORACLE .NET DATA PROVIDERS .413 ADDING A REFERENCE TO THE ORACLE .NET DATA PROVIDER .415 USING THE ORACLE .NET DATA PROVIDER CLASSES .416 USING THE SQLXML AND SQL XML .NET DATA PROVIDERS .426 USING THE FOR XML KEYWORD .427 USING THE SQLXMLADAPTER OBJECT .428 USING THE SQLXMLPARAMETER OBJECT .429 USING THE SQLXMLCOMMAND OBJECT .430 USING A MYSQL DATABASE AND THE .NET DATA PROVIDER .435 SUMMARY .435 CHAPTER 13 DEVELOPING A CUSTOM DATA PROVIDER .437 OVERVIEW OF THE DATA PROVIDER INTERFACES .438 UNDERSTANDING THE CONNECTION OBJECT .439 UNDERSTANDING THE COMMAND OBJECT .440 UNDERSTANDING THE READER OBJECT .441 UNDERSTANDING THE ADAPTER OBJECT .443 BUILDING A CUSTOM DATA PROVIDER .446 CREATING THE PIPEDDATACONNECTION OBJECT .446 CREATING THE PIPEDDATACOMMAND OBJECT .449 CREATING THE PIPEDDATAREADER OBJECT .453 CREATING THE PIPEDDATAADAPTER OBJECT .460 TESTING THE PIPEDDATAPROVIDER APPLICATION .462 DEBUGGING YOUR CUSTOM DATA PROVIDER .464 SUMMARY .464 CHAPTER 14 DEVELOPING DATABASE WEB APPLICATIONS USING ASP.NET .465 INTRODUCING ASP.NET .465 ASP.NET PLATFORM REQUIREMENTS .466 ASP.NET LANGUAGE SUPPORT .466 INSTALLING ASP.NET . .466 ASP.NET EDITORS .466 ASP.NET: AN EVOLUTION OF ASP .467 WEB FORMS AND WEB SERVICES .468 CONTENTS XIV DEVELOPING YOUR FIRST ASP.NET WEB APPLICATION .468 CREATING A WEB APPLICATION PROJECT .469 ADDING WEB CONTROLS TO A WEB FORM .472 SETTING CONTROL PROPERTIES .4 74 USING DOCUMENT OUTLINE .475 WRITING CODE ON THE BUTTON CLICK EVENT HANDLER .477 CREATING YOUR FIRST ADO.NET WEB APPLICATION .478 USING ASP.NET SERVER-SIDE CONTROLS .480 HTML SERVER CONTROLS . .481 VALIDATION CONTROLS . .482 USER CONTROLS . .483 SERVER CONTROLS AND THE .NET FRAMEWORK LIBRARY .483 WHY ARE WEB FORMS CONTROLS CALLED SERVER-SIDE CONTROLS? .485 ADDING SERVER-SIDE CONTROLS TO A WEB FORM .485 UNDERSTANDING DATA BINDING IN ASP.NET .487 DATA-BOUND CONTROLS .488 DATAGRID AND DATALIST CONTROLS .490 PAGING IN THE DATAGRID CONTROL .499 ENABLING PAGING PROGRAMMATICALLY .500 ADDING, EDITING, AND DELETING DATA IN WEB FORMS .502 ADDING DATA . .505 UPDATING DATA . .506 DELETING DATA .507 CREATING A GUEST BOOK IN ASP.NET .507 DEFAULT WEB FORM: MYGUESTBOOK.ASPX .508 ADDING FORMS TO THE GUEST BOOK .511 COMPILING AND RUNNING THE GUEST BOOK PROJECT .514 SUMMARY .516 CHAPTER 15 USING ADO.NET IN XML WEB SERVICES .517 EXPLORING WEB SERVICES AND THE .NET FRAMEWORK LIBRARY .518 CREATING A WEB SERVICE IN VS .NET .518 TESTING YOUR WEB SERVICE .521 CREATING THE WEB SERVICE CONSUMER .524 ADDING DATA TO A DATABASE THROUGH A WEB SERVICE .529 ADDING MORE FUNCTIONALITY TO THE WEB SERVICE .534 SUMMARY .535 CONTENTS XV CHAPTER 16 ASP.NET SERVER CONTROLS AND DATA BINDING .537 DATA BINDING IN WEB FORMS, REVISITED .537 READ-ONLY DATA BINDING .537 SIMPLE AND COMPLEX DATA BINDING .538 THE ROLES OF THE CONTROL AND PAGE CLASSES IN DATA BINDING .539 DATA BINDING IN SIMPLE WEB FORMS CONTROLS .540 USING THE BUTTON CONTROL .540 USING THE CALENDAR CONTROL .542 UNDERSTANDING WEB SERVER CONTROL TEMPLATES .546 USING THE REPEATER CONTROL .552 UNDERSTANDING THE ROLE OF THE LISTCONTROL CLASS .555 USING THE LISTBOX CONTROL .556 USING THE DROPDOWNLIST CONTROL .558 DATA BINDING IN OTHER SIMPLE CONTROLS .560 DATA BINDING IN COMPLEX WEB FORMS CONTROLS .562 UNDERSTANDING THE BASEDATALIST CLASS .562 USING THE DATAKEYCOLLECTION CLASS .563 USING THE DATALIST WEB SERVER CONTROL .564 USING THE DATAGRID WEB SERVER CONTROL .582 SUMMARY .608 CHAPTER 17 BUILDING REAL-WORLD WEB APPLICATIONS .609 INTRODUCING THE JOB BOARD APPLICATION SPECIFICATIONS .609 UNDERSTANDING THE DATABASE SCHEMA .610 DEVELOPING THE ONLINE JOB BOARD APPLICATION .611 CREATING THE LOGIN.ASPX PAGE .612 CREATING THE REGISTER.ASPX PAGE .615 CREATING THE CONTACT.ASPX PAGE .617 CREATING THE POSTJOB.ASPX PAGE .618 CREATING THE POSTRESUME.ASPX PAGE .620 CREATING THE DISPLAYDATA.ASPX AND RESUMES.ASPX PAGES .623 CREATING THE DNJHEADER.ASPX PAGE .632 RUNNING THE APPLICATION .633 IMPROVING AND MODIFYING THE APPLICATION .635 SUMMARY .636 CONTENTS XVI CHAPTER 18 OBJECT-RELATIONAL MAPPING IN .NET .637 WHY NOT JUST USE A DATASET? .638 UNDERSTANDING OBJECT DATABASES .639 WHY OBJECT RELATIONAL MAPPING? .640 CREATING THE BASIC DESIGN OF THE VIDEO STORE APPLICATION .640 UNDERSTANDING THE BASIC ARCHITECTURE .641 CREATING THE DATABASE DESIGN OF THE VIDEO STORE .641 CREATING THE DATA OBJECT . .643 CREATING THE MAPPED OBJECT .644 CREATING THE DATA ACCESS COMPONENT .648 BUILDING THE VIDEOTAPE TEST CASE .652 USING THE USER COMPONENT .654 CREATING THE USER TEST CASE .659 MANAGING DEPENDENCIES .661 CREATING THE CHECK IN/CHECK OUT COMPONENT .663 SEEING HOW IT WORKS .664 MAKING DESIGN TRADEOFFS .665 UNDERSTANDING LOGIC IN STORED PROCEDURES .665 UNDERSTANDING COMPONENT ISOLATION .666 CREATING A WORKAROUND ON PART OF THE PROBLEM .667 CREATING THE VIDEOCHECKINCHECKOUT TEST CASE .670 SUMMARY .673 CHAPTER 19 MAPPED OBJECTS: PERFORMANCE CONSIDERATIONS AND DATA BINDING .675 USING DATA BINDING AND MAPPED OBJECTS .675 DIRECTLY ACCESSING A BOUND OBJECTS PROPERTIES .678 USING LOGIC WITH BOUND OBJECTS .680 UNDERSTANDING PROBLEMATIC MASTER-DETAIL RELATIONSHIPS .684 WORKING WITH HIGHLY NESTED STRUCTURES .685 WORKING WITH A MUCH LARGER TREE .691 A FINAL NOTE ON TREE OPTIMIZATION .693 WORKING WITH LARGE MASTER-DETAIL RELATIONSHIPS .694 IMPLEMENTING LAZY LOADING .695 IMPLEMENTING AN INCREMENTAL LAZY LOADING SCHEME .700 LOADING THE DETAIL WHEN THE MASTER IS LOADED .705 USING A NEAR-ZERO-IMPACT CACHING MECHANISM .706 SUMMARY .708 CONTENTS XVII CHAPTER 20 COM INTEROPERABILITY AND ADO.NET .709 EXPLORING THE .NET INTEROP TOOLS .710 USING VISUAL STUDIO .NET . .710 USING THE TYPE LIBRARY IMPORTER AND EXPORTER (TLBIMP.EXE) .711 USING THE TYPE LIBRARY EXPORTER (TLBEXP.EXE) .712 USING THE ADO RECORDSET IN ADO.NET .712 USING ADOX WITH ADO.NET .716 ACCESSING OLAP SERVER DATA WITH ADO.NET .718 SUMMARY .724 CHAPTER 21 MESSAGING .725 INTRODUCING TYPES OF QUEUES .725 USING USER QUEUES . .726 USING SYSTEM QUEUES .726 INSTALLING MESSAGE QUEUING .726 USING THE SYSTEM.MESSAGING NAMESPACE .727 WORKING WITH MESSAGE QUEUES .729 USING THE MESSAGEQUEUE PROPERTIES .729 MANAGING QUEUES USING VS .NET .731 RETRIEVING AVAILABLE QUEUES .732 FILTERING QUEUES USING MESSAGEQUEUECRITERIA .734 CREATING AND DELETING MESSAGE QUEUES PROGRAMMATICALLY .735 CREATING A SAMPLE APPLICATION .736 CREATING A MESSAGEQUEUE INSTANCE .738 SETTING A QUEUES PATH .739 SENDING AND RECEIVING MESSAGES .740 WALKING THROUGH SIMPLE MESSAGING APPLICATION .741 WORKING WITH MESSAGES . .745 CREATING AND REMOVING MESSAGES .745 SETTING QUEUE AND MESSAGE PRIORITIES .746 UNDERSTANDING TRANSACTIONAL MESSAGING .747 USING THE MESSAGEQUEUETRANSACTION CLASS .747 CREATING TRANSACTIONAL QUEUES .748 SENDING AND RECEIVING TRANSACTIONAL MESSAGES .748 ENCRYPTING MESSAGES .750 SUMMARY .752 CONTENTS XVIII CHAPTER 22 SQL SERVER AND ADO.NET: NOTES ON PERFORMANCE .753 IMPROVING SQL SERVER PERFORMANCE .753 USING INDEXES . .753 CHOOSING WHICH COLUMNS TO INDEX .757 UNDERSTANDING THE SQL SERVER PROFILER .758 OPTIMIZING AUTOMATICALLY WITH THE SQL SERVER PROFILER .760 OPTIMIZING YOUR TRANSACT-SQL QUERIES FOR PERFORMANCE .762 AVOIDING EXCESSIVE STORED PROCEDURE RECOMPILATION .765 AVOIDING LOCKS .766 DESIGNING YOUR TABLES FOR OPTIMAL PERFORMANCE .766 CHECKING THE SIZE OF DATABASE PAGES .767 UNDERSTANDING DENORMALIZATION .768 UNDERSTANDING THE DANGERS OF DATABASE DESIGN SLIPPAGE .768 UNDERSTANDING ADO.NET PERFORMANCE ISSUES AND USING BEST PRACTICES .769 SELECTING DATA PROVIDERS . .769 WRITING A GENERIC DATA ACCESS COMPONENT .770 CHOOSING A DEVELOPMENT MODE: DESIGNER VS. MANUAL .775 RETRIEVING DATA: DATAREADER, XMLREADER, AND DATASET .775 UPDATING A DATA SOURCE: COMMAND VS. DATASET .776 SAVING DATA AND USING GETCHANGES .777 RETRIEVING DATA WITH THE SELECT STATEMENT .777 USING STORED PROCEDURES .777 USING CONNECTION STRINGS AND POOLING .777 SUMMARY .778 APPENDIX A RELATIONAL DATABASES: SOME BASIC CONCEPTS .779 UNDERSTANDING NORMALIZATION .780 FIRST NORMAL FORM (1NF) . .780 SECOND NORMAL FORM (2NF) .782 THIRD NORMAL FORM (3NF) .7 84 BOYCE-CODD NORMAL FORM (BCNF) .785 FOURTH NORMAL FORM (4NF) .785 FIFTH NORMAL FORM (5NF OR PJ/NF) .786 INTRODUCING SETS, CURSORS, AND ADO.NET .786 CONTENTS XIX USING LOCKING .788 ISOLATION LEVELS . .788 LOCKING MODES .790 SUMMARY .792 APPENDIX B COMMONLY USED SQL STATEMENTS .793 UNDERSTANDING SQL REFERENCES .793 USING THE SELECT STATEMENT .796 USING THE UPDATE STATEMENT .802 USING THE DELETE STATEMENT .802 USING THE CREATE TABLE STATEMENT .803 USING THE DROP TABLE STATEMENT .803 USING THE TRUNCATE TABLE STATEMENT .804 USING THE INSERT STATEMENT .805 USING JOINS AND ALIASES . .806 UNDERSTANDING VIEWS .807 USING SQL SERVER*S SELECT.FOR XML CLAUSE .809 SUMMARY .810 APPENDIX C ADO.NET FREQUENTLY ASKED QUESTIONS .811 SUMMARY .845 INDEX .847 CONTENTS XX
any_adam_object	1
any_adam_object_boolean	1
author	Chand, Mahesh Talbot, David
author_facet	Chand, Mahesh Talbot, David
author_role	aut aut
author_sort	Chand, Mahesh
author_variant	m c mc d t dt
building	Verbundindex
bvnumber	BV023528495
classification_rvk	ST 250
ctrlnum	(OCoLC)249481670 (DE-599)BVBBV023528495
dewey-full	005.117
dewey-hundreds	000 - Computer science, information, general works
dewey-ones	005 - Computer programming, programs, data, security
dewey-raw	005.117
dewey-search	005.117
dewey-sort	15.117
dewey-tens	000 - Computer science, information, general works
discipline	Informatik
discipline_str_mv	Informatik
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01104nam a2200313zc 4500</leader><controlfield tag="001">BV023528495</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20091214 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">030522s2003 xxud\|\|\| \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1590590732</subfield><subfield code="9">1-59059-073-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)249481670</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV023528495</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">XD-US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-521</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.117</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 250</subfield><subfield code="0">(DE-625)143626:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Chand, Mahesh</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Applied ADO.NET</subfield><subfield code="b">building data-driven solutions</subfield><subfield code="c">Mahesh Chand and David Talbot</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[S.l.]</subfield><subfield code="b">Apress</subfield><subfield code="c">2003</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXXIV, 887 S.</subfield><subfield code="b">graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Talbot, David</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">SWB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016848697&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016848697</subfield></datafield></record></collection>
id	DE-604.BV023528495
illustrated	Illustrated
index_date	2024-07-02T22:34:30Z
indexdate	2024-07-09T21:23:58Z
institution	BVB
isbn	1590590732
language	English
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-016848697
oclc_num	249481670
open_access_boolean
owner	DE-521
owner_facet	DE-521
physical	XXXIV, 887 S. graph. Darst.
publishDate	2003
publishDateSearch	2003
publishDateSort	2003
publisher	Apress
record_format	marc
spelling	Chand, Mahesh Verfasser aut Applied ADO.NET building data-driven solutions Mahesh Chand and David Talbot [S.l.] Apress 2003 XXXIV, 887 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Talbot, David Verfasser aut SWB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016848697&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis
spellingShingle	Chand, Mahesh Talbot, David Applied ADO.NET building data-driven solutions
title	Applied ADO.NET building data-driven solutions
title_auth	Applied ADO.NET building data-driven solutions
title_exact_search	Applied ADO.NET building data-driven solutions
title_exact_search_txtP	Applied ADO.NET building data-driven solutions
title_full	Applied ADO.NET building data-driven solutions Mahesh Chand and David Talbot
title_fullStr	Applied ADO.NET building data-driven solutions Mahesh Chand and David Talbot
title_full_unstemmed	Applied ADO.NET building data-driven solutions Mahesh Chand and David Talbot
title_short	Applied ADO.NET
title_sort	applied ado net building data driven solutions
title_sub	building data-driven solutions
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016848697&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT chandmahesh appliedadonetbuildingdatadrivensolutions AT talbotdavid appliedadonetbuildingdatadrivensolutions

Verfügbarkeit

Es ist kein Print-Exemplar vorhanden.

Fernleihe Bestellen Achtung: Nicht im THWS-Bestand! Inhaltsverzeichnis

MARC

Datensatz im Suchindex

Es ist kein Print-Exemplar vorhanden.

Ähnliche Einträge