First, you need to construct the instance object. The constructor expects three parameters: the name of the parameter as defined by the target stored procedure, the data type of the parameter, and its length in bytes. Here is an example that constructs the instance object parameterCategoryID for the stored procedure's CategoryID parameter:

  var parameterCategoryID : SqlParameter = 
    new SqlParameter("@CategoryID", SqlDbType.Int, 4);

  parameterCategoryID.Value = categoryID;

  parameterModelName.Direction = ParameterDirection.Output;

  myCommand.Parameters.Add(parameterCategoryID);

  myProductDetails.ModelNumber = parameterModelNumber.Value;

People who read this tip also read these tips:

• Sharing the Web Service dll
• Structuring Windows Form Applications
• The Risk of Un-typed Variables
• Finding Object Hierarchy
• Writing a Classic Base Class