Errata for Microsoft® ADO.NET 2.0 Step by Step

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"

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."

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."

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."

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:"

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()

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."

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."

"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."

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

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.

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.