دانلود کتاب Sams teach yourself ADO.NET in 24 hours

عنوان فارسی :

دانلود کتاب سامس در 24 ساعت خود ADO.NET را آموزش می دهد

عنوان انگلیسی :

Sams teach yourself ADO.NET in 24 hours

زبان : English

موضوع : Computers->Programming: Programming Languages

نویسندگان : Jason Lefebvre Paul Bertucci

ناشر : Sams Publishing

ISBN (شابک) : 0672323834, 9780672323836

تعداد صفحات : 408\408

سال نشر : 2002     ویرایش : 3

حجم : 5 MB       فرمت : pdf

قیمت : 4000 تومان

فهرست :



Table of contents :
Sams Teach Yourself ADO.NET in 24 Hours......Page 2
Copyright © 2002 by Sams Publishing......Page 3
Contents at a Glance......Page 4
Contents......Page 6
About the Authors......Page 16
Tell Us What You Think!......Page 18
Introduction......Page 20
Conventions Used in This Book......Page 21
HOUR 1 Introducing the Microsoft .NET Framework and ADO.NET......Page 22
The Microsoft .NET Framework Class Library......Page 23
What Is ADO.NET?......Page 24
ADO.NET Versus ADO......Page 26
The System.Data Namespace......Page 27
The System.Data.SqlClient and System.Data.OleDb Namespaces......Page 29
Workshop......Page 30
HOUR 2 Working with DataSets and DataTables......Page 32
DataSet Overview......Page 33
Creating DataSet Schema......Page 34
Adding and Removing Data......Page 36
Summary......Page 44
Workshop......Page 45
HOUR 3 Using T-SQL: A Crash Course......Page 46
Retrieving Data with SELECT......Page 47
Adding New Data with INSERT......Page 50
Modifying Data with UPDATE and DELETE......Page 51
Using the Built-in SQL Functions......Page 53
Workshop......Page 56
HOUR 4 Adding Relationships to DataSets......Page 58
Database Relationships and Constraints......Page 59
The DataRelation Object......Page 64
The DataSet Relations Collection......Page 65
Workshop......Page 72
HOUR 5 Connecting to a Data Source......Page 74
The Connection Object......Page 75
Connecting to Various Data Sources......Page 77
ODBC (Open Database Connectivity)......Page 80
Connection Pooling......Page 81
Workshop......Page 82
The Command Object......Page 84
Filling a DataSet with the DataAdapter......Page 87
Retrieving a Single Value from the Database......Page 91
Q&A......Page 93
Workshop......Page 94
HOUR 7 Modifying Database Data......Page 96
Using ExecuteNonQuery()......Page 97
Summary......Page 108
Workshop......Page 109
DataReader Versus DataAdapter......Page 110
Instantiating the DataReader......Page 112
Binding DataReader Results to a Web Control......Page 113
Stepping Through Data with the DataReader......Page 115
Limitations of the DataReader......Page 119
Workshop......Page 120
HOUR 9 Binding Data to List Controls......Page 122
Binding Data to Controls......Page 123
Simple Data Binding in Windows Forms......Page 125
Complex Data Binding in Windows Forms......Page 130
Q&A......Page 138
Workshop......Page 139
What Is XML?......Page 142
Creating a DataSet from an XML File......Page 143
Serializing DataSets to XML......Page 146
Using XmlReader......Page 148
Summary......Page 150
Workshop......Page 151
HOUR 11 Using the Built-In ASP.NET List Controls......Page 152
Some General Notes About List Controls......Page 153
Working with the Repeater......Page 154
Working with the DataGrid......Page 157
Working with the DataList......Page 165
Summary......Page 168
Workshop......Page 169
A Quick Overview of CSS......Page 170
Formatting the Repeater......Page 175
Formatting the DataList......Page 177
Formatting the DataGrid......Page 181
Q&A......Page 184
Workshop......Page 185
HOUR 13 Handling ADO.NET Errors......Page 186
Using Formal Error Handling (Ready, “Catch”!)......Page 187
Typical Errors to Handle......Page 192
Using RowError of the DataSet......Page 197
Q&A......Page 200
Workshop......Page 201
HOUR 14 Managing ADO.NET Concurrency......Page 202
Optimistic Versus Pessimistic Concurrency......Page 203
Coding for Optimistic Concurrency......Page 206
Comparing DataSet Values Against the Database for Optimistic Concurrency......Page 207
Using a Timestamp for Optimistic Concurrency......Page 211
XML and Optimistic Concurrency......Page 213
Summary......Page 214
Workshop......Page 215
HOUR 15 Working with Stored Procedures......Page 218
What Are Stored Procedures?......Page 219
Executing a Stored Procedure......Page 223
Using Parameters......Page 225
Workshop......Page 231
HOUR 16 ADO Upgrade Concerns......Page 234
General Upgrade Issues from ADO to ADO.NET......Page 235
Accessing an ADO Recordset from ADO.NET......Page 237
Workshop......Page 245
HOUR 17 Using Connection Pooling......Page 246
What Is Connection Pooling?......Page 247
OLE DB .NET Data Provider......Page 250
Q&A......Page 255
Workshop......Page 256
HOUR 18 Working with Transactions......Page 258
Transactions and ADO.NET......Page 259
Transactions with Stored Procedures......Page 269
Summary......Page 271
Workshop......Page 272
HOUR 19 Using Automatically Generated Commands......Page 274
Automatically Generated Commands......Page 275
Using the CommandBuilder......Page 276
Q&A......Page 282
Workshop......Page 283
HOUR 20 Working with Typed DataSets......Page 286
The Typed DataSet......Page 287
Generating a Typed DataSet......Page 288
Typed DataSets in Visual Studio .NET......Page 296
Summary......Page 302
Workshop......Page 303
HOUR 21 Optimizing Data Access Using Tiered Development......Page 306
What Is Tiered Development?......Page 307
Creating Your Own Assembly......Page 309
Summary......Page 320
Workshop......Page 321
Updating Product Data......Page 322
Adding Product Data......Page 330
Workshop......Page 335
Optimizing ADO.NET Code......Page 338
ASP.NET Tracing......Page 340
Improving Your Queries with the SQL Query Analyzer......Page 343
Data Caching......Page 347
Workshop......Page 349
HOUR 24 Transmitting DataSets Using Web Services......Page 350
Sending a DataSet Using Web Services......Page 351
Consuming a DataSet from a Web Service......Page 355
Q&A......Page 359
Workshop......Page 360
Hour 2......Page 362
Hour 6......Page 363
Hour 9......Page 364
Hour 12......Page 365
Hour 14......Page 366
Hour 17......Page 367
Hour 20......Page 368
Hour 23......Page 369
Hour 24......Page 370
INDEX......Page 372




کتاب های پزشکی

دانلود کتاب Obstetric and Gynecologic Dermatology, Third Edition

دانلود کتاب Dynamic Joga

دانلود کتاب Angry White Pyjamas

دانلود کتاب Basic clinical neuroscience

دانلود کتاب Röntgenanatomie. Radiological Anatomy. Anatomie Radiologique: Prufungsfragen Fur Die Facharztprufung / Multiple Choice Questions /Qcm

کتاب های کامپیوتر

دانلود کتاب Problem Solving with C++, 7th Edition

دانلود کتاب Practical C programming

دانلود کتاب Creative Visualization For Dummies (For Dummies (Psychology & Self Help))

دانلود کتاب Real-Time Concepts for Embedded Systems

دانلود کتاب C++ Coding Standards: 101 Rules, Guidelines, and Best Practices

کتاب های ریاضی

دانلود کتاب Diffusions, Markov Processes, and Martingales: Volume 1, Foundations

دانلود کتاب Probability, Statistics, and Random Processes For Electrical Engineering, 3rd Edition

دانلود کتاب Confound & Destroy: 100 Group and the Bomber Support Campaign

دانلود کتاب Beyond ANOVA: Basics of Applied Statistics (Wiley Series in Probability and Statistics)

دانلود کتاب Digital Signal Processing using MATLAB and Wavelets

کتاب های تکنولوژی

دانلود کتاب Protein Folding Protocols

دانلود کتاب Nanoscale Multifunctional Materials: Science & Applications

دانلود کتاب Protein-Protein Interactions: A Molecular Cloning Manual, Second Edition

دانلود کتاب Protein Phosphatase Protocols

دانلود کتاب Advanced Topics in Materials Science and Engineering

کتاب های مذهبی

دانلود کتاب Religion and Society in Roman Palestine: Old Questions, New Approaches

دانلود کتاب Old Testament Theology: 1 (Old Testament Library)

دانلود کتاب Living Together and Christian Ethics (New Studies in Christian Ethics)

دانلود کتاب Religions of the World: A Comprehensive Encyclopedia of Beliefs and Practices

دانلود کتاب Three Views on the Rapture: Pre; Mid; Or Post-Tribulation (Counterpoints)

کتاب های فیزیولوژی

دانلود کتاب The concept of being in Hegel and Heidegger (Abhandlungen zur Philosophie, Psychologie, und Padagogik ; Bd. 116)

دانلود کتاب Simulation and Gaming for Mathematical Education: Epistemology and Teaching Strategies

دانلود کتاب Introduction to Psychology , Eighth Edition

دانلود کتاب The Ultimate Teaching Manual: A Route to Success for Beginning Teachers

دانلود کتاب How We Know What Isn't So: The Fallibility of Human Reason in Everyday Life

کتاب های تاریخی

دانلود کتاب Infidels: A history of the Conflict between Christendom and Islam

دانلود کتاب Russian America: An Overseas Colony of a Continental Empire, 1804-1867

دانلود کتاب US Army Infantry Divisions 1944-45

دانلود کتاب The Second World War, Volume 2: Their Finest Hour

دانلود کتاب Ancient Greece (Grades 4-8)

کتاب های زیست شناسی

دانلود کتاب Advances in Environmental Research, Volume 13

دانلود کتاب Evolution

دانلود کتاب Biological Petri Nets - Volume 162 Studies in Health Technology and Informatics

دانلود کتاب God's Healing Leaves

دانلود کتاب Monsters and Animals

کتاب های اقتصاد

دانلود کتاب Advanced Accounting, 11th Edition

دانلود کتاب Inside Marketing: Practices, Ideologies, Devices

دانلود کتاب Architectural Management

دانلود کتاب

دانلود کتاب Merlin PR Spitfires

کتاب های آموزشی

دانلود کتاب Sams Teach Yourself Adobe Photoshop CS3 in 24 Hours

دانلود کتاب Smiley's Workshop for AVR

دانلود کتاب Ester Formation and Hydrolysis and Related Reactions

دانلود کتاب Warhammer Army Book - (Games Workshop) - High Elves

دانلود کتاب New Retail

کتاب های حقوق

دانلود کتاب Encyclopedia of War Crimes And Genocide (Facts on File Library of World History)

دانلود کتاب Lawrence and the Arab Revolts

دانلود کتاب White Collar Crime: An Opportunity Perspective

دانلود کتاب Analysis of evidence

دانلود کتاب Environmental liability and ecological damage in European law

کتاب های علوم انسانی

دانلود کتاب The Cambridge Companion to Modern Chinese Culture

دانلود کتاب Art And Social Change: Contemporary Art In Asia And The Pacific

دانلود کتاب In His Own Write

دانلود کتاب Inside Out Advanced: Workbook with Key

دانلود کتاب A Concise Introduction to Logic (Ninth Edition)