Procedure or function expects parameter, which was not supplied.

See more:

C#

C#4.0

I have this stored procedure in sql server

ALTER proc [dbo].[DataDetails3_proc]
@PageNum int OUTPUT
as
set nocount on
DECLARE @PageSize INT --How many rows to appear per page
--DECLARE @PageNum  INT --What page number to appear
DECLARE @Skip     INT --Working variable for where to start for page
DECLARE @SQL      VARCHAR(8000) --Holds dynamic SQL
 
--===== Set the local variables for pagesize and page
     -- PageSize and PageNum would be parameters in a stored proc
    SET @PageSize = 50
    --SET @PageNum  = 0
    SET @Skip    = @PageSize*@PageNum
 
--===== Create the dynamic SQL statement that will produce the page
SET @SQL =
'
 SELECT c.*
   FROM dbo.DataDetails c,
        (
         SELECT TOP '+STR(@PageSize)+ ' * 
           FROM dbo.DataDetails WITH (NOLOCK)
          WHERE ID NOT IN (SELECT TOP '+STR(@Skip)+' ID 
                                 FROM dbo.DataDetails
                                ORDER BY ID)
          ORDER BY ID
        ) d
  WHERE c.ID = d.ID
  ORDER BY d.ID
'
 
--===== Produce the page
   EXEC (@SQL)

Works fine, when I execute it it asks me to put parameter PageNum and it works, now I am calling this procedure in winform application and it says I have to pass parameter but I dont know what I am doing wrong, obviously I am, here is the code.

SqlDataAdapter daData = new SqlDataAdapter("DataDetails3_proc", cs);
daData.SelectCommand.CommandType = CommandType.StoredProcedure;            
dsData.Clear();            
daData.Fill(dsData, "DataDetails");
DataBS.DataSource = dsData.Tables[0];
daData.Dispose();
cs.Close();
dg.DataSource = DataBS;
SqlCommand command = new SqlCommand("DataDetails", cs);
SqlParameter param = new SqlParameter("@PageNum", SqlDbType.Int);
param.Direction = ParameterDirection.InputOutput;
param = new SqlParameter("@PageNum", page.Text);

page is textbox in which I am putting that parameter I need