SqlCommandBuilder.DeriveParameters

[Ganga]

Hi,
When I use SqlCommandBuilder.DeriveParameter to derive the parameters of a stored procedure using a command object when it returns the parameter direction is being returned as InputOutput even though I have a stored procedure with an output parameter.Below is a sample code. In the stored procedure P_GET_SRITEST I have an Output Parameter.

connection.Open();
com = new SqlCommand();
com.Connection = connection;
com.CommandText = "P_Get_SRITEST";
com.CommandType = CommandType.StoredProcedure;
SqlCommandBuilder.DeriveParameters(com);
Once the above code is executed if is examine the command object(com) the direction for the paramters is being shown as inputoutput instead of output.

Any thoughts appreciated. Or is there any other way to detect parameters.

[CyberHawke]

My first rule on CommandBuilders is, "Don't Use Them."
While it is true that with simple SQL it is possible to get a reliable set of other command objects, it's quirky at best, and completely lazy....
If you intend to use parameterized queries, I suggest you code the whole thing by hand. This gets better results when executing the Update method on your dataadapter and you as the programmer know exactly what the code you are executing looks like.
As for the reason for the inputoutput type declaration, you have to pass in a variable and have it populated to get a value returned on an output paramter when executing a command that uses parameterized queries.

Make sense?