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:

• Using the Parent Name to Search for DOMDocument Nodes
• Upgrading to MSXML 3.0
• Formatting Numbers in XSLT
• Avoiding Hard-Coded Numbers in XSLT
• IBuySpy's Different Uses of JScript .NET