How Can I Build A Table Using A SP In A For Each Loop

I have a table of CategoryIDs and I want to increment through it passing each categoryID as a parameter to a stored procedure that returns the TOP 1 row, and build a new table from the the result.    I do not know how to pass the categoryID into the stored procedure.  I do not know how to begin building the new table.

public DataTable GetContractorCats()
    {
        // Generates table of all Contractor Category IDs no parameters
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings  ["ConnectionString2"].ConnectionString);
        SqlCommand cmd = new SqlCommand("GetContractorCatIDs", con);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        DataSet ds = new DataSet();
        try
        {
            da.Fill(ds, "ContractorCats");
            return ds.Tables["ContractorCats"];
        }
        catch
        { throw new ApplicationException("Data error"); }
    }

protected void Top1EachCategory()
{
    // need to build a new table row by row using a stored procedure that finds the top result from a database query

    int RowIncrement;
    RowIncrement = 0;
    DataTable dt1 = GetContractorCats();

    foreach (DataRow row in dt1.Rows)
    {

       I need to pass value of dt1 table ["CG_ID"] as a parameter to Stored Procedure called "GetTop1"
       Run the stored procedure which returns a single row if the CG_ID is found and use its field values to build each row in a new table.
       The stored procedure returns C_Name, Category_Name, C_Email, C_RCode and C_City

      RowIncrement++;
     }
    


 

}