Atjaunināt sīkdatņu piekrišanu

E-grāmata: Beginning VB 2005 Databases: From Novice to Professional

2.00/5 (4 ratings by Goodreads)
, , , , ,
  • Formāts: PDF+DRM
  • Izdošanas datums: 02-May-2007
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781430203957
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 36,87 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
Beginning VB 2005 Databases: From Novice to ProfessionalPalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 02-May-2007
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781430203957
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Beginning Visual Basic 2005 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.



In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in VB 2005 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 2.0 and offers you the best contemporary practice in this core programming area, so that youll find yourself using it in nearly all your .NET projects.
About the Authors xix
About the Technical Reviewer xxi
Acknowledgments xxiii
Introduction xxv
Getting Our Tools
1(16)
Installing VBE and SSE
2(5)
Installing SSMSE
7(2)
Installing the SQL Server Documentation
9(1)
Installing a Sample Database
10(5)
Installing the Northwind Creation Script
10(2)
Creating the Northwind Sample Database
12(2)
Uninstalling the Northwind Creation Script
14(1)
Summary
15(2)
Getting to Know Our Tools
17(28)
Using SSMSE
17(12)
Configuring VBE
29(9)
Using BOL
38(4)
Summary
42(3)
Introducing SQL
45(22)
What Is SQL?
45(1)
Retrieving Data
46(11)
Using the Where Clause
50(4)
Sorting Data
54(3)
Inserting Data
57(2)
Updating Data
59(2)
Deleting Data
61(1)
T-SQL Data Types
62(2)
Numeric Data Types
63(1)
Money Data Types
63(1)
Character String Data Types
63(1)
Date and Time Data Types
64(1)
Binary Data Types
64(1)
Other Data Types
65(1)
Data Type Precedence
65(1)
Summary
66(1)
Introducing ADO.NET
67(30)
Why ADO.NET?
67(3)
From ADO to ADO.NET
67(1)
ADO.NET Isn't a New Version of ADO
68(1)
ADO.NET and the .NET Base Class Library
69(1)
Understanding ADO.NET Architecture
70(24)
Using the SQL Server Data Provider
73(7)
Using the OLE DB Data Provider
80(4)
Using the ODBC Data Provider
84(10)
Data Providers Are APIs
94(1)
Summary
95(2)
Introducing Connections
97(20)
Introducing the Data Provider Connection Classes
97(1)
Connecting to SSE with SqlConnection
98(9)
Try It Out: Using SqlConnection
98(2)
How It Works
100(3)
Debugging Connections to SQL Server
103(1)
Security and Passwords in SqlConnection
104(1)
How to Use SQL Server Security
105(1)
Connection String Parameters for SqlConnection
105(2)
Connection Pooling
107(1)
Improving Your Use of Connection Objects
107(5)
Using the Connection String in the Connection Constructor
107(1)
Displaying Connection Information
107(1)
Try It Out: Displaying Connection Information
108(1)
How It Works
109(3)
Connecting to SSE with OleDbConnection
112(3)
Try It Out: Connecting to SSE with the OLE DB Data Provider
113(1)
How It Works
114(1)
Summary
115(2)
Introducing Commands
117(24)
Creating a Command
118(5)
Try It Out: Creating a Command with a Constructor
118(1)
How It Works
119(1)
Associating a Command with a Connection
119(2)
Assigning Text to a Command
121(2)
Executing Commands
123(3)
Try It Out: Using the ExecuteScalar Method
123(2)
How It Works
125(1)
Executing Commands with Multiple Results
126(3)
Try It Out: Using the ExecuteReader Method
126(2)
How It Works
128(1)
Executing Statements
129(4)
Try It Out: Using the ExecuteNonQuery Method
129(2)
How It Works
131(2)
Command Parameters
133(5)
Try It Out: Using Command Parameters
134(3)
How It Works
137(1)
The Prepare Method
138(1)
Summary
139(2)
Introducing Data Readers
141(28)
Understanding Data Readers in General
141(14)
Try It Out: Looping Through a Result Set
142(2)
How It Works
144(1)
Using Ordinal Indexers
145(1)
Try It Out: Using Ordinal Indexers
145(2)
How It Works
147(1)
Using Column Name Indexers
148(1)
Using Typed Accessor Methods
149(3)
Try It Out: Using Typed Accessor Methods
152(2)
How It Works
154(1)
Getting Data About Data
155(5)
Try It Out: Getting Information About a Result Set with a Data Reader
156(3)
How It Works
159(1)
Getting Data About Tables
160(4)
Try It Out: Getting Schema Information
161(2)
How It Works
163(1)
Using Multiple Result Sets with a Data Reader
164(4)
Try It Out: Handling Multiple Result Sets
165(2)
How It Works
167(1)
Summary
168(1)
Introducing Datasets and Data Adapters
169(52)
Understanding the Object Model
170(4)
Datasets vs. Data Readers
170(1)
A Brief Introduction to Datasets
170(2)
A Brief Introduction to Data Adapters
172(2)
Working with Datasets and Data Adapters
174(37)
Try It Out: Populating a Dataset with a Data Adapter
174(2)
How It Works
176(2)
Filtering and Sorting in a Dataset
178(10)
Modifying Data in a Dataset
188(3)
Propagating Changes to a Data Source
191(20)
Concurrency
211(1)
Using Datasets and XML
212(3)
Try It Out: Extracting a Dataset to an XML File
212(2)
How It Works
214(1)
Using Data Tables Without Datasets
215(3)
Try It Out: Populating a Data Table with a Data Adapter
215(2)
How It Works
217(1)
Understanding Typed and Untyped Datasets
218(1)
Summary
219(2)
Introducing Data Binding
221(22)
What's Data Binding?
221(1)
Performing Simple Data Binding
222(2)
Try It Out: Using Simple Data Binding
222(1)
How It Works
223(1)
Performing Complex Data Binding
224(6)
Try It Out: Using Complex Data Binding
225(5)
How It Works
230(1)
Understanding Data Binding: Behind the Scenes
230(1)
Synchronizing Controls with a Data Source
231(5)
Try It Out: Using a Binding Manager
232(3)
How It Works
235(1)
Updating from a Data Grid
236(5)
Try It Out: Updating a Table Using a Data Grid
236(3)
How It Works
239(2)
Summary
241(2)
Understanding Tables and Relationships
243(24)
Managing Tables
243(1)
Creating Tables
244(5)
Creating a Table with SSMSE
244(2)
Creating a Table with SQL
246(3)
Dropping Tables
249(3)
Dropping a Table with SSMSE
250(1)
Dropping a Table with SQL
251(1)
Relationships Between Tables
252(3)
Understanding Keys
254(1)
Data Integrity
255(9)
Entity Integrity
255(2)
Referential Integrity
257(2)
Testing Entity and Referential Integrity
259(5)
Normalization
264(1)
Summary
265(2)
Learning More About Queries
267(34)
More SQL Query Syntax
267(1)
Distinct
268(2)
Try It Out: Querying Using Distinct
268(1)
How It Works
269(1)
Subqueries
270(1)
In
270(5)
Try It Out: Using the IN Predicate
271(1)
How It Works
272(1)
Try It Out: Using the Not IN Predicate
272(1)
How It Works
273(1)
Try It Out: Using a Function with the IN Predicate
274(1)
How It Works
274(1)
Group By
275(1)
Try It Out: Using the Group By Clause
275(1)
How It Works
276(1)
Other Aggregates
276(2)
Try It Out: Using the MIN, MAX, and AVG Functions
277(1)
How It Works
278(1)
Datetime Functions
278(2)
Try It Out: Using T-SQL Date and Time Functions
278(1)
How It Works
279(1)
Case Expressions
280(4)
Simple Case Expressions
280(1)
Try It Out: Using a Simple Case Expression
280(1)
How It Works
281(1)
Try It Out: Using a More Complex Case Expression
282(1)
How It Works
283(1)
Searched Case Expressions
284(2)
Try It Out: Using a Searched Case Expression
284(1)
How It Works
285(1)
Joins
286(14)
Inner Joins
286(1)
Try It Out: Writing an Inner Join
287(1)
How It Works
288(1)
Try It Out: Writing an Inner Join Using Correlation Names
289(1)
How It Works
290(1)
Try It Out: Writing an Inner Join Using Correlation Names and Aliases
291(1)
How It Works
292(1)
Try It Out: Coding an Inner Join Using Original Syntax
292(1)
How It Works
293(1)
Try It Out: Writing an Inner Join of Three Tables
294(1)
How It Works
295(1)
Outer Joins
296(1)
Try It Out: Adding an Employee with No Orders
296(1)
How It Works
297(1)
Try It Out: Using Left Outer Join
297(1)
How It Works
298(1)
Other Joins
299(1)
Summary
300(1)
Using Stored Procedures
301(22)
Creating Stored Procedures
301(10)
Try It Out: Creating and Executing a Trivial Stored Procedure
302(4)
How It Works
306(1)
Try It Out: Creating a Stored Procedure with an Input Parameter
307(1)
How It Works
308(1)
Try It Out: Creating a Stored Procedure with an Output Parameter
309(1)
How It Works
310(1)
Modifying Stored Procedures
311(2)
Try It Out: Modifying Our Trivial Stored Procedure
311(2)
How It Works
313(1)
Deleting Stored Procedures
313(1)
Try It Out: Modifying Our Trivial Stored Procedure
313(1)
How It Works
314(1)
Working with Stored Procedures in Visual Basic
314(7)
Try It Out: Executing a Stored Procedure with No Input Parameters
315(1)
How It Works
316(1)
Try It Out: Executing a Stored Procedure with Parameters
317(3)
How It Works
320(1)
Summary
321(2)
Handling Exceptions
323(22)
Handling ADO.NET Exceptions
323(9)
Try It Out: Handling an ADO.NET Exception (Part 1)
323(4)
How It Works
327(1)
Try It Out: Handling an ADO.NET Exception (Part 2)
328(3)
How It Works
331(1)
Handling Database Exceptions
332(11)
Try It Out: Handling a Database Exception (Part 1): Raiserror
334(2)
How It Works
336(2)
Try It Out: Handling a Database Exception (Part 2): Stored Procedure Error
338(2)
How It Works
340(1)
Try It Out: Handling a Database Exception (Part 3): Errors Collection
340(2)
How It Works
342(1)
Summary
343(2)
Using Transactions
345(20)
When to Use Transactions
345(1)
Understanding ACID Properties
346(1)
Coding Transactions
347(17)
Coding Transactions in T-SQL
348(11)
Coding Transactions in ADO.NET
359(5)
Suggestions for Further Study
364(1)
Summary
364(1)
Working with ADO.NET Events
365(22)
Understanding Events
365(1)
Adding and Removing Event Handlers
366(1)
Raising and Handling ADO.NET Events
366(19)
Working with Connection Object Events
366(9)
Working with RowUpdate Events
375(6)
Working with Multiple Handlers
381(4)
Summary
385(2)
Working with Text and Binary Data
387(24)
Understanding SQL Server Text and Binary Data Types
387(1)
Storing Images in a Database
388(7)
Try It Out: Loading Image Binary Data from Files
389(3)
How It Works
392(3)
Rerunning the Program
395(1)
Retrieving Images from a Database
395(5)
Try It Out: Displaying Stored Images
395(3)
How It Works
398(2)
Working with Text Data
400(6)
Try It Out: Loading Text Data from a File
400(4)
How It Works
404(2)
Retrieving Data from Text Columns
406(3)
Try It Out: Retrieving Text Data
406(2)
How It Works
408(1)
Summary
409(2)
Using XML
411(26)
What is XML?
411(1)
Understanding XML Documents
412(2)
Understanding the XML Declaration
414(1)
Using For XML
414(8)
Try It Out: Creating Some Sample Data
415(2)
How It Works
417(1)
Try It Out: Using For XML Raw
418(1)
How It Works
419(1)
Try It Out: Using For XML Auto
419(1)
How It Works
420(1)
Try It Out: Using For XML Auto Again
420(1)
How It Works
421(1)
Using OpenXml
422(7)
Try It Out: Using OpenXml
423(2)
How It Works
425(2)
Try It Out: Generating an Edge Table
427(1)
How It Works
428(1)
Using the XML Data Type
429(7)
Try It Out: Creating a Table to Store XML
429(1)
How It Works
430(1)
Try It Out: Storing and Retrieving XML Documents
430(1)
How It Works
431(1)
Try It Out: Using OpenXml with XML Columns
432(1)
How It Works
433(1)
Try It Out: Using an Element-centric Schema with OpenXml
434(1)
How It Works
435(1)
Summary
436(1)
Introducing LINQ
437(26)
What Is LINQ?
438(1)
Installing LINQ
439(5)
Using Linq to SQL
444(9)
Try It Out: Coding a Simple Linq to SQL Query
444(2)
How It Works
446(3)
Try It Out: Using the Where Clause
449(1)
How It Works
450(1)
Try It Out: Using the Order By Clause
450(2)
How It Works
452(1)
Using Linq to DataSet
453(9)
Try It Out: Coding a Simple Linq to DataSet Query
453(2)
How It Works
455(1)
Try It Out: Using Linq to DataSet with a Typed Dataset
456(4)
How It Works
460(2)
Summary
462(1)
Index 463


Jacob Hammer Pedersen started programming in the early 1990s, moving gradually from Pascal to C++ to Visual Basic. In the summer of 2000, he discovered C# and has explored it happily ever since.
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97814302039572e.html
Keywords: