Microsoft® ADO.NET 2.0 Step by Step

Errata for Microsoft® ADO.NET 2.0 Step by Step




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page 4

Other Providers should be Other Consumers On page 4, the Data Consumers portion of the figure includes an incorrect item. Change: "Other Providers" To: "Other Consumers"

Microsoft Press  May 06, 2010 
Printed
Page 7

EmployeesForm.cs should be Employees.cs On page 7, step 2 refers to an incorrect file. Change: "Open the Chapter 01 – Start project, and if necessary, double-click Employees.vb (or EmployeesForm.cs if you’re using C#) to open the form." To: "Open the Chapter 01 – Start project, and if necessary, double-click Employees.vb (or Employees.cs if you’re using C#) to open the form."

Microsoft Press  Jul 13, 2010 
Printed
Page 27

Incorrect meaning of Datasource On page 27, the last line contains an incorrect meaning of Datasource. Change: "The location and file containing the database." To: "The name of the instance of SQL Server to which to connect."

Microsoft Press  May 06, 2010 
Printed
Page 42

StateChangeEventArts referenced in place of StateChangeEventArgs On page 42, the second sentence of the "StateChange Events" section reads: "The event passes a StateChangeEventArts object to its handler, which, in turn, has two properties: OriginalState and CurrentState." It should read: "The event passes a StateChangeEventArgs object to its handler, which, in turn, has two properties: OriginalState and CurrentState."

Microsoft Press  Jul 13, 2010 
Printed
Page 44

Additional words included in the middle of step 4 On page 44, the first sentence of step 4 reads: "To Connection states, add the following display the previous and current Connection states, add the following code to the cnSql_StateChange event handler:" It should read: "To display the previous and current Connection states, add the following code to the cnSql_StateChange event handler:"

Microsoft Press  May 06, 2010 
Printed
Page 74

Incorrect code in example On page 74, the last line of code at the bottom of the page is incorrect. Change: dsNwind.OrderTotals.Clear()To: dsAdoSbs.OrderTotals.Clear()

Microsoft Press  Jul 13, 2010 
Printed
Page 89

Instructions indicate pressing F7 rather than Shift-F7 On page 89, the first step of the Preview the Results of a DataAdapter procedure reads: "1. Press F7 to display the Form Designer." It should read: "1. Press Shift-F7 to display the Form Designer."

Microsoft Press  May 06, 2010 
Printed
Page 91

True and false behavior of the ContinueUpdateOnError property is reversed On Page 91, the second paragraph reads: "The ContinueUpdateOnError property determines how the DataAdapter behaves if an error is encountered during an update. If this property is set to True, the DataAdapter throws an exception and stops the update. If it is set to False, the update to that DataRow is skipped, the error is placed in its RowError property, and processing continues with the next row." It should read: "The ContinueUpdateOnError property determines how the DataAdapter behaves if an error is encountered during an update. If this property is set to False, the DataAdapter throws an exception and stops the update. If it is set to True, the update to that DataRow is skipped, the error is placed in its RowError property, and processing continues with the next row."

Microsoft Press  Jul 13, 2010 
Printed
Page 106

"RecordsEffected" should be "RecordsAffected" On page 106, the third sentence in the first paragraph contains an incorrect property. Change: "The RowUpdated event argument also exposes one additional property, RecordsEffected, which is a read-only value that indicates the number of rows that were changed." To: "The RowUpdated event argument also exposes one additional property, RecordsAffected, which is a read-only value that indicates the number of rows that were changed."

Microsoft Press  May 06, 2010 
Printed
Page 121

"Data Provider Objects" should be "Data Objects" On page 121, the title if Part III is incorrect. Change: "Data Provider Objects" To: "Data Objects"

Microsoft Press  Jul 13, 2010 
Printed
Page 143

Rows referenced in place of Columns On page 143, there are several references to 'rows' which should read 'columns'. The first code sample of step 1 and lines 9-11 of the second code sample of step 1 read: dr = dsAdoSbs.CreateDataReader(dsAdoSbs.Employees) MessageBox.Show("The DataTableReader has " & dr.FieldCount.ToString() & _ " rows")They should read: dr = dsAdoSbs.CreateDataReader(dsAdoSbs.Employees) MessageBox.Show("The DataTableReader has " & dr.FieldCount.ToString() & _ "columns")The second sentence of step 3 reads: "The application displays the number of rows in the DataTable."It should read: "The application displays the number of columns in the DataTable." The screenshot at the end of the page is incorrect and should be disregarded.

Microsoft Press  May 06, 2010 
Printed
Page 245

Two variables referenced instead of one On page 245, the first sentence references two temporary variables, when only one is used. Change: "This code first creates two temporary variables, and then it sets them to the Update command of the daEmployees DataAdapter and to the row currently being displayed on the form, respectively." To: "This code first creates a temporary variable and sets it to the row currently being displayed on the form." Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.The print number of the book is located on the copyright page in the form of a string of numbers. For example: "2 3 4 5 6 7 8 0 QWT 9 8 76 5 4". The first number in the string is the the print number. In this example, the print number is 2.

Microsoft Press  Jul 13, 2010