Holdings: ADO.NET examples and best practices for C# programmers

ADO.NET examples and best practices for C# programmers:

Saved in:

Bibliographic Details
Main Author:	Vaughn, William R. (Author)
Format:	Book
Language:	English
Published:	New York Beta V Corp. 2002
Subjects:	C sharp ADO.NET
Online Access:	Inhaltsverzeichnis
Physical Description:	XXII, 358 S. Ill. 1 CD-ROM (12 cm)
ISBN:	1590590120

Staff View

MARC


LEADER	00000nam a2200000 c 4500
001	BV017906192
003	DE-604
005	20040308
007	t
008	040308s2002 a\|\|\| \|\|\|\| 00\|\|\| eng d
020			\|a 1590590120 \|9 1-59059-012-0
035			\|a (OCoLC)634110692
035			\|a (DE-599)BVBBV017906192
040			\|a DE-604 \|b ger \|e rakwb
041	0		\|a eng
049			\|a DE-91G
084			\|a ST 253 \|0 (DE-625)143628: \|2 rvk
084			\|a ST 271 \|0 (DE-625)143639: \|2 rvk
100	1		\|a Vaughn, William R. \|e Verfasser \|4 aut
245	1	0	\|a ADO.NET examples and best practices for C# programmers \|c William R. Vaughn with Peter Blackburn
264		1	\|a New York \|b Beta V Corp. \|c 2002
300			\|a XXII, 358 S. \|b Ill. \|e 1 CD-ROM (12 cm)
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
650	0	7	\|a C sharp \|0 (DE-588)4616843-6 \|2 gnd \|9 rswk-swf
650	0	7	\|a ADO.NET \|0 (DE-588)4678430-5 \|2 gnd \|9 rswk-swf
689	0	0	\|a ADO.NET \|0 (DE-588)4678430-5 \|D s
689	0	1	\|a C sharp \|0 (DE-588)4616843-6 \|D s
689	0		\|5 DE-604
700	1		\|a Blackburn, Peter \|e Sonstige \|4 oth
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=010740825&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
999			\|a oai:aleph.bib-bvb.de:BVB01-010740825

Record in the Search Index

_version_	1804130570264903680
adam_text	CONTENTS ACKNOWLEDGMENTS .................................................................................................XIII ABOUT THE AUTHORS .............................................................................. ................XV INTRODUCTION ........................................................................................................XIX CHAPTER 1 INTRODUCING ADO.NET .......................................................1 HOW WE GOT HERE .............................................................................. ......................2 WHAT DO THESE CHANGES MEAN? ........................................................................5 ADO.NETA NEW BEGINNING .............................................................................. ....7 COMPARING ADOC AND ADO.NET ......................................................................8 UNDERSTANDING ADO.NET INFRASTRUCTURE ......................................................9 UNDERSTANDING ADO.NETS DISTRIBUTED ARCHITECTURE ....................................10 A BRIEF LOOK AT XML .............................................................................. ............11 ADO.NETTHE FUNDAMENTALS .......................................................................12 ADO.NET .NET DATA PROVIDERS ........................................................................15 LEVERAGING EXISTING COM-BASED ADO CODE ..................................................17 CREATING DATASETS FROM ADOC RECORDSET OBJECTS .........................................19 HOW COM INTEROP AFFECTS .NET APPLICATIONS ................................................19 ADO.NET AND DISCONNECTED DATA STRUCTURES ...........................................20 THE SYSTEM.DATA NAMESPACE ............................................................................21 THE ADO.NET DATASET OBJECT .........................................................................22 DESCENDING THE SYSTEM.DATA NAMESPACE TREE .............................................26 INSTANTIATING SYSTEM.DATA OBJECTS .................................................................30 INTRODUCING THE ADO.NET DATAADAPTER .........................................................31 ADO.NETS LOW-LEVEL DATA STREAM ...............................................................36 VII CHAPTER 2 ADO.NETGETTING CONNECTED ......................................39 ADO.NET .NET DATA PROVIDERS ........................................................................40 CHOOSING THE RIGHT PROVIDER ............................................................................41 CREATING ADO.NET CONNECTION OBJECTS ......................................................42 USING CONSTRUCTORS IN DECLARATIONS ................................................................43 BUILDING AN ADO.NET CONNECTIONSTRING .......................................................44 CONNECTING VIA THE SQLCLIENT .NET DATA PROVIDER ............................51 INTRODUCING SYSTEM.DATA.SQLCLIENT ...............................................................51 EXAMINING THE CONNECTION OBJECT PROPERTIES ...............................................53 EXAMINING CONNECTION OBJECT METHODS ........................................................55 SINKING CONNECTION OBJECT EVENTS .................................................................56 MANAGING TRANSACTIONS .............................................................................. .......59 CONNECTING WITH THE ODBC .NET DATA PROVIDER .....................................59 USING THE ODBC .NET DATA PROVIDER ...............................................................60 MANAGING THE ODBC.CONNECTION OBJECT .........................................................61 ODBC CONNECTION STRINGS .............................................................................. .64 OPENING ADO.NET CONNECTIONS IN CODE ......................................................65 USING THE IDE TO GET CONNECTED .................................................................66 ADDING CONNECTIONS .............................................................................. ...........66 CLOSING CONNECTIONS .............................................................................. ...........68 MANAGING THE ADO.NET GARBAGE COLLECTOR ...................................................68 CONNECTION INFORMATION AND SECURITY ...........................................................69 ADO.NET CONNECTION POOLING ........................................................................71 OLEDB AND ODBC CONNECTION POOLING ............................................................75 DEBUGGING THE CONNECTION POOL .....................................................................75 COM-BASED ADO AS A .NET DATA PROVIDER ..................................................75 INSTANTIATING YOUR ADOC NAMESPACE .............................................................76 CHAPTER 3 ADO.NET COMMAND STRATEGIES ...................................79 UNDERSTANDING ADO.NET COMMANDS .................................................................79 INTRODUCING ADO.NET PARAMETER QUERIES .....................................................82 EXECUTING AD HOC QUERIES USING ADO.NET ...................................................84 CONSTRUCTING SQL FOR YOUR QUERY ...................................................................85 CREATING A DATASET WITH THE IDE ......................................................................98 USING DRAG-AND-DROP WITH THE IDE ..............................................................102 MANAGING PARAMETER QUERIES ........................................................................111 MANAGING MULTIPLE-TABLE QUERIES ................................................................116 MANAGING STORED PROCEDURE QUERIES ............................................................121 MANAGING MULTIPLE-RESULTSET QUERIES ..........................................................129 EXPLORING THE COMMAND EXECUTE METHODS .................................................133 BINDING TO RESULTSET COLUMNS ...................................................................136 CONTENTS VIII CHAPTER 4ADO.NET DATAREADER STRATEGIES .........................141 COMPARING ADOC WITH ADO.NET ......................................................................142 UNDERSTANDING THE DATAREADER ...................................................................144 USING THE DATAREADER GET METHODS TO RETRIEVE DATA .....................151 USING GETVALUES TO FETCH A ROW ....................................................................154 CLEANING UP AFTER YOUR DATAREADER ........................................................155 CHAPTER 5 USING THE DATATABLE AND DATASET ....................157 UNDERSTANDING THE DATASET AND DATATABLE STRUCTURE .....................159 TYPED VERSUS UNTYPED DATASETS ....................................................................161 IMPORTING ADOC RECORDSETS ..........................................................................168 COMPARING ADOC RECORDSETS AND DATATABLE OBJECTS ................................169 BUILDING DATATABLES .............................................................................. .........172 BUILDING DATATABLES WITH THE CONSTRUCTOR ...................................................173 BUILDING DATATABLES USING THE DATAADAPTER FILL METHOD ...........................173 BUILDING DATATABLE OBJECTS WITHIN A DATASET ..............................................177 USING FILLSCHEMA TO RETRIEVE DDL ................................................................180 ACCESSING DATATABLE DATA ............................................................................18 1 ACCESSING THE DATACOLUMNCOLLECTION (COLUMNS) .......................................182 UNDERSTANDING THE DATAROW OBJECT .............................................................187 ACCESSING THE DATAROWCOLLECTION (ROWS) ....................................................187 TESTING FOR RESULTS .............................................................................. ............191 ACCESSING DATASET DATA .............................................................................. ..194 POSITIONING THE CURRENT ROW POINTER ............................................................195 BINDING TO DATASETS .............................................................................. .........196 CHAPTER 6 FILTERING, SORTING, AND FINDING ....................197 FILTERING AND SORTING WITH THE SELECT METHOD ...............................198 SORTING WITH THE SELECT METHOD .....................................................................199 FILTERING ON ROWSTATE AND VERSION ................................................................205 FILTERING AND SORTING WITH THE DATAVIEW OBJECT ............................205 SETTING DATAVIEW FILTER PROPERTIES ................................................................206 CREATING DATAVIEW OBJECTS WITH VISUAL STUDIO ............................................210 UPDATING A DATAVIEW .............................................................................. .......210 WORKING WITH THE DATAVIEWMANAGER ...........................................................211 THE DEFAULTVIEWMANAGER PROPERTY ..............................................................212 USING THE FIND METHODS .............................................................................. ..212 THE ROWS COLLECTION FIND METHOD ................................................................213 THE DATAVIEW OBJECTS FIND METHOD ............................................................216 THE ROWS COLLECTION CONTAINS METHOD ........................................................219 CONTENTS IX CHAPTER 7 ADO.NET UPDATE STRATEGIES ....................................221 CHANGING DATATHE FUNDAMENTALS ...............................................................223 ADDRESSING THE VALUE PROPERTY WITH UNTYPED DATASETS ...............................223 ADDRESSING THE VALUE PROPERTY WITH TYPED DATASETS ...................................224 CREATING NEW DATAROWS .............................................................................. ..224 DELETING DATASET ROWS .............................................................................. .....226 UNDOING* A DELETE OPERATION ......................................................................227 POSTPONING CONSTRAINT ENFORCEMENT ............................................................228 USING BEGINEDIT .............................................................................. ................228 DATA VALIDATION .............................................................................. .................229 CHECKING ROWSTATE .............................................................................. ..........233 UPDATE STRATEGIES .............................................................................. .............238 CREATING UPDATABLE DATASETS ........................................................................239 USING THE COMMANDBUILDER CLASS ................................................................240 USING VISUAL STUDIO TO GENERATE ACTION QUERIES ............................251 REVIEWING THE GENERATED STORED PROCEDURES ..............................................251 REVIEWING THE GENERATED CODE .....................................................................254 RETRIEVING AUTONUMBER, IDENTITY, OR GUIDS ......................................258 UNDERSTANDING THE UPDATE METHODS ...........................................................262 UPDATE PERFORMANCE .............................................................................. ...........264 ANOTHER APPROACH TO BULK INSERTS: USE XML ...............................................265 UPDATING THE AUTHORS TABLE*AN EXAMPLE ................................................266 WORKING WITH AN UPDATABLE DATAGRID CONTROL ............................................268 SHOWING THE AVAILABLE DATA VERSIONS ............................................................268 SHOWING THE ROW COUNTS .............................................................................. .270 USING GETCHANGES TO MANAGE MODIFIED ROWS .............................................272 UPDATE EXCEPTION HANDLING STRATEGIES ..................................................273 USING THE CONTINUEAFTERERROR PROPERTY ........................................................274 WHAT TO DO WHEN AN UPDATE FAILS ................................................................276 HANDLING UPDATE METHOD EXCEPTIONS ........................................................277 CODING THE UPDATE DBCONCURRENCYEXCEPTION TRAP ...................................279 EXECUTING AD HOC QUERIES TO PERFORM UPDATES ...................................280 MERGING AND TRANSPORTING DATA .................................................................281 CHAPTER 8 ADO.NET CONSTRAINT STRATEGIES .........................283 UNDERSTANDING .NET CONSTRAINTS ...............................................................283 HOW ADO.NET IMPLEMENTS CONSTRAINTS ......................................................285 MANAGING THE CONSTRAINTS COLLECTION ...........................................................286 IMPLEMENTING UNIQUE CONSTRAINTS ...............................................................287 IMPLEMENTING FOREIGN KEY CONSTRAINTS .......................................................289 UNDERSTANDING PARENT/CHILD PRIMARY KEY/FOREIGN KEY RELATIONSHIPS .....292 USING THE FILLSCHEMA METHOD .......................................................................294 CREATING DATARELATION OBJECTS .................................................................295 CONTENTS X CHAPTER 9 ADO.NET EXCEPTION MANAGEMENT STRATEGIES ..301 STRUCTURED EXCEPTION HANDLING .................................................................302 UNDERSTANDING TRY/CATCH .............................................................................. 303 TRY/CATCH SYNTAX .............................................................................. ...............303 STANDARD EXCEPTIONS .............................................................................. ........303 VARIABLE SCOPE IN TRY/CATCH BLOCKS ...............................................................305 EXCEPTIONS THAT FIRE OUTSIDE OF TRY/CATCH SCOPE ........................................305 NESTING EXCEPTION HANDLERS ..........................................................................305 TRAPPING SPECIFIC VS. GENERAL EXCEPTIONS .........................................306 THE SYSTEM.DATA EXCEPTIONS ........................................................................306 THE SQLEXCEPTION CLASS ..................................................................................308 THE SQLERROR CLASS .............................................................................. ............310 THE OLEDBEXCEPTION CLASS ............................................................................31 0 DISPLAYING THE ERROR MESSAGE ...................................................................311 CHAPTER 10 ADO.NET AND XML ..............................................................313 XML SUPPORT IN ADO.NET .............................................................................. ..314 STANDARDIZING ON XML FORMATS ...................................................................315 UNDERSTANDING XML AND DATASET OBJECTS ................................................316 IMPORTING DATASET DATA FROM AN XML DOCUMENT ......................................316 WHAT ARE DIFFGRAMS? .............................................................................. ........319 MERGING XML DATA WITH YOUR DATASET .........................................................321 FETCHING AND SAVING DATASET OBJECTS AS XML ..............................................321 LOADING SCHEMA FROM XML ...........................................................................324 PERSISTING XML SCHEMA .............................................................................. ...325 CREATING A WEB SERVICE AS AN XML DATA SOURCE ................................326 PASSING AN UPDATED DATASET BACK TO A WEB SERVICE ........................336 CREATING CUSTOM EXCEPTION HANDLERS ......................................................341 ADO.NET AND SOAP .............................................................................. ................342 APPENDIX WORKING WITH THE BIBLIO SAMPLE DATABASE ...........................................343 INDEX .............................................................................. ......................................345 CONTENTS XI
any_adam_object	1
author	Vaughn, William R.
author_facet	Vaughn, William R.
author_role	aut
author_sort	Vaughn, William R.
author_variant	w r v wr wrv
building	Verbundindex
bvnumber	BV017906192
classification_rvk	ST 253 ST 271
ctrlnum	(OCoLC)634110692 (DE-599)BVBBV017906192
discipline	Informatik
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01375nam a2200361 c 4500</leader><controlfield tag="001">BV017906192</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20040308 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">040308s2002 a\|\|\| \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1590590120</subfield><subfield code="9">1-59059-012-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)634110692</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV017906192</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91G</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 253</subfield><subfield code="0">(DE-625)143628:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Vaughn, William R.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">ADO.NET examples and best practices for C# programmers</subfield><subfield code="c">William R. Vaughn with Peter Blackburn</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York</subfield><subfield code="b">Beta V Corp.</subfield><subfield code="c">2002</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXII, 358 S.</subfield><subfield code="b">Ill.</subfield><subfield code="e">1 CD-ROM (12 cm)</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="650" ind1="0" ind2="7"><subfield code="a">C sharp</subfield><subfield code="0">(DE-588)4616843-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ADO.NET</subfield><subfield code="0">(DE-588)4678430-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ADO.NET</subfield><subfield code="0">(DE-588)4678430-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">C sharp</subfield><subfield code="0">(DE-588)4616843-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Blackburn, Peter</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</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=010740825&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-010740825</subfield></datafield></record></collection>
id	DE-604.BV017906192
illustrated	Illustrated
indexdate	2024-07-09T19:23:08Z
institution	BVB
isbn	1590590120
language	English
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-010740825
oclc_num	634110692
open_access_boolean
owner	DE-91G DE-BY-TUM
owner_facet	DE-91G DE-BY-TUM
physical	XXII, 358 S. Ill. 1 CD-ROM (12 cm)
publishDate	2002
publishDateSearch	2002
publishDateSort	2002
publisher	Beta V Corp.
record_format	marc
spelling	Vaughn, William R. Verfasser aut ADO.NET examples and best practices for C# programmers William R. Vaughn with Peter Blackburn New York Beta V Corp. 2002 XXII, 358 S. Ill. 1 CD-ROM (12 cm) txt rdacontent n rdamedia nc rdacarrier C sharp (DE-588)4616843-6 gnd rswk-swf ADO.NET (DE-588)4678430-5 gnd rswk-swf ADO.NET (DE-588)4678430-5 s C sharp (DE-588)4616843-6 s DE-604 Blackburn, Peter Sonstige oth SWB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010740825&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis
spellingShingle	Vaughn, William R. ADO.NET examples and best practices for C# programmers C sharp (DE-588)4616843-6 gnd ADO.NET (DE-588)4678430-5 gnd
subject_GND	(DE-588)4616843-6 (DE-588)4678430-5
title	ADO.NET examples and best practices for C# programmers
title_auth	ADO.NET examples and best practices for C# programmers
title_exact_search	ADO.NET examples and best practices for C# programmers
title_full	ADO.NET examples and best practices for C# programmers William R. Vaughn with Peter Blackburn
title_fullStr	ADO.NET examples and best practices for C# programmers William R. Vaughn with Peter Blackburn
title_full_unstemmed	ADO.NET examples and best practices for C# programmers William R. Vaughn with Peter Blackburn
title_short	ADO.NET examples and best practices for C# programmers
title_sort	ado net examples and best practices for c programmers
topic	C sharp (DE-588)4616843-6 gnd ADO.NET (DE-588)4678430-5 gnd
topic_facet	C sharp ADO.NET
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010740825&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT vaughnwilliamr adonetexamplesandbestpracticesforcprogrammers AT blackburnpeter adonetexamplesandbestpracticesforcprogrammers

Holdings

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Indexes

MARC

Record in the Search Index

There is no print copy available.

Similar Items