Beginning ASP.NET 1.1 with VB.NET 2003

The configuration directions as written cause Web Matrix to use Framework version 1.1, but you also need to configure the Web server Cassini to use Framework version 1.1 or you could have problems when you use a DLL created in WebMatrix version 1.1 but try to run a Web form against the server using Framework 1.0. Specifically, without this fix you might encounter this problem in chapter 16. To correct this, replace step 4 on page 29 with these new steps 4 to 6.

4. Save the file.

5. Next you need to create a new text file with the name WebServer.exe.config and add the following code:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<startup>
<supportedRuntime version="v1.1.4322" />
</startup>
</configuration>

If the file already exists then all you need do is insert the <startup> and <supportedRuntime> tags between the <configSection> and <runtime> tags as you did with WebMatrix.exe.config.

6. Save the file and when you run Web Matrix, the .NET Framework version should now be 1.1.x. Select the "About ASP.NET Web Matrix..." item from the Help menu. It should confirm this.

2nd code block should be:

dataAdapter.Fill(data, "Products")
dataAdapter.SelectCommand.CommandText = "SELECT * FROM Employees"
dataAdapter.Fill(data, "Employees")

Additional paragraph and code block after 2nd code block should be:

The problem is that this code doesn't work as expected, because IDbDataAdapter doesn't accept the table name as an argument. For this to work you have to use the actual class, OleDbDataAdapter, rather than the interface:

Dim dataAdapter As System.Data.OleDb.OleDbDataAdapter = _
   New System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim data As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(data, "Products")

If SelectedRows.Length > 0 Then
   selectedRows(0).Item("FirstName") = "John"
   selectedRows(0).Item("LastName") = "Hartford"
End If

If txtFirstName.Text.Trim() = "" Or _
   txtLastName.Text.Trim() = "" Then
   Return
End If

Dim commandString As String = _
   "INSERT INTO Employees(FirstName, LastName) " & _
   "Values(@FirstName, @LastName)"

If dbCommand.ExecuteNonQuery() > 0 Then
  lblStatus.Text = "Data was added successfully"
Else
  lblStatus.Text = "Data could not be added"
End If

Else If CInt (txtQuantity.Text) <= 0 Then

<trace enabled="true" requestLimit="10" pageOutput="false"

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <system.web>
   <compilation />
   <customErrors />
   <authentication />
   <authorization />
   <trace />
   <sessionState />
   <globalization />
  </system.web>
</configuration>