problem with output parameter of stored procedure

Question

I am getting error
System.Data.SqlClient.SqlException: Procedure or Function 'sp_login' expects parameter '@Results', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at login.signin_Click(Object sender, ImageClickEventArgs e) in d:\Careforindiafinal\login.aspx.cs:line 40


my C# code is
SqlConnection myConnection;
            connection dbconnection = new connection();
            myConnection = dbconnection.connectiondb();
            SqlCommand myCommand = new SqlCommand("[careforindia].[dbo].[sp_login]", myConnection);
            myCommand.CommandType = CommandType.StoredProcedure;
            myCommand.Connection = myConnection;
            myCommand.CommandText = "sp_login";
            myCommand.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar,255, "username"));
            myCommand.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar,255, "password"));
            myCommand.Parameters["@username"].Value = username.Value;
            myCommand.Parameters["@password"].Value = password.Value;
           // myCommand.Parameters.Add(new SqlParameter("@Result", SqlDbType.Int, 5, ParameterDirection.Output, false, 0, 50, "Result", DataRowVersion.Default, null));
            SqlParameter Result = myCommand.Parameters.Add("@Result", SqlDbType.Int, 5);
            Result.Direction = ParameterDirection.Output;
           int res=1;
            myCommand.ExecuteNonQuery();
           res = (int)myCommand.Parameters["@Result"].Value;

My Procedure is
ALTER PROCEDURE [dbo].[sp_login]
    -- Add the parameters for the stored procedure here
    @username varchar ,
    @password varchar ,
    @Results int Output
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
Set @Results = (Select count(*) from [dbo].[user] where username = @username and password = password )

END


Can anyone help me to remove the error
for creating database connection i have created seprate class

Answer 1

yes it can i have gotten it to work.the only problem i came across is that the folder where you reference your dll must contain the xml file that contains the information about the DLL. Try making the XML file the same name as the assembly