1. Create an instance of connection to the database, a SqlConnection object.
2. Create an instance of a SQL command, a SqlCommand object.
3. Mark the command as a stored procedure.
4. Execute the command.
5. Return the SqlDataReader result to the caller.

Here's an example. The ProductsDB.js file includes the method GetProductCategories(). As the name implies, this method retrieves the product categories from the database. It follows the recipe above, calling the stored procedure ProductCategoryList. This stored procedure is the simplest one, as it doesn't expect any parameters. It returns a table of all product categories in the databases. Here's the code:

  public function GetProducts(categoryID: int) : SqlDataReader {
    var myConnection : SqlConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
    var myCommand : SqlCommand = new SqlCommand("ProductsByCategory", myConnection);
    myCommand.CommandType = CommandType.StoredProcedure;
    var parameterCategoryID : SqlParameter = new SqlParameter("@CategoryID", SqlDbType.Int, 4);
    parameterCategoryID.Value = categoryID;
    myCommand.Parameters.Add(parameterCategoryID);
    myConnection.Open();
    var result : SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
    return result;
  }

People who read this tip also read these tips:

• The Personal Bar
• Checking whether a Movie is Currently Playing
• Accessing Non-API Properties
• Accessing Globals from an Object
• Jumping to the Next Sound Track