Sample code in the SqlTransaction class and SqlException class Help documentation is incorrect (320142)

MORE INFORMATION

SqlTransaction Class

The following code is incorrect in the "SqlTransaction Class" Help documentation:

Console.WriteLine("Error: {1}", e.Message)
Console.WriteLine("Error reported by {1}.", e.Source)
				

When you use the Console.WriteLine method with a format string, the argument parameters should be 0-based, not 1-based. You receive the following error message when you run the code in the "SqlTransation Class" Help documentation: To resolve this problem, replace the argument parameters with 0 to correctly reference the 0-based array as follows:

Console.WriteLine("Error: {0}", e.Message)
Console.WriteLine("Error reported by {0}.", e.Source)
				

SqlException Class

The argument parameters of Console.WriteLine should be 0-based, not 1-based. You receive the following error message when you run the code in the "SqlException Class" Help documentation: Additionally, the second sample in the "SqlException Class" Visual Studio .NET Help documentation includes three problems:

• The code issues a "Catch e As SqlException" statement that is followed by a "Dim e As SqlException" statement. This throws an error because the object already exists.
• The errors count property is incorrectly referenced in the following line of code:

  For i = 0 To myErrors.Errors.Count - 1
  					

• When the code references the SqlErrorsCollection, the code incorrectly uses square brackets instead of parentheses in the following line of code:

  myErrors[i].Number
  					

To resolve this problem, replace the code in the "SqlException Class" Help documentation sample with the following code:

Public Sub ThrowSqlException()
   Dim myConnString As String = "user id=sa;password=;database=northwind;server=badserver"

   Dim myConnection As New SqlConnection(myConnString)
   Try
      myConnection.Open()
   Catch e As SqlException
      Dim myErrors As SqlErrorCollection = e.Errors
      Dim f As SqlError
      For Each f In myErrors
         Console.WriteLine("Class: {0}", f.Class)
         Console.WriteLine("Error #{0}: {1} on line {2}.", f.Number, f.Message, f.LineNumber)
         Console.WriteLine("Error reported by {0} while connected to {1}", f.Source, f.Server)
         Console.WriteLine("Neither record was written to database.")
         Console.WriteLine("Errors collection contains:")
         Dim i As Integer
         For i = 0 To myErrors.Count - 1
            Console.WriteLine("Class: {0}", myErrors(i).Class)
            Console.WriteLine("Error #{0}: {1} on line {2}.", myErrors(i).Number, myErrors(i).Message, f.LineNumber)
            Console.WriteLine("Error reported by {0} while connected to {1}", myErrors(i).Source, myErrors(i).Server)
         Next i
      Next f
   End Try
End Sub 'ThrowSqlException