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.