Ok, I have a test function. I'm getting a dataset with
no records. There is one record in Customers with an
Id of type nchar, and a value of 'SMITH'.

Here's ny code:

Public Sub StoredProcExample()

        ' Create a new Connection
        Dim oConnection As SqlConnection
        oConnection = New SqlConnection("data source=(local);initial catalog=BM; user id=kevin; password=mypw")
        oConnection.Open()

        Dim oDataSet As New DataSet

        Dim oSqlAdapter = New SqlDataAdapter("sp_GetCustomerById", oConnection)

        oSqlAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
        oSqlAdapter.SelectCommand.Parameters.Add("@CustomerId", "SMITH")

        oSqlAdapter.Fill(oDataSet, "Customers")

        Dim oDataRow As DataRow

        For Each oDataRow In oDataSet.Tables("Customers").Rows
            Console.WriteLine(oDataRow("CustomerId").ToString())
        Next

        oConnection.Close()

    End Sub

>Kevin,
>
>Here's a very simple stored proc to return the entire customer record for a customer PK...
>
>

>CREATE PROCEDURE GetCustomerByPK (@nCustomerPK int)
> AS
>
>	SELECT * FROM Customer WHERE CustomerPK = @nCustomerPK
>GO
>

>
>You may want to check BOL (books online) for more details on creating SPs.
>
>Kevin