problem with dataadapter.fill method

for some reason I get the error saying that the stored procedure is expecting a parameter that was not supplied.  Even though the parameter is being passed in OK

The code is in the code snippet window

It fails on the

dataAdapter.Fill(dataTable);

line

Even though it is getting passed through OK on this code

foreach (SqlParameter param in reportParameters)
        {
            DbParameter dbparam = dbCommand.CreateParameter();
            dbparam.Direction = ParameterDirection.Input;            
            dbparam.Value = param.Value;            
            dbCommand.Parameters.Add(dbparam);
        }

Any comments appreciated

public static DataTable GetReportDataTable(string strSprocName, List<SqlParameter> reportParameters)
	{
        string connString = ConfigurationManager.ConnectionStrings["test"].ConnectionString;
        SqlConnection sqlConnection = new SqlConnection(connString);
        DbProviderFactory pv = DbProviderFactories.GetFactory("System.Data.SqlClient");
 
        DbCommand dbCommand = sqlConnection.CreateCommand();
        dbCommand.CommandText = strSprocName;
        dbCommand.CommandType = CommandType.StoredProcedure;
        dbCommand.CommandTimeout = 6000;        
 
        foreach (SqlParameter param in reportParameters)
        {
            DbParameter dbparam = dbCommand.CreateParameter();
            dbparam.Direction = ParameterDirection.Input;            
            dbparam.Value = param.Value;            
            dbCommand.Parameters.Add(dbparam);
        }
 
        DbDataAdapter dataAdapter = pv.CreateDataAdapter();
        dataAdapter.SelectCommand = dbCommand;
 
        DataTable dataTable = new DataTable();
        dataAdapter.Fill(dataTable);
        return dataTable;      
	}

Select allOpen in new window