The Chapter 9 CommandExecute.aspx example works fine using OleDB. Since I'll be writing most of my code against a sql database I'm trying to convert the code to work with northwind on my personal sql server database. I'm getting an error for the following line:

Code error:
Line 24: Dim firstNameParam As New SqlParameter("@FirstName", SqlDbType.VarChar, 10)

Error Message:
C:\Begining ASP.NET 1.1\ch09\CommandExecute.aspx(24) : error BC30451: Name 'SqlDbType' is not declared.

What am I doing wrong?

Thanks.

Kevin

My code:

<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

    ' Insert page code here
         '

         Sub btnRun_Click(sender As Object, e As EventArgs)
         Dim ConnectionString As String = "server=(local);database=northwind;trusted_connect ion=true"

         Dim dbConnection As New sqlConnection(connectionString)
         dbConnection.Open()

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

         Dim dbCommand As New SqlCommand(commandString, dbConnection)


    '=============================


         Dim firstNameParam As New SqlParameter("@FirstName", SqlDbType.VarChar, 10)
         firstNameParam.Value = txtFirstName.Text
         dbCommand.Parameters.Add(firstNameParam)

         Dim lastNameParam As New SqlParameter("@LastName", SqlDbType.VarChar, 10)
         LastNameParam.Value = txtLastName.Text
         dbCommand.Parameters.Add(LastNameParam)

    '==============================

         dbCommand.ExecuteNonQuery()

         dbConnection.Close()
         End Sub

Good grief! It turned out to be simple. I needed to have the following import statements:

Original:
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data.SqlClient" %>

New:
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>


Kevin