Ok, here it is
CREATE PROCEDURE dbo.sp_GetCustomerById
@customerID nchar
AS
BEGIN
SELECT
Record_Id,
Cust_name
FROM
Customers
WHERE
Record_Id = @customerID
END
GO
>Kevin,
>
>Just to complete the picture, can you post your code for your stored proc?
>
>This is a total guess, but you might need to set the SqlDbType for the parameter (SqlDbType.nChar). Depending on what's in your stored proc, I'm a little surprised it didn't throw an error converting from text to nchar. But again, I'm not sure, so if you can post your SP we can go from there.
>
>Kevin
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people