Is it possible to bind a column for every row of dataset 1 as parameter for dataset 2 ?

I have  template dataset 1  return many rows .
and set  template parameter to bind to parameter of template dataset 2 stored procedure .

However,  I find that it only use the first row value of dataset 1 for all row as parameter value for dataset 2.

I know the answer Seeking the best answerBest Answer worth10 money ,1 people have answered

Hi Sybil,
Got your meaning . But I think it may not meet our need .  our need is
on ds1,  we return let says 3 rows.  voucher1, voucher2, voucher3.

Then on ds2 ( which is stored procedure) and take one parameter voucher_no.
The sp will use parameter voucher_no  to get amount from many tables and calculation and  return 1 value.

So we would like it
voucher1,  ( call ds2 with voucher1 as parameter and return amount 1.
voucher2, ( call ds2 with voucher2 as parameter and return amount 2.

Many thanks for your prompt reply.