nvarchar parameter of sql stored proc.

[Matthieu C]

Hi, I'm doing ASP.NET application. What is the type of the SqlParameter.Value to call a stored procedure expecting a nvarchar parameter? I tried to simply use a string, but it fails (code compiles, but the stored procedure returns nothing). I tried also to cast the string to a SqlDbType.Nvarchar, but I didn't manage. Thanks for help, sorry if I'm not clear ... Matthieu

[Not Active]

String should work. What does the stored proc look like?

[Matthieu C]

Hi, The procedure: ALTER PROCEDURE matthieu77.GetUserByName ( @Nom nvarchar ) AS SELECT UserID, Nom FROM Users WHERE Nom=@Nom RETURN The code that calls this proc: SqlParameter param = new SqlParameter ("@Nom",SqlDbType.NVarChar); param.Direction=ParameterDirection.Input; param.Value="Bonjour"; SqlDataAdapter ad = new SqlDataAdapter(); ad.SelectCommand = new SqlCommand(); ad.SelectCommand.Connection = sqlConnection1; ad.SelectCommand.CommandText = "GetUserByName"; ad.SelectCommand.CommandType =CommandType.StoredProcedure; ad.SelectCommand.Parameters.Add(param); ad.Fill(dataSet11,"Users"); DataGrid1.DataBind(); If I replace in the stored procedure Nom='Bonjour' it works fine. Regards, Matthieu