(Ebook) ADO ActiveX data objects 1st Edition by Jason T Roff ISBN 9781565924154 1565924150

(Ebook) ADO ActiveX data objects 1st Edition by Jason T Roff ISBN 9781565924154 1565924150

(Ebook) ADO ActiveX data objects 1st Edition by Jason T Roff - Ebook PDF Instant Download/Delivery: 9781565924154 ,1565924150
Full download (Ebook) ADO ActiveX data objects 1st Edition after payment

Product details:

ISBN 10: 1565924150
ISBN 13: 9781565924154
Author: Jason T Roff

(Ebook) ADO ActiveX data objects 1st Edition Table of contents:

1. I
2. Introduction to ADO
3. ADO in Context: Universal Data Access
4. ODBC
5. Jet/DAO
6. RDO
7. ODBCDirect
8. OLE DB
9. ADO
10. RDS
11. Putting It All Together
12. ADO and COM: Language Independence
13. COM
14. ADO and COM
15. When to Use ADO
16. Summary
17. The ADO Architecture
18. An Overview of the ADO Architecture
19. ADO Components
20. The Connection Object
21. The Command Object
22. The Parameters collection and the Parameter object
23. The Recordset Object
24. The Fields collection and the Field object
25. The Record Object
26. The Stream Object
27. The Properties Collection and the Property Object
28. The Errors Collection and the Error Object
29. Summary
30. Accessing ADO with Various Languages
31. Accessing ADO with Visual Basic
32. Referencing ActiveX Data Objects
33. Creating ActiveX Data Objects
34. Using ADO with Visual Basic: An Example
35. Accessing ADO with Visual C++
36. Referencing ActiveX Data Objects
37. Creating ActiveX Data Objects
38. Using ADO with Visual C++: An Example
39. Accessing ADO with Visual J++
40. Referencing ActiveX Data Objects
41. Creating ActiveX Data Objects
42. Using ADO with Visual J++: An Example
43. Accessing ADO with VBScript
44. Referencing ActiveX Data Objects
45. Creating ActiveX Data Objects
46. Using ADO with VBScript: An Example
47. Accessing ADO with JScript
48. Referencing ActiveX Data Objects
49. Creating ActiveX Data Objects
50. Using ADO with JScript: An Example
51. Summary
52. The Connection Object
53. Opening and Closing a Connection: Implicit Versus Explicit
54. Opening a Connection
55. Closing a Connection
56. Configuring Connections
57. Working with Connection Strings
58. Working with Data Source Names
59. Installing the DSNs
60. Opening a connection with a DSN
61. Setting Connection Options
62. Default database
63. Data-access permissions
64. Timeout setting
65. Cursor location
66. Determining ADO Version Number and Connection State
67. Choosing a Data Provider
68. Executing Commands
69. The Execute Method
70. The CommandTimeout Property
71. Managing Multiple Transactions
72. Starting a Transaction: The BeginTrans and CommitTrans Methods
73. Canceling a Transaction: The RollbackTrans Method
74. Nesting Transactions
75. Setting Transaction Options
76. Automatic creation of new transactions
77. Isolation level
78. Determining the Layout of Your Data Source
79. Summary
80. The Recordset Object
81. Cursors: Viewing a Recordset
82. Dynamic Cursor
83. Keyset Cursor
84. Static Cursor
85. Forward-Only Cursor
86. CursorType Example
87. Working with Recordsets
88. The Open Method
89. The Save Method
90. Determining the State of the Recordset Object: The State Property
91. Fine-Tuning Performance of the Recordset Object
92. The CacheSize property
93. The MaxRecords property
94. The CursorLocation property
95. Sorting, Filtering, and Finding Rows in a Recordset
96. The Filter property
97. The Sort property
98. The Resync method
99. The Find method
100. Working with Multiple Recordset Objects
101. Navigating a Recordset
102. The Record Pointer
103. The MoveFirst, MovePrevious, MoveNext, and MoveLast Methods
104. The Move Example
105. Ordinal Position
106. Bookmarks
107. The Move method
108. Paging
109. Working with Records
110. Adding New Records
111. Updating and Editing Records
112. Deleting Records
113. Retrieving Records
114. Lock Types: Managing Access to a Recordset
115. Read-Only Locks
116. Pessimistic Locks
117. Optimistic Locks
118. Batch Optimistic Locks
119. Summary
120. Fields
121. The Fields Collection Object
122. The Field Object
123. Working with the Fields Collection
124. Field Specifics
125. Field Datatypes
126. Field Sizes
127. Large Datatypes
128. Batch Updates
129. Determining Field Object Functionality
130. Summary
131. The Command Object
132. Specifying Commands
133. Textual Definitions as Commands
134. Stored Procedures as Commands
135. Table Names as Commands
136. Unknown Command Types
137. Executing Commands
138. Executing Commands with the Command Object
139. Executing Commands with the Connection Object
140. Executing Commands with the Recordset Object
141. Parameters
142. Passing Parameters
143. Parameter Properties
144. Specifying Parameters
145. The Parameters Project
146. Asynchronous Execution
147. Executing a Command Asynchronously
148. Canceling a Command
149. Summary
150. The ADO Event Model
151. Introduction to Events
152. The ConnectionEvent Family
153. Connection Events
154. Execution Events
155. Transaction Events
156. Informational Events
157. The RecordsetEvent Family
158. Retrieval Events
159. Movement Events
160. Field Change Events
161. Record Change Events
162. Recordset Change Events
163. Canceling Operations
164. Turning Events Off
165. Summary
166. Data Shaping
167. An Introduction to Data Shaping
168. The Microsoft Data Shaping Service
169. Shaping Commands
170. APPEND Command
171. COMPUTE Command
172. Shape Functions
173. Example: Accessing Shaped Recordsets
174. Summary
175. Records and Streams
176. The Record Object
177. Opening a Record Object
178. Opening a Record object with a Command object
179. Opening a Record object with a SQL statement
180. Opening a Record object with a table name
181. Opening a Record object with an open Recordset object
182. Opening a Record object with a URL
183. Navigating Hierarchies
184. File and Directory Manipulation with the Record Object
185. Copying
186. Deleting
187. Moving
188. Record Object Properties
189. Record Object Fields
190. Internet Publishing provider fields
191. Standard Record object fields
192. The Stream Object
193. Opening a Stream Object
194. Obtaining a Stream with the Default Stream from a Record object
195. Opening a Stream with an open Record object
196. Opening a Stream with an absolute URL
197. Opening a Stream in memory
198. Reading and Writing with Streams
199. Textual data
200. Binary data
201. Stream persistence
202. Summary
203. Remote Data Services
204. RDS Object Model
205. The DataSpace Object
206. DataSpace object members
207. Instantiating an object with the DataSpace object
208. The DataFactory Object
209. DataFactory object members
210. Creating an empty recordset on the client side
211. Roundtrip querying and updating
212. The DataControl Object
213. DataControl object members
214. Binding a control to the DataControl object
215. Filtering and sorting the recordset
216. An Example in RDS
217. More Information About RDS
218. Summary
219. The Microsoft .NET Framework and ADO.NET
220. The Microsoft .NET Framework
221. The Common Language Runtime
222. C#: Unified Programming Language
223. ASP.NET
224. From COM to .NET: The Creation of ADO.NET
225. ADO.NET
226. DataSets
227. Managed Providers
228. ADO.NET Features
229. Disconnected Data
230. Strongly Typed Language
231. XML Integration
232. Summary
233. II
234. ADO API Reference
235. Finding the Reference Page
236. Using the Reference Pages
237. Sample Object
238. Sample Object.Property
239. Sample Object.Method
240. Command Object
241. Command.ActiveConnection Property
242. Command.Cancel Method
243. Command.CommandStream Property
244. Command.CommandText Property
245. Command.CommandTimeout Property
246. Command.CommandType Property
247. Command.CreateParameter Method
248. Command.Dialect Property
249. Command.Execute Method
250. Command.Name Property
251. Command.NamedParameters Property
252. Command.Parameters Collection
253. Command.Prepared Property
254. Command.Properties Collection
255. Command.State Property
256. Connection Object
257. Connection.Attributes Property
258. Connection.BeginTrans Method (Versions 2.0, 2.1, 2.5, 2.6) Connection.CommitTrans Method (Vers...
259. Connection.BeginTransComplete Event
260. Connection.Cancel Method
261. Connection.Close Method
262. Connection.CommandTimeout Property
263. Connection.CommitTrans Method
264. Connection.CommitTransComplete Event
265. Connection.ConnectComplete Event
266. Connection.ConnectionString Property
267. Connection.ConnectionTimeout Property
268. Connection.CursorLocation Property
269. Connection.DefaultDatabase Property
270. Connection.Disconnect Event
271. Connection.Errors Collection
272. Connection.Execute Method
273. Connection.ExecuteComplete Event
274. Connection.InfoMessage Event
275. Connection.IsolationLevel Property
276. Connection.Mode Property
277. Connection.Open Method
278. Connection.OpenSchema
279. Connection.Properties Collection
280. Connection.Provider Property
281. Connection.RollbackTrans Method
282. Connection.RollbackTransComplete Event
283. Connection.State Property
284. Connection.Version Property
285. Connection.WillConnect Event
286. Connection.WillExecute Event
287. Error Object
288. Error.Description Property
289. Error.HelpContext Property (Versions 2.0, 2.1, 2.5, 2.6) Error.HelpFile Property
290. Error.NativeError Property
291. Error.Number Property
292. Error.Source Property
293. Error.SQLState Property
294. Errors Collection
295. Errors.Clear Method
296. Errors.Count Property
297. Errors.Item Property
298. Errors.Refresh Method
299. Field Object
300. Field.ActualSize Property
301. Field.AppendChunk
302. Field.Attributes Property
303. Field.DataFormat Property
304. Field.DefinedSize Property
305. Field.GetChunk Method
306. Field.Name Property
307. Field.NumericScale Property
308. Field.OriginalValue Property
309. Field.Precision Property
310. Field.Properties Collection
311. Field.Status Property
312. Field.Type Property
313. Field.UnderlyingValue Property
314. Field.Value Property
315. Fields Collection
316. Fields.Append Method
317. Fields.CancelUpdate Method
318. Fields.Count Property
319. Fields.Delete Method
320. Fields.Item Property
321. Fields.Refresh Method
322. Fields.Resync Method
323. Fields.Update Method
324. Parameter Object
325. Parameter.AppendChunk Method
326. Parameter.Attributes Property
327. Parameter.Direction Property
328. Parameter.Name Property
329. Parameter.NumericScale Property
330. Parameter.Precision Property
331. Parameter.Properties Collection
332. Parameter.Size Property
333. Parameter.Type Property
334. Parameter.Value Property
335. Parameters Collection
336. Parameters.Append Method
337. Parameters.Count Property
338. Parameters.Delete Method
339. Parameters.Item Property
340. Parameters.Refresh Method
341. Properties Collection
342. Properties.Count Property
343. Properties.Item Property
344. Properties.Refresh Method
345. Property Object
346. Property.Attributes Property
347. Property.Name Property
348. Property.Type Property
349. Property.Value Property
350. Record Object
351. Record.ActiveConnection Property
352. Record.Cancel Method
353. Record.Close Method
354. Record.CopyRecord Method
355. Record.DeleteRecord Method
356. Record.Fields Collection
357. Record.GetChildren Method
358. Record.Mode Property
359. Record.MoveRecord Method
360. Record.Open Method
361. Record.ParentURL Property
362. Record.Properties Collection
363. Record.RecordType Property
364. Record.Source Property
365. Record.State Property
366. Recordset Object
367. Recordset.AbsolutePage Property
368. Recordset.AbsolutePosition Property
369. Recordset.ActiveCommand Property
370. Recordset.ActiveConnection Property
371. Recordset.AddNew Method
372. Recordset.BOF Property (Versions 2.0, 2.1, 2.5, 2.6) Recordset.EOF Property
373. Recordset.Bookmark Property
374. Recordset.CacheSize Property
375. Recordset.Cancel Method
376. Recordset.CancelBatch Method
377. Recordset.CancelUpdate Method
378. Recordset.Clone Method
379. Recordset.Close Method
380. Recordset.CompareBookmarks Method
381. Recordset.CursorLocation Property
382. Recordset.CursorType Property
383. Recordset.DataMember Property (Versions 2.0, 2.1, 2.5, 2.6) Recordset.DataSource Property
384. Recordset.Delete Method
385. Recordset.EditMode Property
386. Recordset.EndOfRecordset Event
387. Recordset.EOF Property
388. Recordset.FetchComplete Event
389. Recordset.FetchProgress Event
390. Recordset.FieldChangeComplete Event
391. Recordset.Fields Collection
392. Recordset.Filter Property
393. Recordset.Find Method
394. Recordset.GetRows Method
395. Recordset.GetString Method
396. Recordset.Index Property
397. Recordset.LockType Property
398. Recordset.MarshalOptions Property
399. Recordset.MaxRecords Property
400. Recordset.Move Method
401. Recordset.MoveComplete Event
402. Recordset.MoveFirst Method (Versions 2.0, 2.1, 2.5, 2.6) Recordset.MoveLast Method (Versions...
403. Recordset.NextRecordset Method
404. Recordset.Open Method
405. Recordset.PageCount Property
406. Recordset.PageSize Property
407. Recordset.Properties Collection
408. Recordset.RecordChangeComplete Event
409. Recordset.RecordsetChangeComplete Event
410. Recordset.RecordCount Property
411. Recordset.Requery Method
412. Recordset.Resync Method
413. Recordset.Save Method
414. Recordset.Seek Method
415. Recordset.Sort Property
416. Recordset.Source Property
417. Recordset.State Property
418. Recordset.Status Property
419. Recordset.StayInSync Property
420. Recordset.Supports Method
421. Recordset.Update Method
422. Recordset.UpdateBatch Method
423. Recordset.WillChangeField Event
424. Recordset.WillChangeRecord Event
425. Recordset.WillChangeRecordset Event
426. Recordset.WillMove Event
427. Stream Object
428. Stream.Cancel Method
429. Stream.CharSet Property
430. Stream.Close Method
431. Stream.CopyTo Method
432. Stream.EOS Property
433. Stream.Flush Method
434. Stream.LineSeparator Property
435. Stream.LoadFromFile Method
436. Stream.Mode Property
437. Stream.Open Method
438. Stream.Position Property
439. Stream.Read Method
440. Stream.ReadText Method
441. Stream.SaveToFile Method
442. Stream.SetEOS Method
443. Stream.Size Property
444. Stream.SkipLine Method
445. Stream.State Property
446. Stream.Type Property
447. Stream.Write Method
448. Stream.WriteText Method
449. III
450. Introduction to SQL
451. Record Selection
452. Selection Statements
453. SELECT
454. SELECT ALL
455. SELECT DISTINCT
456. SELECT DISTINCTROW
457. SELECT TOP
458. Aggregate Functions
459. AVG
460. COUNT
461. MIN and MAX
462. STDEV and STDEVP
463. SUM
464. VAR and VARP
465. Setting Conditions
466. WHERE
467. WHERE
468. Grouping and Ordering
469. GROUP BY
470. HAVING
471. ORDER BY
472. SELECT TOP
473. Joining Tables
474. INNER JOIN
475. LEFT JOIN and RIGHT JOIN
476. SELECT DISTINCTROW
477. Subqueries
478. Unions
479. UNION
480. Other Options
481. PARAMETERS
482. PROCEDURE
483. WITH OWNERACCESS OPTION
484. Data Manipulation
485. Adding Records
486. INSERT . . . INTO
487. Modifying Records
488. UPDATE
489. Deleting Records
490. DELETE
491. Database Modification
492. CREATE TABLE
493. ALTER TABLE
494. CONSTRAINT
495. CREATE INDEX
496. DROP
497. The Properties Collection
498. The Property Example
499. ADO Errors
500. Working with Errors in ADO
501. ADO Trappable Errors
502. Data-Provider Errors
503. The Errors Example
504. The Main Form
505. The ADO Error(s) Form
506. The ADO Data Control
507. The ADO Data Control Property Pages
508. Creating Connection Strings with the ADO Data Control
509. Data Link Properties Dialog Box
510. Entering provider information
511. Entering connection information
512. Entering advanced information
513. Reviewing all of the Data Link information
514. Data Link Files
515. The ADO Data Control Example
516. Enumeration Tables
517. ADCPROP_ASYNCTHREADPRIORITY_ENUM Enumeration
518. ADCPROP_AUTORECALC_ENUM Enumeration
519. ADCPROP_UPDATECRITERIA_ENUM Enumeration
520. ADCPROP_UPDATERESYNC_ENUM Enumeration
521. AffectEnum Enumeration
522. BookmarkEnum Enumeration
523. CommandTypeEnum Enumeration
524. CompareEnum Enumeration
525. ConnectModeEnum Enumeration
526. ConnectOptionEnum Enumeration
527. ConnectPromptEnum Enumeration
528. CopyRecordOptionsEnum Enumeration
529. CursorLocationEnum Enumeration
530. CursorOptionEnum Enumeration
531. CursorTypeEnum Enumeration
532. DataTypeEnum Enumeration
533. EditModeEnum Enumeration
534. ErrorValueEnum Enumeration
535. EventReasonEnum
536. EventStatusEnum Enumeration
537. ExecuteOptionEnum Enumeration
538. FieldAttributesEnum Enumeration
539. FieldEnum Enumeration
540. FieldStatusEnum Enumeration
541. FilterGroupEnum Enumeration
542. GetRowsOptionEnum Enumeration
543. IsolationLevelEnum Enumeration
544. LineSeparatorEnum Enumeration
545. LockTypeEnum Enumeration
546. MarshalOptionsEnum Enumeration
547. MoveRecordOptionsEnum Enumeration
548. ObjectStateEnum Enumeration
549. ParameterAttributesEnum Enumeration
550. ParameterDirectionEnum Enumeration
551. PersistFormatEnum Enumeration
552. PositionEnum Enumeration
553. PropertyAttributesEnum Enumeration
554. RecordCreateOptionsEnum Enumeration
555. RecordOpenOptionsEnum Enumeration
556. RecordStatusEnum Enumeration
557. RecordTypeEnum Enumeration
558. ResyncEnum Enumeration
559. SaveOptionsEnum Enumeration
560. SchemaEnum Enumeration
561. SearchDirectionEnum Enumeration
562. SeekEnum Enumeration
563. StreamOpenOptionsEnum Enumeration
564. StreamReadEnum Enumeration
565. StreamTypeEnum Enumeration
566. StreamWriteEnum Enumeration
567. StringFormatEnum Enumeration
568. XactAttributeEnum Enumeration
569. Index

People also search for (Ebook) ADO ActiveX data objects 1st Edition:

activex data objects (ado)
    
ado (activex data object)
    
microsoft activex data objects
    
microsoft activex data object library
    
microsoft activex data objects ado

Tags: Jason T Roff, ADO, ActiveX data objects