Is this a Bug in Visual Studio 2005??

microsoft.public.dotnet.framework.adonet

7 Mar 2006 12:46 PM

Larry

Try the following in VS 2005:

Add a SQLCommand object to a Windows Form
Set the connection to the Northwind Database
Change the "CommandType" to "StoredProcedure"
In the "CommandText" property, select "CustOrderHist" from the combobox.

The "Parameters" collection property does not get populated.

Clear the "CommandText" property and press Enter.
Manually type in "CustOrderHist" in the "CommandText" property and press
Enter.

The "Parameters" collection now gets populated correctly.

Why doesn't the Parameters collection get populated when a stored proc is
chosen from the combo box? Is this a bug or am I missing something?

Cheers,

Larry.