Can't Retrieve Columns for SP with Parameters

[remus]

Hi
I'm trying to retrieve colums for a SP with 3 string Parameters as follows
exec RptListInventoryItems @CompanyID, @DivisionID,@DepartmentID
we get error message:
Must declare the scalar variable "@CompanyID".

However we can fool the designer by putting quotes around the parameter names and turning them into strings:
exec RptListInventoryItems "@CompanyID", "@DivisionID","@DepartmentID"

This works - allowing us to retreive the columns.
It doesn't matter whether the strings are valid values for the SP.
Can we get around this problem somehow?

Thanks
Philip

[Edward]

Yes it is true. We still work on this problem. But Ado.Net does not allow to retrieve columns list from any SQL queries. It is really hard to provide compability between different DataAdapters and DataBases. This characteristic is still in process.
Thank you.