I have a very simple Stored Procedure that isn't working for me:

CREATE PROCEDURE FindTutors
(
@LastName NVarChar
)
As
(
SELECT fn, ln FROM main WHERE ln = @LastName
)
GO
__________

Very simple; just trying to pass the @LastName parameter from my ASP.NET code. Still, whenever I click the button that is supposed to show all results in a datagrid, nothing comes up. I have altered the Sproc to just be "SELECT fn, ln FROM Main WHERE ln = 'Damon' " and it works fine then - so I know it's a matter of passing this parameter. Here is my codebehind - anyone have any ideas?

  Public Sub FindTutors(ByVal sender As Object, ByVal e As EventArgs) Handles btnFind.Click

    Dim cn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("C onnString"))
    Dim Cmd As SqlCommand = New SqlCommand("FindTutors", cn)

    Cmd.CommandType = CommandType.StoredProcedure
    Cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value() = txtLastName.Text.ToString()
    'Cmd.Parameters.Add("@LastName", txtLastName.Text)


    cn.Open()

    Dim rdrContent As SqlDataReader

    gridTutors.DataSource = Cmd.ExecuteReader()
    gridTutors.DataBind()

    cn.Close()

  End Sub

That code looks fine. I never use NVarChar fields, not really sure what those get you that regular VarChars don't but perhaps that's causing the problem.

Peter
------------------------------------------------------
Work smarter, not harder.