My apologies. I missed the part about wanting to use SQL.
Let me see if I understand correctly... you want to change which SQL database/table is bound to a subtest based on which parent test is executing, is that correct?
It is not possible to change what database & table a subtest is actively bound to, but in the SQL world I can think of a couple of alternatives:
- Bind the subtest to some temp/scratch table. Make the parent test fill this table with the data you want the subtest to actually use. Then call the subtest. It will now use this new data you just put in the table it draws from.
- Use T-SQL in the subtest to pull the correct dataset. If needed you can have the parent test set some value somewhere in some table that the T-SQL can use so it can pull the right data from your database.
the Telerik team