Retrieve A Dataset From Stored Procedure

Hi, Can anyone please help me solve this problem.

My functions works well with this stored procedure:

CREATE PROCEDURE proc_curCourseID
@studentID int AS
SELECT * FROM StudentCourse
WHERE mark IS NULL AND studentID = @studentID AND archived IS NULL
GO

But when I applied the same function to the following stored procedure

CREATE PROCEDURE proc_memberDetails
@memberID int AS
SELECT * FROM member WHERE id = @memberID
GO


I received this message

Exception Details: System.Data.SqlClient.SqlException: Procedure or function proc_memberDetails has too many arguments specified.

Source Error:





Line 33: SqlDataAdapter sqlDA = new SqlDataAdapter();
Line 34: sqlDA.SelectCommand = sqlComm;
Line 35: sqlDA.Fill(dataSet);
Line 36:
Line 37: return dataSet;

The function I am using is returning a DataSet as below:

public DataSet ExecuteStoredProcSelect (string sqlProcedure, ArrayList paramName, ArrayList paramValue)

{

      DataSet dataSet = new DataSet();

      SqlConnection sqlConnect = new SqlConnection(GetDBConnectionString());

      SqlCommand sqlComm = new SqlCommand (sqlProcedure, sqlConnect);

      sqlComm.CommandType = CommandType.StoredProcedure;



      for (int n=0; n<paramName.Count; n++)

      {

            sqlComm.Parameters.Add(paramName[n].ToString(),Convert.ToInt32(paramValue[n]));

      }



      SqlDataAdapter sqlDA = new SqlDataAdapter();

      sqlDA.SelectCommand = sqlComm;

      sqlDA.Fill(dataSet);

      return dataSet;

}

If this is not the correct way, is there any other way to write a function to return a dataset as the result of the stored procedure?

Thanks.